JDR Tables in OAF

http://happyrahoalways.blogspot.com/2017/07/jdr-tables-in-oaf-oracle-application.html

JDR Tables in OAF (oracle application Framework)

Hello

We do have only four tables in complete OAF and one API .

Listed out four tables :

1.              JDR_PATHS: Stores the path of the documents, OA Framework pages and their parent child relationship.

2.              JDR_COMPONENTS: Stores components on documents and OA Framework pages.

3.              JDR_ATTRIBUTES: Stores attributes of components on documents and OA Framework pages.

4.              JDR_ATTRIBUTES_TRANS: Stores translated attribute values of document components or OA framework pages.

and One API

JDR_UTILS

ListDocument: Provide full path of document:

only listdocument will contain two paramters, first is path and second is boolean value (true)

DECLARE
BEGIN
jdr_utils.listdocuments(‘/oracle/apps/icx/por/rer/server’, TRUE);
END;

ListCustomizations: From this we can check whether view has been extended or not

PRINTDOCUMENT: To get the XML of the object passed as parameter.
DECLARE
BEGIN
jdr_utils.printdocument('/oracle/apps/icx/por/req/server/customizations/site/0/xxPORequisitionLinesVO');

END;

DELETEDOCUMENT: if you want to delete the customizations then it will be Use to delete the customization.

DECLARE
BEGIN
jdr_utils.deletedocument(‘/oracle/apps/icx/por/req/server/customizations/site/0/xxPORequisitionLinesVO’);
END;