Important to know

Following profile options need to set to get the 'Form Personalization' page in OAF

• FND: Diagnostics
• Personalize Self-Service Defn

Root Path need to set in following profile to import and export xml files for migration.

• FND DocumentRoot Path 

'Export MIME type'  is used to get data in desired format.

IE10 is now certified with EBS 11i and R12.1.x, and system per-requisites will be available in Oracle Support not 3894221.

Oracle WF local tables are WF_LOCAL_ROLES and WF_LOCAL_USER_ROLES
Patch 171703 patch will synchronize the oracle wf tables with oracle apps workflow tables.
'Synchronize WF LOCAL Tables' concurrent program will synchronize WF local tables with the user and role information stored in the product application tables.
Oracle WF provides a request set named Synchronize workflow LOCAL Tables  that contains ten instances of the synchronize WF Local tables program, one for each originating system. You can use this request set to submit requests for all the originating systems at once. Note that because this program is incompatible with itself, each request is defined as a separate stage and the stages will run sequentially. By default, this request set is scheduled to run once a day to provide a minimal level of synchronization. You can modify the schedule for the request set to perform synchronization more frequently.
Originating system names are stored in FND_ORIG_SYSTEMS look-up type.

GMI_ITEM_WRP.GET_FIELD to get ht amount after decimal point.
AP_AMOUNT.UTILITIES.AP_CONVERT_NUMBER used to convert number to amount description.

DBMS_METADATA.GET_DDL('VIEW','VIE_NAME','SCHEMA_NAME') will be used to get the ddl of an object. Other important once are DBMS_ASSERT, DBMS_DDL, DBMS_SQL.

ePrentise will not update hard-code values in the application code.

As per ePrentise , Auto-Accounting setups should be dropped and recreate after running ePrentise.  After resetting the setups Invoice was created with no issues, and all distributions are showing update segments.  Else, Manual AR Invoice  and Service contracts Invoice will show only segments which were there before running the ePrentise.

All mandatory DFFs need to be unchecked while upgrading EBS 11i to R12.1.3

Override Approver will work only if, attribute 'PA Overriding Approver' is required, for 'OTL Deposit Process Mapping'


XML Bursting program error out with java.io.FileNotFoundException.
    The parent concurrent program completed successfully and the bursting program error out.
Sol: Please remove or rename the xdodebug.cfg which is located in the $AF_JRE_TOP/jre/lib   OR
$AR_JRE_TOP/lib  OR  $AR_JRE_TOP/resource directory. Also, the  'pdf' in bursting file should be in small letters as show in below tag

<xapi:document output="RFQ_REPORT" output-type="pdf" delivery="123">

Password change from back end.

set serveroutput on

DECLARE

   V_USER_NAME          varchar2 (100) := 'JBERILA';

   v_new_password   VARCHAR2 (100) := 'welcome123';

   v_status                   BOOLEAN              := NULL;

BEGIN

   v_status := fnd_user_pkg.changepassword (v_user_name, v_new_password);

  COMMIT;

   DBMS_OUTPUT.put_line (   'Password is changed successfully for the user '

                         || v_user_name

                        );

EXCEPTION

   WHEN OTHERS

   THEN

      DBMS_OUTPUT.put_line

         (   'Error  '

          || SQLERRM

         );

END;

Customer Standard Query:

SELECT LOC.ADDRESS1  ADDRESS_LINE_1,
    SITE.LOCATION,
    PARTY.PARTY_NAME CUSTOMER_NAME,
    SITE.SITE_USE_ID  ORGANIZATION_ID,
    SITE.LOCATION LOCATION_CODE,
    LOC.ADDRESS2 ,
    LOC.ADDRESS3 ,
    LOC.ADDRESS4 ,
    DECODE(LOC.CITY,NULL, NULL, LOC.CITY
    || ', ')
    ||DECODE(LOC.state, NULL, loc.Province
    || ', ', LOC.state
    || ', ')
    || DECODE(LOC.postal_code,NULL, NULL, LOC.postal_code
    || ', ')
    || DECODE(LOC.COUNTRY, null, null, LOC.COUNTRY) ADDRESS_LINE_5,
    CUST_ACCT.CUST_ACCOUNT_ID CUSTOMER_ID,
    CUST_ACCT.ACCOUNT_NUMBER  CUSTOMER_NUMBER,
    ACCT_SITE.STATUS  ACCT_SITE_STATUS,
    CUST_ACCT.STATUS CUST_ACCT_STATUS,
    site.status site_status,
    site.site_use_code,
    acct_site.cust_acct_site_id,
   'A' Dummy
  FROM HZ_CUST_ACCT_SITES ACCT_SITE,
    HZ_PARTY_SITES PARTY_SITE,
    HZ_LOCATIONS LOC,
    HZ_CUST_SITE_USES_ALL SITE,
    HZ_PARTIES PARTY,
    HZ_CUST_ACCOUNTS CUST_ACCT
  WHERE SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
  AND ACCT_SITE.PARTY_SITE_ID  = PARTY_SITE.PARTY_SITE_ID
  and PARTY_SITE.LOCATION_ID   = LOC.LOCATION_ID
  AND ACCT_SITE.CUST_ACCOUNT_ID=CUST_ACCT.CUST_ACCOUNT_ID
  AND CUST_ACCT.PARTY_ID       =PARTY.PARTY_ID
  AND SITE.ORG_ID              = ACCT_SITE.ORG_ID
  and ACCT_SITE.CUST_ACCOUNT_ID=CUST_ACCT.CUST_ACCOUNT_ID
  AND PARTY.PARTY_NAME = 'R12-Customer-CEMLI';

Sales Order Pending for Approval:

SELECT ooh.order_number ,subject,begin_date, original_recipient,from_user,to_user

  FROM WF_NOTIFICATIONS WF

    , oe_order_headers_all ooh

WHERE WF.message_type = 'OEOH'

  AND WF.STATUS= 'OPEN'

  AND WF.ITEM_KEY = OOH.HEADER_ID;


SELECT b.database_object_display_name,NAME,b.PRECEDENCE,SEQUENCE_NO,SRC_TYPE,SRC_DATABASE_OBJECT_NAME,SRC_API_PKG,SRC_API_FN,SRC_CONSTANT_VALUE,SRC_ATTRIBUTE_CODE,SRC_SYSTEM_VARIABLE_EXPR,SRC_PROFILE_OPTION
FROM OE_DEF_ATTR_RULES_V  A
    , OE_DEF_ATTR_CONDNS_V B
WHERE A.ATTR_DEF_CONDITION_ID = B.ATTR_DEF_CONDITION_ID
  AND B.APPLICATION_DISPLAY_NAME='Order Management'
ORDER BY 1,2,3,4;

Below query provides list of descriptive flex fields: