Oracle OAF: Deployment

Here are the parts of deployment in OAF:

a. Deploy Customizations (supposing that we have created a folder /oaf/custdocs in the source system and /oaf/custdocs_STG in the target system):

1. Source System: Setup Profile Name: FND: Personalization Document Root Path to /oaf/custdocs
2. Target System: Setup Profile Name: FND: Personalization Document Root Path to /oaf/custdocs_STG
3. Source System: Login into Functional Administrator,Personalization,Import/Export and export personalizations
4. Target System: Login into Functional Administrator,Personalization,Import/Export and import personalizations

b. Deploy Translations (supposing that we have created a folder /oaf/custtrans in the source system and /oaf/custtrans_STG in the target system):

1. Source System: Setup Profile Name: Fnd Xliff Export Root Path to /oaf/custtrans
2. Target System: Setup Profile Name: Xliff Import Root Path to /oaf/custtrans_STG
3. Source System: Login into Functional Administrator,Personalization, Manage Personalizations, Export to file System
4. Target System: Login into Functional Administrator,Personalization, Manage Personalizations, Import from file System

c. Deploy a new page (supposing that we made a page xxCustomPG.xml and we work in the PON module – sourcing):

From Unix:
java oracle.jrad.tools.xml.importer.XMLImporter
$PON_TOP/mds/response/creation/webui/xxCustomPG.xml -rootdir $PON_TOP/mds
-rootPackage /oracle/apps/pon -username apps -password apps
-dbconnection "(description=(address_list=(address=(community=tcp.world)(protocol=tcp)
(host=oracle11g_wl)(port=1521))) (connect_data=(sid=ora11g)))"

d. Import a substitution of VO (supposing we work on the PON module – sourcing):

From Command-Prompt:
C:\JDev\p9879989_R12_GENERIC\jdevbin\oaext\bin\jpximport.bat
C:\JDev\p9879989_R12_GENERIC\jdevhome\jdev\myprojects\pon.jpx -username apps -password apps
-dbconnection "(description=(address_list=(address=(community=tcp.world)(protocol=tcp)
(host=oracle11g_wl)(port=1521)))(connect_data=(sid=ora11g)))"

Theory and trouble-shooting:

If we take pon.jpr (project) as an example, it includes pon.jpx, in the same folder,

which is an .xml file actually with the tag inside.
Substitutions declared in .jpr are written in .jpx. When we execute the above command, all substitutions are reimported.

To delete a substitution, it is not enough to delete it from .jpx. The following must run in order to delete it:

--First put the full path of the ViewObject, to see if there are any substitutions:
begin
jdr_utils.listcustomizations('/oracle/apps/pon/tools/attributes/server/AttributeListsVO');
end;
--then from the dbms output we receive: /oracle/apps/pon/tools/attributes/server/AttributeListsVO
--so this we put in the following command:
begin
JDR_UTILS.deletedocument('/oracle/apps/pon/tools/attributes/server/customizations/site/0/AttributeListsVO');
commit;
end;

Leave a Reply