Oracle Fusion, Oracle E-Business Suite

Tips, Tricks, Articles about Oracle E-Business Suite,Oracle Fusion, Oracle 11i, Oracle PL/Sql, Workflow, Order-to-Cash, Procurement-to-Pay, CRM, SOA, BPEL, WSDL, XML, OAF

JDR_UTIL – OAF Development Utility

Posted by Senthilkumar on May 24, 2010

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 will 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”>
<modifications>
<move element=”ReqLinesTable” after=”ContractorStatusHelpText”/>
<move element=”Description” after=”Line”/>
<move element=”ItemNumber” after=”Description”/>
<move element=”ItemRevision” after=”ItemNumber”/>
<move element=”SuggSupplier” after=”ItemRevision”/>
<move element=”SuggSite” after=”SuggSupplier”/>
<move element=”Location” after=”SuggSite”/>
<move element=”ContractorStatus” after=”Location”/>
<move element=”ContractorName” after=”ContractorStatus”/>
<move element=”StartDate” after=”ContractorName”/>
<move element=”EndDate” after=”StartDate”/>
<move element=”NeedBy” after=”EndDate”/>
<move element=”CostCenter” after=”NeedBy”/>
<move element=”Uom” after=”CostCenter”/>
<move element=”Quantity” after=”Uom”/>
<move element=”TxnPriceFlowLayoutRN” after=”Quantity”/>
<move element=”FuncCurrencyUnitPrice” after=”TxnPriceFlowLayoutRN”/>
<move element=”TxnAmountFlowLayoutRN” after=”FuncCurrencyUnitPrice”/>
<move element=”FuncCurrencyAmount” after=”TxnAmountFlowLayoutRN”/>
<move element=”Requestor” after=”FuncCurrencyAmount”/>
<insert after=”Requestor”>
<oa:messageStyledText id=”Attribute11_12″ adminCustomizable=”true” cellNoWrapFormat=”false” dataType=”VARCHAR2″ initSortSeq=”none” prompt=”In Budget?” queryable=”false” rendered=”true” required=”no” scope=”.” selectiveSearchCriteria=”false”
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”/&gt;
</insert>
<insert after=”Requestor”>
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”/&gt;
</insert>
</modifications>
</customization>

DELETE A DOCUMENT

DECLARE
BEGIN
jdr_utils.deletedocument(p_document =>
‘/oracle/apps/icx/por/wf/webui/customizations/site/0/ReqLinesNotificationsRN’);
END;

Thanks..

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

 
%d bloggers like this: