Apps To Fusion

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.

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.

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

 

 

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.

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