Frequently Asked Questions (FAQs) in OAF

Page customizations in OAF

·     How to print the page definition/find file version of page or region?

set serveroutput on;

exec jdr_utils.listCustomizations('/oracle/apps/per/wpm/objectives/webui/ObjectivesSubTabsRN’);

·    How to list customizations in a page?

set serveroutput on;

exec jdr_utils.listCustomizations('/oracle/apps/per/wpm/objectives/webui/ObjectivesSubTabsRN');

·    How to migrate customizations across instances. – Using JDR_UTILS package

Printing customizations on the page or region using below command.

exec jdr_utils.listCustomizations('<document name with full path>');

eg: exec jdr_utils.printDocument('/oracle/apps/per/selfService/review/webui/ReviewRN');

This returns a list of file names that contain the customizations.

Now print any of the document from above results using the command

exec jdr_utils.printDocument('<document name with full path>');

Delete customizations:

Instead of removing the customizations from application, we can directly delete the OAF customization using the following

exec jdr_utils.deleteDocument('<customization document path along with file name>');

Once this is done bounce oacore usnig the following commands to see the results.

adoacorectl.sh stop

adoacorectl.sh start

·    How to upload a PG or an RN to an instance?

   java oracle.jrad.tools.xml.importer.XMLImporter /abc/xyz/pqr/oracle/apps/.../webui/AbcXyzPG.xml -rootdir /abc/xyz/pqr/ -username apps -password $APPSPWD -dbconnection "(description=(address_list=(address=(community=tcp.world)(protocol=tcp)(host=$HOST)(port=$PORT)))(connect_data=(sid=$SID)))"
   
   In the above $APPSPWD $HOST, $PORT and $SID need to be supplied.

File versions in OAF application

·    How to find the java file version on the instance UI?

Login to the instance and Navigate to the page where the java file is used.

On this page replace the url with a new url appended with jsp/fnd/fndversion.jsp

For example:

If the url is http://abccorp.com:8000/OA_HTML/RF.jsp?function_id=30255...

Replace this url with http://abccorp.com:8000/OA_HTML/jsp/fnd/fndversion.jsp

This lists all the java files with the file versions.

·    How to find the java file version from server?Login to the unix box and execute the following command.

Ident <Complete file path>

Example: ident $JAVA_TOP/oracle/apps/per/selfservice/review/webui/ReviewCO.class

·     How to find the file version of a package file?

select *  

  from all_source where name='HR_PERF_MGMT_PLAN_INTERNAL' 

   and type='PACKAGE BODY' and text like '%$Header: pepmpbsi.pkb%';

·    How to redirect Trace Output to DBMS_OUT?

hr_utility.trace_on;

hr_utility.set_trace_options('TRACE_DEST:DBMS_OUTPUT');

Custom objects in DB

·    How to find the custom user Hooks?

SELECT module_name

     , module_package

     , c.*

  FROM hr_api_modules m

     , hr_api_hooks h

     , hr_api_hook_calls c

 WHERE (   m.module_name IN ('PER_APPRAISALS','PER_OBJECTIVES','PER_ASSESSMENTS')

        OR m.module_package IN ('HR_APPRAISALS_API','HR_OBJECTIVES_API','HR_ASSESSMENTS_API')

       )

   AND h.api_module_id = m.api_module_id

   AND h.api_hook_id = c.api_hook_id;

·    How to find if the customer is having any triggers on a Table?

SELECT * 

  FROM all_triggers

 WHERE table_name = 'PER_APPRAISALS';

XDK Version in Database

·    How to Identify the Version of XDK for Java Installed Inside the Database ?

 Create following function after logging in through SQL*Plus as any user:

CREATE OR REPLACE FUNCTION XMLVersion 

  RETURN VARCHAR2 

IS 

  LANGUAGE JAVA 

      NAME 'oracle.xml.parser.v2.XMLParser.getReleaseVersion() returns java.lang.String';

  - Run the query to display the version of XDK for Java

  SELECT xmlversion 

    FROM dual;

·    How to add debug/diagnostic statements?

·          Adding diagnostics in Application Module code: 

  OADBTransaction txn = getOADBTransaction();

  String str = "--------START ORACEL TRACE---------";

  if(tx.isLoggingEnabled(2))

    getOADBTransaction().writeDiagnostics(this, str, 2);

·          Adding diagnostics in Controller code: 

  String str = "--------START ORACLE TRACE--------";

  if(pageContext.isLoggingEnabled(2))

            pageContext.writeDiagnostics(this, str, 2);

DBA Concepts for OAF Application

·    How to add a zip to class path of a 11i Instance?

1.  Login to code tree with user who is the owner of the code tree. 

2.  Let instance name be INST 

Move to the directory INSTora/iAS/Apache/Jserv/etc/ 

3.  There will be file jserv.properties in the directory.  

4.  Find classpath entries in the file with lines as follows 

wrapper.classpath=....... 

5.  Prepend a new line with the zip file location.

For example wrapper.classpath=/tmp/test.zip;... 

·    How to add a zip to class path of a R12 Instance?

Add <library path="Your class path" /> as the first entry in the file present at location $INST_TOP/ora/10.1.3/j2ee/oacore/application-deployments/oacore/orion-application.xml

    Bounce apache for the changes to reflect.

·    How to bounce services?

 Let instance name be INST 

Go to directory INSTcomn/admin/scripts/INST/

     OR

Go to the directory $ADMIN_SCRIPTS_HOME

Apache 

   Stop  - adapcctl.sh stop

   Start – adapcctl.sh start

OPMN

   Stop  - adopmnctl.sh stop

   Start – adopmnctl.sh start

Clear OACore

   Stop  - adoacorectl.sh stop

   Start – adoacorectl.sh start

Listener

   Stop  - adalnctl.sh stop

   Start – adalnctl.sh start

Forms

   Stop  - adformsctl.sh stop

   Start – adformsctl.sh start

All Services

   Stop  - adstpall.sh

   Start – adstrtal.sh

   Running these scripts require apps login to the DB.

Note: In case if the variable ADMIN_SCRITPS_HOME is not set then check for something like $INST_TOP/admin/scripts/