Add Responsibility to a User in oracle apps

Syntax:

fnd_user_pkg.addresp(username => v_user_name

,resp_app => 'SYSADMIN'

,resp_key => 'SYSTEM_ADMINISTRATOR'

,security_group => 'STANDARD'

,description => 'Auto Assignment'

,start_date => SYSDATE - 10

,end_date => SYSDATE + 1000);

Instance Migration Scripts - AOL messages and Lookups

--  Check Folder option columns

SELECT *

  FROM apps.fnd_folder_columns

 WHERE folder_id IN (

              SELECT folder_id

                FROM apps.fnd_folders

               WHERE NAME = 'OM' AND OBJECT = 'OE_ORDERS'

                     AND public_flag = 'Y')

   AND item_prompt = 'Pricing Contract'

-- AOL Messages

  SELECT *

    FROM fnd_new_messages

   WHERE message_name IN

            ('XXZP_INVALID_TEMPLATE_CHANGE',

             'XXZP_ITEM_COST_DEFINED',

             'XXZP_BATCH_SELECTION',

             'XXZP_NEW_BATCH',

             'XXZP_RECORD_ERROR')

ORDER BY message_name

-- Lookups

SELECT *

  FROM apps.fnd_lookup_values

 WHERE lookup_type IN ('XYZ_EC_ORDERTYPE_LKP')

Adding concurrent program to a request group

Adding conc prog to a request group

---------------------------------

DECLARE

   v_program_short_name    VARCHAR2 (200);

   v_program_application   VARCHAR2 (200);

   v_request_group         VARCHAR2 (200);

   v_group_application     VARCHAR2 (200);

Instance Migration Scripts - XML Publisher reports

-- Query to check XML Publisher Verification

SELECT b.*

FROM apps.xdo_lobs l, apps.xdo_templates_b b

WHERE l.application_short_name = 'QP'

AND l.lob_code IN ('XYZ123')

AND l.application_short_name = b.application_short_name