Friday, January 21, 2011

OAF:R12:JRAD Missing TroubleShooting

Check JRAD File Missing In MDS Repository for R12 OAF framework.

1)-From SQLPPLUS exec jdr_utils.listdocuments('/oracle/apps/ap/oie/webui');

2)-See what all files are missing in this output and what extra files are there in $AP_TOP/mds/oie/webui.


3)-You can copy those extra files from $AP_TOP/mds/oie/webui to $JAVA_TOP and use the XMLImporter command.

adjava -mx128m -nojit oracle.jrad.tools.xml.importer.XMLImporter
$JAVA_TOP/oracle/apps/ap/oie/webui/MonitorNtfResponseDetailPG.xml
-username apps -password apps
-dbconnection "(description=(address_list=(ADDRESS=(PROTOCOL=TCP)(HOST=myHost)(PORT=1521)))(CONNECT_DATA=(SID=mysid)))"
-rootdir $JAVA_TOP


replace the $JAVA_TOP with physical path of JAVA_TOP directory and change the
database info in the command.

4)-Bounce Apache and thats all..


For a single file you can use

exec jdr_utils.printDocument("oracle/apps/ap/oie/webui/MonitorNtfResponseDetailPG.xml");

This situation arises when driver is not applied properly..

If huge no of JRAD files are missing, then you can think of applying the driver once more by using the following command(in today's new unified driver)

adpatch options=nocopyportion,nocheckfile,nogenerateportion

or

If the file difference between the output of the SQL proc and the $AP_TOP/mds/oie/webui is merely 1 or 2 then you can manually import through XMLImporter.

No comments: