OAF Important Scripts To Verify and Delete the OAF Extensions from Oracle Application

OAF Important Scripts To Verify and Delete the OAF Extensions from Oracle application

In this post, I will show you the way how we can verify that  OAF extensions is successfully migrated to Oracle Application or not and if we want to delete these extensions from application then how we can do that. This is quite common requirement in development to roll back the extesnsion from the application but before doing that you should be careful to remove these extensions reference from other object and OAF personalization other wise you pages can go in error.

OAF Import scripts to Migrate Extensions in Oracle application

java oracle.jrad.tools.xml.importer.XMLImporter $JAVA_TOP/oracle/apps/xxap/oie/lov/server/XXTESTVO.xml -rootdir $JAVA_TOP -username apps -password apps -dbconnection " (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SERVER NAME)(PORT=2344))(CONNECT_DATA=(SERVICE_NAME=SID_NAME)))"

Verify the Migrated OAF extensions in Oracle Application.

SET SERVEROUTPUT ON SIZE 10000
BEGIN
jdr_utils.listdocuments('/oracle/apps/xxap/',TRUE);
END;

Delete the Migrated OAF Extensions from Oracle Application

DECLARE

BEGIN

jdr_utils.deletedocument(p_document => '/oracle/apps/xxap/oie/lov/server/XXTESTVO');

END;

 

OAF Important Scripts To Verify and Delete the OAF Extensions from Oracle application