JDR_UTILS APIs in OAF

JDR_UTILS is a Standard API

• To query OA Framework Personalization or customizations
• To delete the OA Framework Personalization/customizations present in OA Framework metadata in the MDS repository.

Below are the procedures of JDR_UTILS

• JDR_UTILS.LISTDOCUMENTS
• JDR_UTILS.LISTCUSTOMIZATIONS
• JDR_UTILS.PRINTDOCUMENT
• JDR_UTILS.DELETEDOCUMENT

JDR_UTILS.LISTDOCUMENTS

This API is used to list of all OA Framework documents in the path/module. It provides list of all the pages/extensions/personalization.

Parameters

• Path --> Actual path of the component
• Child documents retrieve or not
• TRUE --> List out all child documents
• FALSE --> Default and not list child documents

Sample:

DECLARE

BEGIN

jdr_utils.listdocuments('/xx/oracle/apps/xx/customer/lov/', TRUE);

END;

JDR_UTILS.LISTCUSTOMIZATIONS

This API is used to list all personalization/Extensions/Contents of a specific Object or for specific OAF page in the Oracle Application.

Parameter

• Document name with path

Sample:

DECLARE

BEGIN

jdr_utils.listcustomizations(p_document => '/xx/oracle/apps/xx/customer/webui/SearchPG');

END;

JDR_UTILS.PRINTDOCUMENT

This API is used to list all the components of the OAF Page. Like View Object , Controller , Application Module of the OAF Page.

Parameter

• Document name with path

Sample:

BEGIN

jdr_utils.printDocument('/xx/oracle/apps/xx/customer/webui/SearchPG');

END;

JDR_UTILS.DELETEDOCUMENT

This API is used to delete the personalization and extensions for the OAF Page.

Parameter

• Document name with path

Sample:

BEGIN

jdr_utils.deletedocument(p_document => '/xx/oracle/apps/xx/customer/server/XXCustVO');

END;