R12 OA Framework Extra Info

LOG message
Whenever you place any System.out.println() in your controller or any where in OA framework. You can get this output in below mentioned file.

The log message should get written in,
$INST_TOP/logs/ora/10.1.3/opmn/oacore_default_group_1/oacorestd.out


Enabling Low Level login

you can set the below profiles using System Admin responsibility.

FND: Debug Log Enabled

FND: Debug Log Level

FND: Debug Log Module

FND: Debug Log Filename for Middle-Tier

Restart Apache
$ADMIN_SCRIPTS_HOME/adapcctl.sh stopall

DBC file location in R12:
$INST_TOP/appl/fnd/12.0.0/secure

JDR_UTILS

Use this API to list of all OA Framework the documents in a path/module. This script is very handy, as it provides a list of all the desired documents/extensions/personalizations in one go.

DECLARE
BEGIN
jdr_utils.listdocuments('/oracle/apps/per', TRUE);
END;

The script above will produce a list of all the MDS Documents in HRMS plus all the BC4J extensions done to HRMS module will be listed here too. Surely you can run this for whatever module/application you desire.

---------------------------------------------

List of all the Personalizations/Extensions/Contents for a specific object. For example, as below, I wish to know the various levels at which a specific object has been personalized or extended.

DECLARE
BEGIN
jdr_utils.listcustomizations
(p_document => '/oracle/apps/per/irc/candidateSelfService/webui/RegCreateAccountPG');
END;

Delete Document / Delete A Personalization/ Delete Extension or Substitution

The title says it all. Once you have found the exact name of the document with its full path [using jdr_utils.listdocuments], you can then delete the same by using command below. For example to delete the Application Module substitution, use command

DECLARE
BEGIN
jdr_utils.deletedocument(p_document => '/oracle/apps/per/irc/candidateSelfService/server/customizations/site/0/VisitorAM');
END;

Import Region or Page into database

Go to ..\jdevbin\oaext\bin directory and run import

Example:

import
C:\Jdev1\jdevhome\jdev\myprojects\ncr\fo\oracle\apps\csf\portal\task\webui\CsfExtendedInstallRN.xml -rootdir C:\Jdev1\jdevhome\jdev\myprojects -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ibm5001.daytonoh.ncr.com)(PORT=1525))(CONNECT_DATA=(SID=DEV)))"

import Substitution into Database

Example:

jpximport C:\WS_FTP\Debrief.jpx -userId 1 -username apps -password apps -dbconnection "(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ibm5001.daytonoh.ncr.com)(PORT=1525))(CONNECT_DATA=(SID=DEV)))"