jdr_utils in oaf

jdr_utils in oaf

 

JDR_UTILS is a Standard API which has procedures and functions to query OA Framework Personalizations/customizations and to delete the OA Framework Personalizations/customizations present in OA Framework metadata in the MDS repository.

These are the below JDR_UTILS Procedure and Function with the detail descriptions.

 

How to get the path of the page to use in the jdr_utils in oaf

 

 

JDR_UTILS.LISTDOCUMENTS

Use this API to list of all OA Framework documents in the given path/module. It provides list of all the pages/extensions/personalizations.

Example:

DECLARE BEGIN jdr_utils.listdocuments('/oracle/apps/oie/lov/', TRUE); END; /

DECLARE BEGIN jdr_utils.listdocuments('/oracle/apps/per/probation/', TRUE); END; /

JDR_UTILS.LISTCUSTOMIZATIONS

Use this API to list all personalizations/Extensions/Contents of a specific Object or for specific OAF page in the Oracle Application.

Example:

DECLARE BEGIN jdr_utils.listcustomizations (p_document => '/oracle/apps/oie/lov/webui/ExpensePG'); END; /

DECLARE BEGIN jdr_utils.listcustomizations (p_document => '/xxhr/oracle/apps/per/probation/webui/AddKpiPG'); END; /

JDR_UTILS.PRINTDOCUMENT

This procedure will list all the conpennets of the OAF Page. Like VO , CO , AM of the OAF Page.

Example:

jdr_utils.printDocument('/oracle/apps/xxap/oie /webui/ExpPG');

DECLARE begin jdr_utils.printDocument('/xxhr/oracle/apps/per/probation/webui/TrackPG'); EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE(SQLERRM); END; /

JDR_UTILS.DELETEDOCUMENT

Using this Procedure we can delete the OAF Personalization and OAF Extensions for the OAF Page. We can remove the Personalizations and the Extensions of the OAF page using this Procedure.. For example to delete the VO substitution, use command

Example:

DECLARE BEGIN jdr_utils.deletedocument(p_document => '/oracle/apps/xxap/oie/server/XXSuppVO'); END; /