How to check import errors from Order Import R12

Use the below Select statement to verify.

SELECT OPT.*

  FROM OE_PROCESSING_MSGS OPM,

       OE_PROCESSING_MSGS_TL OPT

WHERE OPM.TRANSACTION_ID = OPT.TRANSACTION_ID

   AND ORIGINAL_SYS_DOCUMENT_REF = '4347358'; -- This is Req Number

How to Download/Upload XML Data Template Definition

How to DOWNLOAD Data Template Definition in Oracle EBS

FNDLOAD apps/***** 0 Y DOWNLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXEE_OKCTERM.ldt XDO_DS_DEFINITIONS APPLICATION_SHORT_NAME="OKC" TEMPLATE_CODE="XXEE_OKCTERM"

How to UPLOAD Data Template Definition in Oracle EBS

FNDLOAD apps/***** 0 Y UPLOAD $XDO_TOP/patch/115/import/xdotmpl.lct XXEE_OKCTERM.ldt

Oracle EBS R12 AME Important Tables

select * from AME_ACTIONS

select * from AME_ACTIONS_TL

select * from AME_ACTION_TYPES

select * from AME_ACTION_TYPES_TL

select * from AME_ACTION_TYPE_CONFIG

select * from AME_ACTION_TYPE_USAGES

select * from AME_ACTION_USAGES

select * from AME_APPROVALS_HISTORY

select * from AME_APPROVAL_GROUPS

select * from AME_APPROVAL_GROUPS_TL

select * from AME_APPROVAL_GROUP_CONFIG

select * from AME_APPROVAL_GROUP_ITEMS

select * from AME_APPROVAL_GROUP_MEMBERS

select * from AME_APPROVER_TYPES

select * from AME_APPROVER_TYPE_USAGES

select * from AME_ATTRIBUTES

select * from AME_ATTRIBUTES_TL

select * from AME_ATTRIBUTE_USAGES

select * from AME_CALLING_APPS

select * from AME_CALLING_APPS_TL

select * from AME_CONDITIONS

select * from AME_CONDITION_USAGES

select * from AME_CONFIG_VARS

select * from AME_CONFIG_VARS_TL

select * from AME_EXCEPTIONS_LOG

select * from AME_FIELD_HELP

select * from AME_HELP

select * from AME_ITEM_CLASSES

select * from AME_ITEM_CLASSES_TL

select * from AME_ITEM_CLASS_USAGES

select * from AME_MANDATORY_ATTRIBUTES

select * from AME_REC_ACCESS_TRANS

select * from AME_RULES

select * from AME_RULES_TL

select * from AME_RULE_USAGES

select * from AME_STRING_VALUES

select * from AME_TEMP_DELETIONS

select * from AME_TEMP_HANDLER_STATES

select * from AME_TEMP_INSERTIONS

select * from AME_TEMP_OLD_APPROVER_LISTS

select * from AME_TEMP_TRANSACTIONS

select * from AME_TEMP_TRANS_ATT_VALUES

select * from AME_TEMP_TRANS_LOCKS

select * from AME_TEST_TRANSACTIONS

select * from AME_TEST_TRANS_ATT_VALUES

select * from AME_TRANS_APPROVAL_HISTORY

select * from AME_TXN_APPROVERS

How to open Payables or AP Period in Oracle EBS

Navigate to Payables Manager and Click on “Control Payables Periods” sub menu under “Accounting”

Select the period you want to open and select the value as “Open” from the  List of Values

Click on Open and Save the form. You are all set.