Hello
We do have only four tables in complete OAF and one API .
Listed out four tables :
DECLARE
BEGIN
jdr_utils.deletedocument(‘/oracle/apps/icx/por/req/server/customizations/site/0/xxPORequisitionLinesVO’);
END;
We do have only four tables in complete OAF and one API .
Listed out four tables :
- JDR_PATHS: Stores the path of the documents, OA Framework pages and their parent child relationship.
- JDR_COMPONENTS: Stores components on documents and OA Framework pages.
- JDR_ATTRIBUTES: Stores attributes of components on documents and OA Framework pages.
- 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;
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');
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.
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;