Scripts of Oracle Apps Customization and Implementation

To deploy any custom code or Application, we need upload into server.
1) For oracle forms.
Compile the forms using the command:
f60gen module='XXXXXXXX.fmb' userid=apps/apps
2) For custom PLL.
f60gen module=calendar.pll userid=apps/apps module_type=library
3) For Form personalization

1) Login into Middle Tier.
2) $AUG_TOP/forms_personal (This is the directory where the extracted Form Personalizations reside).
3) Enter form_pers_download where is the short name for the form in all caps. (From the example above, you would enter form_pers_download OEXOEORD.)

4) AOL Related Scripts

1. Download FND Messages.
For all the message names which starts with XXT_REGN,
FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct .ldt FND_NEW_MESSAGES MESSAGE_NAME=XXT_REGN%
For a particular message XXT_REGN_LAUNCH_SUCCESS
FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afmdmsg.lct .ldt FND_NEW_MESSAGES MESSAGE_NAME= XXT_REGN_LAUNCH_SUCCESS

2. Upload the FND Messages.
$FND_TOP/bin/FNDLOAD apps/ 0 Y UPLOAD $FND_TOP/patch/115/import/afmdmsg.lct .ldt
3. Download the FND Lookups.
To download all the lookups starts with XXT_REGN,
FNDLOAD apps/ 0 Y DOWNLOAD aflvmlu.lct .ldt FND_LOOKUP_TYPE LOOKUP_TYPE=XXT_REGN%
For a particular Lookup XXT_REGN_STATUS
FNDLOAD apps/ 0 Y DOWNLOAD aflvmlu.lct .ldt FND_LOOKUP_TYPE LOOKUP_TYPE=XXT_REGN_STATUS
4. Upload the FND Lookups.
$FND_TOP/bin/FNDLOAD apps/ 0 Y UPLOAD $FND_TOP/patch/115/import/aflvmlu.lct $CUST_TOP/.ldt
5. Download the FND Responsibility
FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct .ldt FND_RESPONSIBILITY RESPONSIBILITY_NAME='Custom page Test Resp'
(Or)
FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct .ldt FND_RESPONSIBILITY APPLICATION_SHORT_NAME='XXPO' RESP_KEY=''
6. Upload FND Responsibility
FNDLOAD apps/ 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct .ldt

7. Download the FND Grants
FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct .ldt GRANT GNT_MENU_NAME=
8. Upload the FND Grants
$FND_TOP/bin/FNDLOAD apps/ 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct $CUST_TOP/.ldt
9. Download FND Menu
Download the menus which starts with XXT_PON_REGN,
FNDSLOAD apps/ 0 Y LOCAL .ldt DOWNLOAD XXT_PON_REGN%
Download a particular Menu,
FNDSLOAD apps/ 0 Y LOCAL .ldt DOWNLOAD XXT_PON_REGN_LAUNCH
10. Upload the Menu.
if $FND_TOP/bin/FNDSLOAD apps/ 0 Y LOCAL $CUST_TOP/install/import/AR/.ldt UPLOAD

11. Download FND Function:
FNDLOAD apps/ 0 Y DOWNLOAD $FND_TOP/patch/115/import/afsload.lct .ldt FUNCTION FUNCTION_NAME=
12. Upload FND Functions.
FNDLOAD apps/ 0 Y UPLOAD $FND_TOP/patch/115/import/afsload.lct .ldt

13. Download AK Attributes
java oracle.apps.ak.akload apps apps THIN "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(Host = )(Port = )) (CONNECT_DATA = (SID = )))" DOWNLOAD .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

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
\jdevbin\jdev\bin\import \jdevbin\jdev\myclasses\xxt\oracle\apps\pon\registration\webui\XXTSupplierRegistrationPG.xml -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=))(CONNECT_DATA=(SID=)))" -rootDir \jdevbin\jdev\myclasses\ -rootPackage /

2. Upload multiple PG.xml files
/jdevbin/jdev/bin/import /jdevbin/jdev/myclasses /oracle/apps/xxpo/pdt/ordering/webui -rootDir /jdevbin/jdev/myclasses / -username apps -password -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=))(CONNECT_DATA=(SID=)))" -includeSubpackages -jdk13 -mmddir /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).
\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 -dbconnection "(DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=))(CONNECT_DATA=(SID=)))" -languages ar-AE
Extract XLF file for a particular file(For arabic language, for a different language, change accordingly).
\jdevbin\jdev\bin\xliffextract /oracle/apps/pon/outcome/creation/webui/customizations/site/0/ponCreatePOPG -root D:\temp -xliff_dir D:\temp -mmd_dir \jdevbin\jdev\lib\ext\jrad\config\mmd\ -source db -username apps -password -dbconnection " (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL= TCP)(HOST = )(PORT = )) ) (CONNECT_DATA = (SERVICE_NAME = ) ) )" -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=)(Port=)) (CONNECT_DATA=(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.