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;