Checking the presence of ( . xml) file in MDS of Oracle (OA Framework)

Whenever there is a new page added or any customization done to Oracle apps applications we use XML importer to import the new custom XML page to MDS of database.The XML importer Batch script to import XML files into MDS is ( here )

Assuming that you have imported the XML file ,and when you run the application the most common error would be (see the screen Shot)

                                                        ( click the image to expand )

The first thing to check here is whether you have successfully imported the XML page or not.To check this :

Run : On Sql * Plus or SqlDeveloper ,

DECLARE
BEGIN
   jdr_utils.printdocument ( p_document => ' /oracle/apps/per/selfservice/appraisals/somePG' )
END ;

The parameter to p_document is your XML path you wish to check . Few of the jdr_utils package will be discussed in coming posts.