Useful scripts and tips for Apps(OAFramework) Customization and Implementation :Introduction
This article is best viewed on FireFox Broswer
Purpose
This document helps the developer to get the scripts for the Apps Customization development. This will have all the OAFramework related components download from the server and upload the components from the laptop.
This helps to create the pack for the customization deployment. This contains the important Profile Options used in OAFramework and how to find the correct version of Jdeveloper for 11i and Rel12.
This document assumes that the reader has a basic knowledge of OA Frmework page creation and deployment and running basic UNIX commands.
1.2 Background
This document should be used for creating pack for the customization done in OAFramework or to download the messages, profile options, OAFramework pages… etc.
2 Scripts for OAFramework Customization.
2.1 OAFramework page related scripts.2.2 Upload PG.xml files from the jdeveloper directory.
2.3 Change the package structure, < > according to your project
1. Upload a Single PG.xml file
<JDEV_DIR>\jdevbin\jdev\bin\import <JDEV_DIR>\jdevbin\jdev\myclasses\xxt\oracle\apps\pon\registration\webui\XXTSupplierRegistrationPG.xml -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<DB_HOST_NAME>)(PORT=<DB_PORT>))(CONNECT_DATA=(SID=<DB_SID>)))" -rootDir <JDEV_DIR>\jdevbin\jdev\myclasses\ -rootPackage /
2. Upload multiple PG.xml files
<JDEV_DIR>/jdevbin/jdev/bin/import <JDEV_DIR>/jdevbin/jdev/myclasses /oracle/apps/xxpo/pdt/ordering/webui -rootDir <JDEV_DIR>/jdevbin/jdev/myclasses / -username apps -password <APPS_PASSWORD> -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<DB_HOSTNAME>)(PORT=<DB_PORT>))(CONNECT_DATA=(SID=<DB_SID>)))" -includeSubpackages -jdk13 -mmddir <JDEV_DIR>/jdevbin/jdev/lib/ext/jrad/config/mmd -rootPackage /
3. View the PG.xml from the database in TOAD or SQLDeveloper.
Begin
Jdr_utils.printDocument(‘/oracle/apps/pon/award/completion/webui/ponCompleteAward2PG’);
End;
4. To find the personalized file path for a particular PG.xml
begin
jdr_utils.listCustomizations('/oracle/apps/fnd/framework/navigate/webui/AppsNavigateMobilePG');
end;
Will give /oracle/apps/fnd/framework/navigate/webui/customizations/site/0/AppsNavigateMobilePG
When the page is personalized at site level.
5. To download the personalized file, first run the above script in SQL, that will display the full path for the personalized file, then run the below command
Eg.
Begin
Jdr_utils.printDocument(‘/oracle/apps/fnd/framework/navigate/webui/customizations/site/0/AppsNavigateMobilePG’);
End;
Save the file as AppsNavigateMobilePG.xml in the mentioned path and import into database using the above script.
6. To create translations for the personalized page or for a custom page, download the corresponding xlf file for the personalized page or the custom page. Then change the prompts in the destination language and import the page again.
Extract XLF file for a particular directory (For arabic language, for a different language, change accordingly).
<JDEV_DIR>\jdevbin\jdev\bin\xliffextract /xxt/oracle/apps/pon/registration/webui -includeSubpackages -mmd_dir D:\Jdev1150CU2\jdevbin\jdev\lib\ext\jrad\config\mmd -root D:\Temp\XLIF\registration -xliff_dir D:\Temp\XLIF\registration -source db -username apps -password <APPS_PASSWORD> -dbconnection "(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=<DB_HOSTNAME>)(PORT=<DB_PORT>))(CONNECT_DATA=(SID=<DB_SID>)))" -languages ar-AE
Extract XLF file for a particular file(For arabic language, for a different language, change accordingly).
<JDEV_DIR>\jdevbin\jdev\bin\xliffextract /oracle/apps/pon/outcome/creation/webui/customizations/site/0/ponCreatePOPG -root D:\temp -xliff_dir D:\temp -mmd_dir <JDEV_HOME>\jdevbin\jdev\lib\ext\jrad\config\mmd\ -source db -username apps -password <APPS_PASSWORD> -dbconnection " (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL= TCP)(HOST = <DB_HOSTNAME>)(PORT = <DB_PORT>)) ) (CONNECT_DATA = (SERVICE_NAME = <DB_SID>) ) )" -languages ar-AE
7. When you have the Substitutions upload the JPX using the following script from the UNIX prompt,
java oracle.jrad.tools.xml.importer.JPXImporter $CUST_TOP/TestProject.jpx -username $APPS_NAME -password $APPS_PASSWORD -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(Host=<DB_HOSTNAME>)(Port=<DB_PORT>)) (CONNECT_DATA=(SID=<DB_SID>)))"
8. To find the personalizations for a particular object or for the whole system or for a particular package.
Login with the user who has Functional Administrator responsibility, you search the Object you have substituted (Functional Administrator=>Personalization=>Import/Export).
Search with a particular path, Eg. /oracle/apps/icx will give all the personalization under the path.
If the the profile option “FND: Personalization Document Root Path” set properly, the personalization can be exported to the system directly.
AOL Related Scripts(All the below scripts needs to be run at UNIX prompt).
1. Download FND Messages.
For all the message names which starts with XXT_REGN,
FNDLOAD apps/<APPS_PASSWORD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct <MSG_LDT _NAME>.ldt FND_NEW_MESSAGES MESSAGE_NAME=XXT_REGN%
For a particular message XXT_REGN_LAUNCH_SUCCESS
FNDLOAD apps/<APPS_PASSWORD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct <MSG_LDT _NAME>.ldt FND_NEW_MESSAGES MESSAGE_NAME= XXT_REGN_LAUNCH_SUCCESS
2. Upload the FND Messages.
$FND_TOP/bin/FNDLOAD apps/<APPS_PASSWORD> 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct <MSG_LDT _NAME>.ldt
3. Download the FND Lookups.
To download all the lookups starts with XXT_REGN,
FNDLOAD apps/<APPS_PASSWORD> 0 Y DOWNLOAD aflvmlu.lct <LOOKUP_LDT _NAME>.ldt FND_LOOKUP_TYPE LOOKUP_TYPE=XXT_REGN%
For a particular Lookup XXT_REGN_STATUS
FNDLOAD apps/<APPS_PASSWORD> 0 Y DOWNLOAD aflvmlu.lct <LOOKUP_LDT _NAME>.ldt FND_LOOKUP_TYPE LOOKUP_TYPE=XXT_REGN_STATUS
4. Upload the FND Lookups.
$FND_TOP/bin/FNDLOAD apps/<APPS_PASSWORD> 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct $CUST_TOP/<LOOKUP_LDT_NAME>.ldt
5. Download the FND Responsibility
FNDLOAD apps/<APPS_PASSWORD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct <RESPONSIBILITY_LDT_NAME>.ldt FND_RESPONSIBILITY RESPONSIBILITY_NAME='Custom page Test Resp'
(Or)
FNDLOAD apps/<APPS_PASSWORD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct <RESPONSIBILITY_LDT_NAME>.ldt FND_RESPONSIBILITY APPLICATION_SHORT_NAME='XXPO' RESP_KEY='<RESP_KEY>'
6. Upload FND Responsibility
FNDLOAD apps/<APPS_PASSWORD> 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct <RESPONSIBILITY_LDT_NAME>.ldt
7. Download the FND Grants
FNDLOAD apps/<APPS_PASSWORD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <GRANT_LDT_NAME>.ldt GRANT GNT_MENU_NAME=<GRANTED_MENU>
8. Upload the FND Grants
$FND_TOP/bin/FNDLOAD apps/<APPS_PASSWORD> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct $CUST_TOP/<GRANT_LDT_NAME>.ldt
9. Download FND Menu
Download the menus which starts with XXT_PON_REGN,
FNDSLOAD apps/<APPS_PASSWORD> 0 Y LOCAL <MENU_LDT_NAME>.ldt DOWNLOAD XXT_PON_REGN%
Download a particular Menu,
FNDSLOAD apps/<APPS_PASSWORD> 0 Y LOCAL <MENU_LDT_NAME>.ldt DOWNLOAD XXT_PON_REGN_LAUNCH
10. Upload the Menu.
if $FND_TOP/bin/FNDSLOAD apps/<APPS_PASSWORD> 0 Y LOCAL $CUST_TOP/install/import/AR/<MENU_LDT_NAME>.ldt UPLOAD
11. Download FND Function:
FNDLOAD apps/<APPS_PASSWORD> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct <FUNCTION_LDT_NAME>.ldt FUNCTION FUNCTION_NAME=<YOUR FUNCTION NAME>
12. Upload FND Functions.
FNDLOAD apps/<APPS_PASSWORD> 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct <FUNCTION_LDT_NAME>.ldt
13. Download AK Attributes
java oracle.apps.ak.akload apps apps THIN "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(Host = <DB_HOSTNAME>)(Port = <DB_PORT>)) (CONNECT_DATA = (SID = <DB_SID>)))" DOWNLOAD <ATTRIBUTE_LDT_NAME>.ldt GET CUSTOM_REGION AMS AMS_ASSOCIATE_DELV
AMS - Application Short Name
AMS_ASSOCIATE_DELV - Region where the attribute attached
14. Upload AK Attributes
java oracle.apps.ak.akload apps apps THIN "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(Host = sdniodb15)(Port = 40001)) (CONNECT_DATA = (SID = OMO0)))" UPLOAD ATTRIBUTE_LDT_NAME>.ldt UPDATE GERMAN_GERMANY.WE8ISO8859P1
4 Important profile options used in OAFramework:
1. Personalize Self-Service Defn / FND_CUSTOM_OA_DEFINTION
This is intended for system administrators who wish to personalize regions at the localization, site, verticalization, org and responsibility levels. On enabling this profile option for the administrator, every OA Framework page will contain a global Personalize button. By clicking on this global button, the administrator can personalize the regions available on that page.
2. Disable Self-service Personal / FND_DISABLE_OA_CUSTOMIZATIONS
This is a system profile option specifically created for use by Oracle Support. You can set this profile option to "Yes" or "No" at the site or application level. If this system profile option is set to Yes, any personalizations made by the customer, regardless of the level at which the personalizations were made, will not be applied. All pages using OA Framework will now display the regions based on their original definitions.
Note: When this profile is set to "Yes", a warning message that all personalizations are disabled is displayed on every page to which a user navigates.
3. FND: Personalization Region Link Enabled / FND_PERSONALIZATION_REGION_LINK_ENABLED
Enables the "Personalize Region" links on a page if the Personalize Self-Service Defn / FND_CUSTOM_OA_DEFINTION profile is set to Yes.
4. Fnd Xliff Export Root Path / FND_XLIFF_EXPORT_ROOT_PATH
Use this profile option to set the root path used to generate the full path where the Xliff files are exported to when users extract their translated personalizations using the Extract Translation Files page in OA Personalization Framework. The permissions for the root path directory that you specify must be set to read, write, create for all users, using chmod 777 [dir_path].
5. Xliff Import Root Path / FND_XLIFF_IMPORT_ROOT_PATH
Use this profile option to set the root path used to derive the full path from where the Xliff files are uploaded when users use the Upload Translations page in OA Personalization Framework to upload translated personalizations.
6. FND: Personalization Document Root Path / FND_PERZ_DOC_ROOT_PATH
Use this profile option to define the root path where personalizations documents are exported to or imported from when users use the Database page or the File System page of the Functional Administrator responsibility's Document Manager, respectively.
Recommended this profile set to the $APPL_TOP staging area:
$APP_TOP/<CompanyIdentifier>/
<CustomProductShortName>/
<product-version>/mds/webui
of the current deployed environment, where personalization documents are to be imported from or
exported to. This profile option should be set at the Site level.
7. FND: Diagnostics / FND_DIAGNOSTICS
Setting this to “Yes” causes a Diagnostics global button to render on every page. Select this button to view the log messages for the page. Enabling this profile also automatically renders the "About this page" link at the bottom of every OA Framework page.
5 Find the version of the Jdeveloper for Apps 11i or 12
To determine which patch to use, you can check the framework version in your instance by using http://host:port/OA_HTML/OAInfo.jsp, then choose the matched JDeveloper patch.
5.1 Release 11i
OA Framework 5.10 patch | 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 6469392 9IJDEVELOPER WITH OA EXTENSION ARU FOR 11I10 RUP6 |
5.2 Release 12
ATG Release 12 Version | 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 |
Comments
i'm a new user of ur site
can u help me on that topic
i want record in GL
'''''' undefined accounting periods in the current accounting calendar '''''''''''
help me
thanks
Very good Article for scripts in OA Framework .
Thnaks,
Soma Sekhar.
RSS feed for comments to this post