OAF_Page Deployment
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 |