OAF VO Binding Styles

Following are the binding styles that can be used in the OAF screens.

Oracle Positional: This style represents parameters as colons followed by numbers, as in the following code fragment:WHERE bar = :1 AND foo = :2 In this style, the numbers are just for easier readability: Parameters are passed into the view object in the order in which the numbers occur. The above fragment, for example, is equivalent to WHERE bar = :70 AND foo = :3

Oracle Named: This style represents parameters as colons followed by identifiers, as in the following code fragment:WHERE bar = :barparam AND foo = :fooparam Unlike the positional styles, the names of the parameters are actually used when the application fills the parameter values

JDBC Positional: This style represents parameters as question marks, as in the following code fragment:WHERE foo = ? AND bar = ?. This should be used only if you are working with non-oracle database.

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.