Sunday, January 19, 2014

Here is list of most commonly used JDR_UTILS APIs used in OA Framework;
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.
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.
BEGIN
jdr_utils.listcustomizations
(p_document => ‘/oracle/apps/icx/por/wf/webui/ReqLinesNotificationsRN’);
END;
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/icx/por/wf/webui/customizations/site/0/ReqLinesNotificationsRN’);
END;
The Output would be :
xml version=’1.0′ encoding=’UTF-8′?>
xmlns=”http://xmlns.oracle.com/jrad” version=”9.0.5.4.89_560″ xml:lang=”en-US” customizes=”/oracle/apps/icx/por/wf/webui/ReqLinesNotificationsRN” xmlns:oa=”http://xmlns.oracle.com/oa”>
serverUnvalidated=”false” sortState=”no” tipType=”none” totalValue=”false” userCustomizable=”false” vAlign=”middle” viewAttr=”Attribute11″ viewName=”xxrambReqLinesNotificationsVO” warnAboutChanges=”true”
xmlns:oa=”http://xmlns.oracle.com/oa”/>

messageStyledText id=”Attribute9_a1″ adminCustomizable=”true” cellNoWrapFormat=”false” dataType=”VARCHAR2″ initSortSeq=”none” prompt=”Budget Department” queryable=”false” rendered=”true” required=”no” scope=”.” selectiveSearchCriteria=”false”
serverUnvalidated=”false” sortState=”no” tipType=”none” totalValue=”false” userCustomizable=”false” vAlign=”middle” viewAttr=”Attribute9″ viewName=”xxrambReqLinesNotificationsVO” warnAboutChanges=”true”
xmlns:oa=”http://xmlns.oracle.com/oa”/>
DELETE A DOCUMENT
DECLARE
BEGIN
jdr_utils.deletedocument(p_document => 
‘/oracle/apps/icx/por/wf/webui/customizations/site/0/ReqLinesNotificationsRN’);
END;
Created with Artisteer

0 comments: