<-----Google Analytics Code Start----> <-----Google Analytics Code Close---->
Skip to content

Green

color

Default screen resolution  Wide screen resolution  Increase font size  Decrease font size  Default font size  Skip to content Default color Pink color Green color Green color

Who's Online

We have 4 guests online

Related Items

Home
This website has now moved to http://apps2fusion.com





JDR_UTILS | Print |  E-mail
Written by Anil Passi   
Wednesday, 11 July 2007
Here I am listing my most commonly used JDR_UTILS APIs used in OA Framework. There are some scripts that I can’t live without, and these are some of them.

Note: All these operations can also be done via Functional Administrator responsibility.

JDR_UTILS.LISTDOCUMENTS

Use this API to list of all OA Framework the documents in a path/module. This script is very handy, as it provides a list of all the desired documents/extensions/personalizations in one go.

DECLARE
BEGIN
jdr_utils.listdocuments(
'/oracle/apps/per', TRUE);
END;

The script above will produce a list of all the MDS Documents in HRMS plus all the BC4J extensions done to HRMS module will be listed here too. Surely you can run this for whatever module/application you desire.


Notes on jdr_utils.listdocuments

  1. First parameter of this API can take the full path or partial path of the MDS** Page. Second parameter being TRUE will direct the API to list all Child Documents underneath that tree path

  2. You can use this API to know all the objects that have been extended/personalized in any specific module. For this, simply dump the output in a file and grep for customizations

  3. BC4J extensions [or call them substitutions] will be visible too, as the substitutions are stored as Personalization itself. For example, if iRecruitment Application Module has been extended, then a command similar to below will show the extended AM for VisitorAM

DECLARE
BEGIN
jdr_utils.listdocuments
(
'/oracle/apps/per/irc/candidateSelfService/server/',TRUE);
END;





JDR_UTILS.LISTCUSTOMIZATIONS

List of all the Personalizations/Extensions/Contents for a specific object. For example, as below, I wish to know the various levels at which a specific object has been personalized or extended.

DECLARE
BEGIN
jdr_utils.listcustomizations
(p_document =>
'/oracle/apps/per/irc/candidateSelfService/webui/RegCreateAccountPG');
END;


Notes on jdr_utils.listcustomizations

  1. To get an exact full path of the document, first use jdr_utils.listdocuments

 

 

JDR_UTILS.PRINTDOCUMENT

List of all the Personalizations/Extensions for a specific object. For example, as below, I wish to see the name of the new AM Java Class that substitutes the standard VisitorAM.

DECLARE
BEGIN
jdr_utils.printdocument
(p_document =>
'/oracle/apps/per/irc/candidateSelfService/server/customizations/site/0/VisitorAM');
END;

The result below shows to me that xxVisitorAM is the new Java AM Class that substitutes the standard VisitorAM class


Another example for jdr_utils.printDocument is to see the content of Site Level personalization on a specific page

DECLARE
BEGIN
jdr_utils.printdocument
(p_document =>
'/oracle/apps/per/irc/candidateSelfService/webui/customizations/site/0/RegCreateAccountPG');
END;

The result of this command indicates which fields/regions/beans have been hidden or effected by personalization




DELETE A DOCUMENT

OR

DELETE A PERSONALIZATION

OR

    DELETE AN EXTENSION OR A SUBSTITUTION

The title says it all. Once you have found the exact name of the document with its full path [using jdr_utils.listdocuments], you can then delete the same by using command below. For example to delete the Application Module substitution, use command

DECLARE
BEGIN
jdr_utils.deletedocument(p_document =>
'/oracle/apps/per/irc/candidateSelfService/server/customizations/site/0/VisitorAM');
END;

Comments (0)add
You must be logged in to a comment. Please register if you do not have an account yet.

busy