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 <Substitutes> 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