OAF_Page Deployment

by jeevanthi koya

1.      Use the below script to load PG.xml / RN.xml to MDS

C:\jdev\jdevbin\oaext\bin

import C:\sridhar\jdev\jdevhome\jdev\myprojects\myprojects\moto\oracle\apps\fnd\webui\ComponentListPG.xml -username apps -password apps -dbconnection “(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=glo.dev.com)(PORT=1521))(CONNECT_DATA=(SID=VIS)))” -rootDir C:\sridhar\jdev\jdevhome\jdev\myprojects

2.      List of DB Components(Tables,PLSQL-API’s) In-Respect to OAF

Table Name Description
JDR_PATHS Stores document paths, packages and there parent child relationship.
Primary Key: PATH_DOCID
JDR_COMPONENTS Stores components on documents and OA Framework pages.
Primary Key: COMP_DOCID, COMP_SEQ
JDR_ATTRIBUTES Stores attribute/properties of components on documents and OA Framework pages.
Primary Key: ATT_COMP_DOCID, ATT_COMP_SEQ, ATT_SEQ
JDR_ATTRIBUTES_TRANS Stores translated attribute values of document components or OA framework pages.
Primary Key: ATL_COMP_DOCID, ATL_LANG, ATL_COMP_REF, ATL_NAME

Comments |0|

Legend *) Required fields are marked
**) You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
Category: OAF