Thursday, 20 June 2019

Script to find JDR_UTILS for the OAF page from Back end

--------------------------------------------JDR_UTILS----------------------------------

/******************* 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.

Parameters:
1. Full/Partial path of MDS repository
2. TRUE will direct the API to list all Child Documents underneath that tree path

Example:

BEGIN
   jdr_utils.listdocuments ('/oracle/apps/eam/workorder/', TRUE);
END;
/

/******************* JDR_UTILS.LISTCUSTOMIZATIONS  *******************/   
Use this API to list all personalizations/Extensions/COntents of a specific Object.

Example:

BEGIN
   jdr_utils.listcustomizations (
      p_document => '/xxprod/oracle/apps/eam/workorder/webui/CreateUpdateWOPG');
END;
/

 /*******************   JDR_UTILS.PRINTDOCUMENT    *******************/   

This procedure lists the contents of a specific object.
For example, using below code, we can get all the components(items and page properties) of the page -> TrackPG

BEGIN
   jdr_utils.printDocument (
      '/xxprod/oracle/apps/eam/workorder/webui/CreateUpdateWOPG');
EXCEPTION
   WHEN OTHERS
   THEN
      DBMS_OUTPUT.PUT_LINE (SQLERRM);
END;
/

/******************* JDR_UTILS.DELETEDOCUMENT   *******************/

You can delete a page/personalization/extension by using command below.
For example to delete the Application Module substitution, use command

BEGIN
   jdr_utils.deletedocument (
      p_document => '/oracle/apps/eam/workorder/server/WOCreateUpdateAM');
END;
/

No comments:

Post a Comment