Oracle Applications Insight

Wednesday, May 29, 2019

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

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

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

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

Friday, June 10, 2016

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.

Friday, July 31, 2015

How to remove the Concurrent Program from a Request Group

SET SERVEROUTPUT ON

spool /tmp/XXCDS_HRRPTXXX_REMOVE_RG.TXT
WHENEVER SQLERROR EXIT FAILURE ROLLBACK

BEGIN
  apps.fnd_program.remove_from_group(program_short_name  => 'XXCDS_HREXT002_EMP_RECT_CP', -- Program Short Name
                                     program_application => 'XXCDS', -- Application Short Name
                                     request_group       => 'XXCDS Audit Request Group', -- Request Group Name
                                     group_application   => 'XXCDS'); -- Application Short Name
                            
  dbms_output.put_line('Concurrent Program has been removed from request group Successfully ');
  COMMIT;
EXCEPTION
  WHEN NO_DATA_FOUND
  THEN
    dbms_output.put_line ('Concurrent Program has already been removed from the Request group'); 
  WHEN OTHERS
  THEN
    dbms_output.put_line ('Others Exception Removing Conc Program. ERROR:' || SQLERRM); 
END;
/
SHOW ERROR
SPOOL OFF

Pages