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
Showing posts with label Oracle EBS. Show all posts
Showing posts with label Oracle EBS. Show all posts
Wednesday, May 29, 2019
Wednesday, May 9, 2018
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
Thursday, April 12, 2018
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
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
Subscribe to:
Posts (Atom)