Profile options in OAF:
• Personalize Self-Service Defn
– Yes to allow ‘Personalize’ button to appear at the top of the page
• FND: Personalization Region Link Enabled
– Yes to display all the regional links above each region
– Minimal to display key regional links
• Disable Self-Service Personal
– Yes will disable all personalizations at any level
• FND: Diagnostics
– Turns on ‘About this Page’
• FND: Personalization Document Root Path (new in 11.5.10)
– Required to migrate personalizations
– Set this profile option to a tmp directory with open (777) permissions
********************************************************************************
JDR API
jdr_utils.listcustomizations();
jdr_utils.printdocument();
jdr_utils.deletedocument();
Command list for deleting substitution-
SQL> exec jdr_utils.listcustomizations('/oracle/apps/pos/changeorder/server/PosRevisionHistoryVO');
/oracle/apps/pos/changeorder/server/customizations/site/0/PosRevisionHistoryVO
PL/SQL procedure successfully completed.
SQL> exec jdr_utils.deletedocument('/oracle/apps/pos/changeorder/server/customizations/site/0/PosRevisionHistoryVO');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> exec jdr_utils.listcustomizations('/oracle/apps/pos/changeorder/server/PosRevisionHistoryVO');
PL/SQL procedure successfully completed.
Similarly you can also list all the customization done on a particular page or region or even VO using below commands:
SQL>exec jdr_utils.listcustomizations('/oracle/apps/asn/lead/webui/ASNLeadQryRN');
..............
..............
SQL>exec jdr_utils.listcustomizations('/oracle/apps/asn/dashboard/webui/DashboardPG ');
..............
..............
SQL>exec jdr_utils.listcustomizations('/oracle/apps/ar/hz/components/contact/server/HzPuiContRelTableVO');
...............
...............
JDR Utility Tables which store the personalization details:
JDR_ATTRIBUTES
JDR_ATTRIBUTES_TRANS
JDR_COMPONENTS
JDR_PATHS
********************************************************************************
XML Import and Export Commands for OAF pages:
1) Command to import the XML page into the database
adjava -mx128m -nojit oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/xxvm/iExpensePolicyPage/webui/iExpensePolicyPG.xml -username apps -password appspwd -dbconnection "(description=(address=(protocol=tcp)(host=<host name>)(port=1521))(connect_data=(sid=<SID>)))" -rootdir $JAVA_TOP
OR
2) Command to Export the XML page from the database:
java oracle.jrad.tools.xml.exporter.XMLExporter oracle/apps/ap/oie/audit/webui/OIE_AUD_AUDIT_PAGE -rootdir /export/home/applvmd -username apps -password appspwd -dbconnection "(description=(address=(protocol=tcp)(host=<host name>)(port=1521))(connect_data=(sid=<SID>)))"
3) Command for VO substitution in an instance.
adjava \
oracle.jrad.tools.xml.importer.JPXImporter $HOME/CHR11/XXDOMI_POS_SUMMARY_VIEW/iSupplierPortal.jpx \
********************************************************************************
How to Find the Correct Version of JDeveloper to Use with E-Business Suite 11i or Release 12.x (Doc ID 416708.1)
1) First when you log in oracle applications, type in the below in the URL
http:///OA_HTML/OAInfo.jsp
2) Then you get the Oracle Apps version you working on like below
OA Framework Version Information
OA Framework Version 11.5.10.2CU.
MDS Version 9.0.5.4.81 (build 481)
UIX Version 2.2.18
BC4J Version 9.0.3.13.51
3) so my version of apps (OAF) is 11.5.10.2CU
4) go to METALINK and search for Doc ID: Note:416708.1
there you find the below in form of a TABLE.
https://metalink.oracle.com/metalink/plsql/f? p=130:14:7711961564797583862::::p14_database_id,p14_doc id,p14_show_header,p14_show_help,p14_black_frame,p14_fo nt:NOT,416708.1,1,1,1,helvetica
click the above link
there you can select the PATCH as per your version of OAF in u r Oracle Apps.
MINE is PATCH 4573517 for 11.5.10.2CU
Another alternative approach to find the OA Version
Identify the OA Framework version in your instance by activating diagnostics and click the "About This Page" from any OAF page. Click the "Technology Components" tab. The OA Framework version in the top row of the table can then be matched to the JDeveloper Patch.
Release 12.1
Release 12.2
• Personalize Self-Service Defn
– Yes to allow ‘Personalize’ button to appear at the top of the page
• FND: Personalization Region Link Enabled
– Yes to display all the regional links above each region
– Minimal to display key regional links
• Disable Self-Service Personal
– Yes will disable all personalizations at any level
• FND: Diagnostics
– Turns on ‘About this Page’
• FND: Personalization Document Root Path (new in 11.5.10)
– Required to migrate personalizations
– Set this profile option to a tmp directory with open (777) permissions
********************************************************************************
JDR API
jdr_utils.listcustomizations();
jdr_utils.printdocument();
jdr_utils.deletedocument();
Command list for deleting substitution-
SQL> exec jdr_utils.listcustomizations('/oracle/apps/pos/changeorder/server/PosRevisionHistoryVO');
/oracle/apps/pos/changeorder/server/customizations/site/0/PosRevisionHistoryVO
PL/SQL procedure successfully completed.
SQL> exec jdr_utils.deletedocument('/oracle/apps/pos/changeorder/server/customizations/site/0/PosRevisionHistoryVO');
PL/SQL procedure successfully completed.
SQL> commit;
Commit complete.
SQL> exec jdr_utils.listcustomizations('/oracle/apps/pos/changeorder/server/PosRevisionHistoryVO');
PL/SQL procedure successfully completed.
Similarly you can also list all the customization done on a particular page or region or even VO using below commands:
SQL>exec jdr_utils.listcustomizations('/oracle/apps/asn/lead/webui/ASNLeadQryRN');
..............
..............
SQL>exec jdr_utils.listcustomizations('/oracle/apps/asn/dashboard/webui/DashboardPG ');
..............
..............
SQL>exec jdr_utils.listcustomizations('/oracle/apps/ar/hz/components/contact/server/HzPuiContRelTableVO');
...............
...............
JDR Utility Tables which store the personalization details:
JDR_ATTRIBUTES
JDR_ATTRIBUTES_TRANS
JDR_COMPONENTS
JDR_PATHS
********************************************************************************
XML Import and Export Commands for OAF pages:
1) Command to import the XML page into the database
adjava -mx128m -nojit oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/xxvm/iExpensePolicyPage/webui/iExpensePolicyPG.xml -username apps -password appspwd -dbconnection "(description=(address=(protocol=tcp)(host=<host name>)(port=1521))(connect_data=(sid=<SID>)))" -rootdir $JAVA_TOP
OR
adjava \
oracle.jrad.tools.xml.importer.XMLImporter \
$HOME/CHR11/XXDOMI_POS_SUMMARY_VIEW/oracle/apps/pos/planning/webui/customizations/site/0/PosHorizSchdCVPG.xml \
-rootdir $HOME/CHR11/XXDOMI_POS_SUMMARY_VIEW \
-rootPackage / \
-username apps \
-password pwd \
-dbconnection "<Host Name>:<Port Number>:<SID>"
2) Command to Export the XML page from the database:
java oracle.jrad.tools.xml.exporter.XMLExporter oracle/apps/ap/oie/audit/webui/OIE_AUD_AUDIT_PAGE -rootdir /export/home/applvmd -username apps -password appspwd -dbconnection "(description=(address=(protocol=tcp)(host=<host name>)(port=1521))(connect_data=(sid=<SID>)))"
3) Command for VO substitution in an instance.
adjava \
oracle.jrad.tools.xml.importer.JPXImporter $HOME/CHR11/XXDOMI_POS_SUMMARY_VIEW/iSupplierPortal.jpx \
-username apps \
-password pwd \
-dbconnection "<Host Name>:<Port Number>:<SID>"
********************************************************************************
How to Find the Correct Version of JDeveloper to Use with E-Business Suite 11i or Release 12.x (Doc ID 416708.1)
1) First when you log in oracle applications, type in the below in the URL
http:///OA_HTML/OAInfo.jsp
2) Then you get the Oracle Apps version you working on like below
OA Framework Version Information
OA Framework Version 11.5.10.2CU.
MDS Version 9.0.5.4.81 (build 481)
UIX Version 2.2.18
BC4J Version 9.0.3.13.51
3) so my version of apps (OAF) is 11.5.10.2CU
4) go to METALINK and search for Doc ID: Note:416708.1
there you find the below in form of a TABLE.
https://metalink.oracle.com/metalink/plsql/f? p=130:14:7711961564797583862::::p14_database_id,p14_doc id,p14_show_header,p14_show_help,p14_black_frame,p14_fo nt:NOT,416708.1,1,1,1,helvetica
click the above link
there you can select the PATCH as per your version of OAF in u r Oracle Apps.
MINE is PATCH 4573517 for 11.5.10.2CU
Another alternative approach to find the OA Version
Identify the OA Framework version in your instance by activating diagnostics and click the "About This Page" from any OAF page. Click the "Technology Components" tab. The OA Framework version in the top row of the table can then be matched to the JDeveloper Patch.
Release 11i
OA Framework 5.10
patch
|
Oracle JDeveloper 9i
Patch
|
ATG.PF.H (patch
3438354 or Oracle Applications 11.5.10)
|
Patch 4045639 9IJDEVELOPER WITH OA
EXTENSION ARU FOR FWK.H
|
ATG PF CU1 (patch
4017300)
|
Patch 4141787 9IJDEVELOPER WITH OA
EXTENSION ARU FOR CU1
|
ATG PF CU2 (patch
4125550)
|
Patch 4573517 Oracle9i JDeveloper with OA
Extension for 11.5.10 CU2
|
11i.ATG_PF.H RUP3
(patch 4334965)
|
Patch 4725670 9IJDEVELOPER WITH OA
EXTENSION ARU FOR 11i10 RUP3
|
11i.ATG_PF.H RUP4
(patch 4676589)
|
Patch 5455514 9IJDEVELOPER WITH OA
EXTENSION ARU FOR 11i10 RUP4
|
11i.ATG_PF.H RUP5
(patch 5473858)
|
Patch 6012619 9IJDeveloper With OA
Extension ARU FOR 11i10 RUP5
|
11i.ATG_PF.H.RUP6
(patch 5903765)
|
Patch 6739235 9IJDeveloper With OA
Extension ARU FOR 11i10 RUP6
|
11i.ATG_PF.H.delta.7
(patch 6241631)
|
Patch 8751878 9I JDEVELOPER WITH OA
EXTENSION ARU FOR 11I RUP7
|
Release 12.0
ATG Release 12 Version
|
Oracle
JDeveloper 10g Patch
|
12.0.0
|
Patch 5856648 10g Jdev with OA Extension
|
12.0.1 (patch
5907545)
|
Patch 5856648 10g Jdev with OA Extension
|
12.0.2 (patch
5484000 or 5917344)
|
Patch 6491398 10g Jdev with OA Extension
ARU for R12 RUP2 (replaces 6197418)
|
12.0.3 (patch
6141000 or 6077669)
|
Patch 6509325 10g Jdev with OA Extension
ARU for R12 RUP3
|
12.0.4 (patch 6435000
or 6272680)
|
Patch 6908968 10G JDEVELOPER WITH OA
EXTENSION ARU FOR R12 RUP4
|
12.0.5 (No new ATG
code released)
|
No new JDev patch
required
|
12.0.6 (patch
6728000 or patch 7237006)
|
Patch 7523554 10G Jdeveloper With OA
Extension ARU for R12 RUP6
|
Release 12.1
ATG Release 12.1
Version
|
Oracle
JDeveloper 10g Patch
|
12.1 (Controlled
Release - only included for completeness)
|
Patch 7315332 10G Jdev with OA Extension
ARU for R12.1 (Controlled Release)
|
12.1.1 (rapidInstall
or patch 7303030)
|
Patch 8431482 10G Jdeveloper with OA
Extension ARU for R12.1.1
|
12.1.2 (patch 7303033
or patch 7651091)
|
Patch 9172975 10G JDEVELOPER WITH OA
EXTENSION ARU FOR R12.1.2
|
12.1.3
(patch 9239090 or patch 8919491)
|
Patch 9879989 10G JDEVELOPER WITH OA
EXTENSION ARU FOR R12.1.3
|
12.1.3.1
(patch 11894708)
|
Patch 9879989 10G JDEVELOPER WITH OA
EXTENSION ARU FOR R12.1.3
|
12.1.3.2
(patch 15880118)
|
Patch 9879989 10G JDEVELOPER WITH OA
EXTENSION ARU FOR R12.1.3
|
Release 12.2
ATG Release 12.2
Version
|
Oracle
JDeveloper 10g Patch
|
12.2
|
Patch 17513160 10G JDeveloper with OA
Extension ARU for R12.2, certfied on Windows 7, Windows XP-SP2, and Linux.
Preferred web browser is Microsoft Internet Explorer 6.0 or above.
|
12.2.3
|
Patch 17888411 10G JDeveloper with OA
Extension ARU for R12.2.3, certfied on Windows 7, Windows XP-SP2, and Linux.
Preferred web browser is Microsoft Internet Explorer 8.0 or above for the
Skyros Look-and-Feel and Internet Explorer 6.0 or above for the Swan
Look-and-Feel.
|
