OAF MDS Table/PLSQL Utils
An OAF page consists of 2 Deployable Regions – SharedRegion and Page and they are with the naming convention RN.xml and PG.xml. The technology is designed such a way that , the definition of RN/PG gets stored in the below MDS (Meta Data Service) – DB tables, whey get deployed on the server. If they are stored in DB, how will they shown in the browser as a graphical HTML components, If you observe carefully any OAF page which gets opened in the browser will have : OA.jsp which considers OAF page path as input and it is the rendering engine, which converts xml content in MDS into HTML at run Time. This is the rendering concept of OAF page.
List Customizations
| 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 |
begin
jdr_utils.listCustomizations('/oracle/apps/po/icx/ReqDetailsPG');
end;Print Document
BEGIN
jdr_utils.printDocument('oracle/apps/per/webui/EmployeeDetailsPG');
END ; Delete Document
BEGIN
jdr_utils.deletedocument(p_document => '/oracle/apps/per/server/customizations/employeeDetailsAM');
ENDComments |0|
Category: OAF