Oracle Apps File Version

This Post helps you to find out versions of different components in 11i/R12:
How to find Apps Version (11i/R12/12i)?
Log in as Application user, source the environment and run below query:
sqlplus apps/<password>
SQL> select release_name from apps.fnd_product_groups;
RELEASE_NAME
————————————————–
12.1.3
How to find Web Server/Apache or Application Server in Apps 11i/R12?
Log in as Application user, source the environment and run below query:
$IAS_ORACLE_HOME/Apache/Apache/bin/httpd -version
Output for 11i should be like:
Server version: Oracle HTTP Server Powered by Apache/1.3.19 (Unix)
Server built: Jan 26 2005 11:06:44 (iAS 1.0.2.2.2 rollup 5)
Output for R12 should be like:
Server version: Oracle-Application-Server-10g/10.1.3.5.0 Oracle-HTTP-Server
Server built: Jul 21 2009 11:12:22
How to find Forms & Report version (aka developer 6i) in 11i ?
Log in as Application user, source the environment and run below query:
sqlplus apps/<password>
$ORACLE_HOME/bin/f60run | grep Version | grep Forms
Output should be like:
Forms 6.0 (Forms Runtime) Version 6.0.8.25.2 (Production)
Check fourth character in version 25 which means Forms 6i patchset 16 (25-9)
How to find Forms & Report version in R12/12i?
Log in as Application user, source the environment and run below query:
$ORACLE_HOME/bin/rwrun | grep Release
Output should be like:
Report Builder: Release 10.1.2.2.0
You can safely ignore warnings
How to find Database Version in 11i/R12/12i?
Log in as Application user, source the environment and run below query:
SQL> select * from v$version;
Output should be like:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 – Prod
PL/SQL Release 10.2.0.3.0 – Production
CORE 10.2.0.3.0 Production
TNS for Linux: Version 10.2.0.3.0 – Production
NLSRTL Version 10.2.0.3.0 – Production
How to find Oracle Jinitiator version in 11i/R12/12i?
Log in as Application user, set environment file under $ APPL_TOP and run below query from current directory:
grep jinit $CONTEXT_FILE
Output for 11i should be like:
<jinit_ver_comma oa_var=”s_jinit_ver_comma”>1,3,1,21</jinit_ver_comma>
Output for R12 should be like:
<jinit_ver_comma oa_var=”s_jinit_ver_comma”>1.6.0_07</jinit_ver_comma>
How to find Oracle Java Plug-in version in 11i/R12/12i?
Log in as Application user, source the environment file under $ APPL_TOP and run below query from current directory:
grep plugin $CONTEXT_FILE
Output for 11i should be like:
<!– JDK plugins –>
<sun_plugin_ver oa_var=”s_sun_plugin_ver”>1.4.2_04</sun_plugin_ver>
<sun_plugin_type oa_var=”s_sun_plugin_type”>jinit</sun_plugin_type>
Output for R12 should be like:
<!– JDK plugins –>
<sun_plugin_ver oa_var=”s_sun_plugin_ver”>1.6.0_07</sun_plugin_ver>
<sun_plugin_type oa_var=”s_sun_plugin_type”>jdk</sun_plugin_type>
How to find File Version on file system?
Goto the location of file.
adident Header <filename>
or
strings <file_name> | grep Header
Here adident is AD Utility (Oracle Apps) and strings is Unix utility.
Example:
cd $AU_TOP/forms/US
adident Header GMDFMHSM.fmb
GMDFMHSM.fmb:
$Header GMDFMHSM.fmb 115.23 2003/05/12 11:59 jbaird ship
strings GMDFMHSM.fmb | grep Header
FDRCSID(‘$Header: GMDFMHSM.fmb 115.23 2003/05/12 11:59 jbaird ship
How to find Version of pld file?
*.pld are source code of *.pll which are inturn source of *.plx. *.pll is in $AU_TOP/resource and to find its version check.
adident Header $AU_TOP/resource/<filename>.pll
or
strings $AU_TOP/resource/<filename>.pll | grep -i header
Output should be like:
$Header IGSAU012.pld 115.1.115100.1 2004/04/01 05:40:18 appldev ship
How to find OA Framework Version ?
http:// hostname.domainName:port/OA_HTML/OAInfo.jsp (Only for 11i)
Log in as Application user, set environment variable and run below query
adident Header $FND_TOP/html/OA.jsp
adident Header $OA_HTML/OA.jsp
Output should be like:
$Header OA.jsp 115.60 2006/03/31 00:47:28 atgops1 noship $
120.21 means OA Framework Version
115.60 means OA Framework Version
115.56 means OA Framework Version
115.36 means OA Framework Version 5.7
115.27 means OA Framework Version 5.6E
115.26 means OA Framework Version 5.5.2E
How to find Discoverer Version for 11i (3i or 4i)?
Log in as Application user, set environment variable and run below query:
$ORACLE_HOME/bin/disc4ws | grep -i Version
How to find Workflow Version with Apps?
Connect to Database as apps user:
SQL> select text ,name from wf_resources
where name like ‘%WF_VERSION%’;
Output should be like:
TEXT           NAME
———————-
2.6.0  WF_VERSION
How to find portal version with Apps
Connect to database as sysdba
sqlplus “/as sysdba”
SQL> select version from portal.WWC_VERSION$;
Output should be like:
Version
—————

Output Post Processor (OPP) in Oracle Applications R12 and 11i

What is Output Post Processor?

Concurrent Processing now uses the Output Post Processor (OPP) to enforce post-processing actions for concurrent requests.Post-processing actions are actions taken on

concurrent request output. An example of a post-processing action is that used in Concurrent Processing support of XML Publisher.

If a request is submitted with an XML Publisher template specified as a layout for the concurrent request output, then after the concurrent manager finishes running

the concurrent program, it will contact the OPP to apply the XML Publisher template and create the final output.

OPP runs as a service that can be managed through Oracle Applications Manager (OAM) from the System Activity page (Navigation: Applications Dashboard > Applications

Service (from the dropdown list) > Go).

How to Increase the number of Output Post Processors?
1.Log on to Applications with “System Administrator” responsibility.
2.Navigate to Concurrent -> Manager -> Define.
3.Query for the “Output Post Processor” service.
4.Click on “Work Shifts” and increase the number of processes

How to get OPP manager log file location?

$APPLCSF/log/<SID>/FNDOPP####.txt       OR
1,System Administrator > Concurrent > Manager > Administer
2,Search for ‘Output Post Processor’
3,Click the ‘Processes’ button .
4,Click the Manager Log button. This will open the ‘OPP’
Upload the OPP log file.

In some cases, Output Post Processor is not start up and it shows Actual and Target are showing different values when we query for Output Post Processor.
The log files shows that no error message.In this case apply the following possible solution for starting the OPP.


1. Shutdown the internal manager by using adcmctl.sh stop apps/apps
2. Make sure there is no FNDLIBR processe running:
$ ps -ef| grep FNDLIBR OR ps -ef|grep applprod|grep FNDLIBR
3. If there is any FNDLIBR processe please kill it $ kill -9 pid
4. Run cmclean.sql script as document from Note 134007.1
5. Restart the internal manager by using adcmctl.sh start apps/apps

or How to kill and start Output Post Processor (OPP) Background:
This article explains how to kill OPP and restart the same

Solution:
1,System Administator > Concurrent > Manager > Administer
2,Query "Output Post Processor" -> Processes button
Get the sytem id of "Output Post Processor"
3,ps -ef|grep [system id]
4,kill -9 [system id] in Unix
5,System Administator > Concurrent > Manager > Administer
6,Query "Output Post Processor" -> Restart button

Fixing Output Post-processor actions failed issues in EBS R12

Environment: Oracle EBS 12.1.3, Oracle Database 11gR2, RedHat Linux5
Symptoms:

Users unable to open the out files.

Concurrent requests failed with “Post-processing of request failed error message”

One or more post-processing actions failed. Consult the OPP service log for details.

No further attempts will be made to post-process this request.

Cause:

The concurrent manager process was able to successfully invoke the Output Post-Processor (OPP) but encountered a timeout as the OPP takes longer than the value

assigned to complete the job.

 Solution:

1,Increase the value of profile Concurrent: OPP Response Timeout . Bounce Apache and retest.
2,If the issue still exists, perform the following steps.
3,Increase the number of Output Post Processors as follows:
4,Increase the number of processes for Output Post Processor.
5,Additionally, ensure there is a setting of  oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5 under Parameters.


For more details Please  check metalink I.E oracle.support

Concurrent Requests Fail Due to Output Post Processing (OPP) Timeout [ID 352518.1]
Ouput Post Processing Fails Due To java.lang.ThreadDeath [ID 427233.1]
Why Does OPP Intermittently Completes With Warnings and Error 'java.lang.OutOfMemoryError'? [ID 978495.1]


To know more this post is very nice http://knoworacleappsdba.blogspot.in/2012/07/all-about-output-post-processor-opp-in.html


How to start the Output Post Processing (OPP) in 11i
At least one OPP process active in the system. The concurrent processing uses the Output Post Processor (OPP) to enforce post-processing actions for concurrent requests. For example, post-processing action is that used in publishing concurrent requests with XML Publisher.

Actually when you have submit a request with XML Publisher template specified as a layout for the concurrent request output. Once finishes the concurrent manager concurrent program, it will contact the OPP to apply the XML Publisher template and create the final output

To activate the OPP follow these setps

The Profile Option "Concurrent: GSM Enabled" must be set to Y

Then:
1. Login to Apps with sysadmin responsibility
2. Navigate to: Concurrent -> Managers -> Define
3. Query for
Manager = 'Output Post Processor%'
or Short Name = FNDCPOPP
4. Check the checkbox "Enable" .
5. Click on 'Work Shifts button
6. see Work Shift of the OPP and
Set Processes = 1
and Parameters = oracle.apps.fnd.cp.opp.OPPServiceThread:2:0:max_threads=5
and Sleep Second = 30
7. Save

How to restart Oracle Apps 11i OPP via non unix command

It can be done using adcmctl.sh script only and there is no specific script for OPP. You can restart it from the application via (System Administrator responsibility > Concurrent > Manager > Administer), select "Output Post Processor" and click on the "Restart" button.


OPP Issue while generating the XML Output in apps 11i


Problem Description:
1, Few XML type concurrent programs taking long time and completed with warning OPP log file registered below error
      Caused by: java.lang.ThreadDeath
2, CPU utilization taking 100% constantly while running the concurrent programs.


Cause
The java.lang.ThreadDeath error indicates that the Output Post Processor has reached its processing timeout.

Solution
The following configuration changes are recommended to optimize the environment for these type of reports:
1. Increase the value of the Concurrent: OPP Timeout profile option to 10800 seconds.

2. Enable the scalability feature of XML Publisher:

1. Login as SYSADMIN
2. Responsibility: XML Publisher Administrator
3. Function: Administration
4. Set the following properties:
5. Temporary Directory
6. Use XML Publisher's XSLT processor: True
7. Enable scalable feature of XSLT processor: True   -- By default it’s false
8. Enable XSLT runtime optimization: True

> After changing the value also the problem still exist. As per the SR suggestion, we increased the java heap size from 1024M to 2048M.

a. Bring down the concurrent managers.

b. Use the Update statement below, for example:
update FND_CP_SERVICES
set DEVELOPER_PARAMETERS =
'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-mx2048m'
where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

c. Bring concurrent managers up again

Please check below note's from oracle support

427233.1  :Output Post Processing Fails Due To java.lang.ThreadDeath
1268217.1: Output Post Processor (OPP) Log Contains Error “java.lang.OutOfMemoryError: Java heap space"
1266368.1: Output Post Processor (OPP) Log Contains Error   "java.lang.OutOfMemoryError"
978495.1: Why Does OPP Intermittently Completes With Warnings and Error 'java.lang.OutOfMemoryError'?
352518.1 :Concurrent Requests Fail Due to Output Post Processing (OPP) Timeout
364547.1 :Troubleshooting Oracle XML Publisher For The Oracle E-Business Suite

Oracle Database Error Solutions

ORA-01940: cannot drop a user that is currently connected

SQL>drop user MY_USER cascade;
drop user username cascade
*
ERROR at line 1:
ORA-01940: cannot drop a user that is currently connected
SQL>select s.sid, s.serial#, s.status, p.spid from v$session s, v$process p where s.username = ‘MY_USER’ and p.addr (+) = s.paddr;
SID           SERIAL#       STATUS           SPID
———   ———-    ——–       ————
579               27        INACTIVE        17849
279                9        INACTIVE        89543
SQL> alter system kill session ’579,29′;
System alterred.
SQL> alter system kill session ’279,9′;
System alterred.
Now try to drop USER:
SQL>drop user MY_USER cascade;
User dropped.

Delete expired archivelogs using RMAN

Below commands will helpful for deleting expired archivelog files through RMAN :
RMAN>list expired archivelog all;
RMAN>crosscheck archivelog all;
RMAN>delete noprompt expired archivelog all;
Now check the output with below command it should not return any list
RMAN> list expired archivelog all;
using target database control file instead of recovery catalog
specification does not match any archived log in the repository
RMAN>

ORA-12547 TNS: Lost Contact

Getting the following error when trying to connect using Sql*Plus
ERROR:
$sqlplus / as sysdba
SQL*Plus: Release 11.1.0.7.0 – Production on Wed Mar 30 11:59:06 2011
Copyright (c) 1982, 2008, Oracle. All rights reserved.
ERROR:
ORA-12547: TNS:lost contact
CAUSE:
1) to kernel parameters settings
2) Incorrect permissions on the ORACLE executable
3) Insufficient ulimit setting for stack
4) $ORACLE_HOME/rdbms/lib/config.o is 0 bytes
5) Oracle binaries have not been linked correctly
SOLUTION:
1) Please check the notes below that provide the required settings for kernel parameters
Note 169706.1 Oracle Database on AIX,HP-UX,Linux,MacOSX,Solaris,Tru64
2) Please check permissions by running:
$ cd $ORACLE_HOME/bin
$ ls -l oracle
The output should show the correct permission which is:
-rwsr-s–x 1 oracle dba
If not, then please execute the following to correct the permissions:
$ cd $ORACLE_HOME/bin
$ chmod 6751 oracle
$ ls -l oracle
3) Check the current ulimit setting for stack:
ulimit -a
Check the install guide for your specific platform and version of Oracle and set the stack appropriately.
4) Check to ensure the following two files are not 0 bytes:
$ORACLE_HOME/bin/oracle
$ORACLE_HOME/rdbms/lib/config.o
If yes, rename the following file:
$ cd $ORACLE_HOME/rdbms/lib
$ mv config.o config.o.bad
Then, relink the oracle binary:
$ relink oracle

How to relink oracle binaries?

Sometimes We need to require to relink oracle binaries because of some number of our cases and also We need to do it because of solution given by oracle support.
The following method will relink the oracle executables.
For Unix system
set $ORACLE_HOME,
set $ORACLE_SID
If you are using E-Business Suite login your system as oramgr user than source env file
Go to $ORACLE_HOME/bin  path than run below commands for can relink binaries
$ORACLE_HOME/bin/relink all;
or you can use
$ORACLE_HOME/bin/relink oracle;
Referance:
How to Relink Oracle Database Software on UNIX [ID 131321.1]
If you are on 11gR2 level than I suggest also see below note:
Oracle 11gR2 Relink New Feature [ID 883299.1]
If you are using RAC than I suggest also see below note:
How to Check Whether Oracle Binary/Instance is RAC Enabled and Relink Oracle Binary in RAC [ID 284785.1]


5) If the above does not resolve I suggest that you shutdown the database and listener and then “relink all”
Please reffer the ORACLE SUPPORT DOCUMENT ID 422173.1

Disable Case Sensitive in Oracle Database 11g

Prior to 11g Passwords in Oracle are not case sensitive. Now from 11g Oracle passwords are Case sensitive. Parameter sec_case_sensitive_logon has been included in Oracle 11g.
sql> create user test identified by test;
sql> Grant create session to test;
SQL> show parameter logon
NAME                                       TYPE                              VALUE
—————————-     ———————-   ——————————
sec_case_sensitive_logon     boolean                           TRUE
SQL> conn test/TEST
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> conn test/test
Connected.
Disable Password case sensitive:
SQL> alter system set sec_case_sensitive_logon=false;
System altered.
SQL> conn test/TEST
Connected.

Find size of Table,Index and USER/SCHEMA in Oracle

How to find size of Table or Index or User/Schema in Oracle Database.
SIZE OF TABLE:
Select segment_name,sum(bytes)/1024/1024/1024 as “SIZE in GB” from user_segments where segment_name=’TABLE_NAME’ group by segment_name;
OR
select owner,segment_name,sum(bytes)/1024/1024/1024 as “SIZE in GB” from dba_segments where owner=’SCHEMA_NAME’ and segment_name=’TABLE_NAME’ group by owner,segment_name;
SIZE OF INDEX:
select segment_name,sum(bytes)/1024/1024/1024 as “SIZE in GB” from user_segments where segment_name=’INDEX_NAME’ group by segment_name;
OR
select owner,segment_name,sum(bytes)/1024/1024/1024 as “SIZE in GB” from dba_segments where owner=’SCHEMA_NAME’ and segment_name=’INDEX_NAME’ group by owner,segment_name
SIZE OF A USER/SCHEMA:
select owner,sum(bytes)/1024/1024/1024 as “SIZE in GB” from dba_segments where owner=’SCHEMA_NAME’ group by owner;

Oracle 11gR2 installation on windows machine

Oracle Database Patch Set 11.2.0.2 (Patch#10098816) for Win32 and Win64 is available in Oracle support for downloading.

After downloading patchset, Unzip the patch which will creates folder “database”
Run the setup executable with “Run as administrator”

Unchecked the box for not to receive any security updates from Oracle Support


Click on Skip software updates radio button

Click on instal database software only, As we are installing only software.

Drop temp tablespace taking long time

Created new temporary tablespace:
CREATE TEMPORARY TABLESPACE TEMP01 TEMPFILE ‘/u01/oracle/oradata/temp02.dbf’ SIZE 2g;
Make new temporary tablespace as default:
ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMP01;
Dropping old temporary tablespace, Which is taking long time to complete:
DROP TABLESPACE TEMP INCLDING CONTENTS AND DATAFILES;
The issue because of temp is being used by oracle sessions
SOLUTION 1:
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP
SQL>SELECT NAME,OPEN_MODE,LOG_MODE FROM V$DATABASE;
SQL>DROP TABLEPSACE TEMP INCLUDIING CONTENTS AND DATAFILES;
SOLUTION 2:
Run below query and see any sessions using temp, Find out the all the sessions that are not active and kill those sessions.
select  tu.username,s.sid,s.serial# from v$tempseg_usage tu, v$session s
where tu.session_addr=s.saddr;
alter system kill session ‘sid,serial’;

DROP DATABASE THROUGH RMAN

In Oracle Database 10gR1 Oracle introduced the RMAN command DROP DATABSE. This one simple statement has the ability to completely remove a database including all RMAN backups with the optional INCLUDING BACKUPS clause.
sqlplus “/ as sysdba”
SQL> shutdown immediate;
SQL> startup mount exclusive
SQL> alter system enable restricted session
SQL> exit
rman target /
RMAN> drop database including backups;

CHECK TABLESPACE SIZE, FREE AND USED SPACE

Below query is used for finding total tablespace size and free, used space.
select tablespace_name, ROUND(bytes_free,2) free,ROUND(bytes_total-bytes_free,2) used, ROUND(bytes_total,2) total,perused
from (select a.tablespace_name, a.bytes_free,b.bytes_total,
ROUND((100-(100*a.bytes_free/b.bytes_total)),2) perused from
(Select tablespace_name,sum(bytes)/1024/1024 bytes_free From dba_free_space Group by tablespace_name) a,
(Select tablespace_name,sum(bytes)/1024/1024 bytes_total From dba_data_files Group by tablespace_name) b
where a.tablespace_name=b.tablespace_name) where perused >= 0 ORDER BY tablespace_name;

ORA-12537: TNS:connection closed

Giving below error when trying to connect oracle user
ERROR:
Sqlplus scott/tiger@PROD
SQL*Plus: Release 10.2.0.1.0 – Production on Thu Oct 16 15:06:46 2008
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
ERROR:
ORA-12537: TNS:connection closed
SOLUTION:
Add the relevant LD_LIBRARY_PATH into the SID_DESC section in listener.ora file
(SID_DESC =
(ORACLE_HOME = /home/oracle/product/1020)
(ENVS=”LD_LIBRARY_PATH=/home/oracle/product/1020/lib:/usr/dt/lib:/usr/openwin/lib”)
(SID_NAME = PROD)
)

Oracle Apps Errors

Recommended Browsers for EBS R12 and any issues related to browsers, Please go through with below Oracle recommended document.
ORACLE DOCUMENT: Recommended Browsers for Oracle E-Business Suite Release 12 (Doc ID 389422.1)

EBS logon is failing with following error:
“Unable to Authenticate Session”
SOLUTION 1:
1. Clear the Browser cache.
2. Stop all Browser sessions.
3. Start a new Browser session and logon to the Instance.
Go to Tools >Internet Options > Click on delete browsing Cache (shown below)

SOLUTION 2:
Oracle E-Business Suite environment with IE8 and higher, When you are now logging out from your DEV Instance and want to login to the TEST- or PROD-Instance it happens “Unable to authenticate session”
Go to all programs, Right click on your IE icon and add -noframemerging to the end of the link in the Target field e.g.”C:\Program Files\Internet Explorer\iexplore.exe” -noframemerging (shown below)
1)  Start -> Program Files
2)  Right click on the Internet Explorer icon and select Properties
3)  Add -nomerge to the end of the link in the Target field i.e.
“C:\Program Files\Internet Explorer\iexplore.exe” -noframemerging
4)  Click the OK button to close the window
5)  This icon may then be copied to the desktop if desired.

When attempting to reset User password (Security / User / Define form) in R12, the following error occurs.
ERROR:
“Could not reserve record (2 tries). Keep trying?”
CAUSE:
Seams that it was there a deadlock to a session.
SOLUTION:
1. The session that has a deadlock should be killed
Or
2. Bounce the application including database.

How to compile forms in 11i

we have to use f60gen for compiling forms and libraries in Oracle Applications Version 11i, But this is deprecated in R12 and we need to use frmcmp(Form Compiler)  to compile forms,menus,PL/SQL libraries.
1) Login to application server.
2) Go to the directory $AU_TOP/forms/US
3) Place “.fmb” file in binary mode
4) Execute the below “f60gen” command to generate “.fmx”.
f60gen module=<formname>.fmb userid=apps/<apps_passwd> output_file=<Form_Name>.fmx module_type=form batch=no compile_all=special
EXAMPLE:
f60gen module=$AU_TOP/forms/US/APXSUMBA.fmb userid=apps/appspasswd output_file=$PROD_TOP/forms/US/APXSUMBA.fmx module_type=form  batch=no compile_all=special

How to compile forms in R12

we have to use frmcmp(Form Compiler) for compiling forms and libraries in Oracle Applications Version R12, But in 11i we need to use f60gen to compile forms and libraries which is deprecated in R12.
1) Login to application server.
2) Go to the directory $AU_TOP/forms/US
3) Place “.fmb” file in binary mode
4) Execute the below command to generate “.fmx”.
frmcmp_batch userid=apps/<apps_paswd> module=<Form_Name>.fmb output_file=<Form_Name>.fmx module_type=form batch=no compile_all=special
EXAMPLE:
frmcmp_batch userid=apps/apps module=RCVRCERC.fmb output_file=$AU_TOP/forms/US/RCVRCERC.fmx module_type=form batch=no compile_all=special

REP-0004: Warning: Unable to open user preference file

Symptoms:
All concurrent requests that run REPORTS are printing the following warning in the request log.
“REP-0004: Warning: Unable to open user preference file”
Your local (customized) Oracle Reports preference file could not be opened.
This is just a warning, so the product will continue to run even if this occurs.
The possible causes of this error include the following:
CAUSE 1: The file was not found under the specified name in the specified location
CAUSE 2: You lacked the necessary privileges to open the file.
SOLUTION [ID 1120529.1] :
To resolve the warning, copy the prefs.ora file from your Reports Builder $ORACLE_HOME/tools/admin/ directory into the Applications $HOME directory.
Example:
Copy of the file prefs.ora in the directory /u01/prod/apps/tech_st/10.1.2/tools/admin to the directory  /home/applprod/

Create New Application user from existing user in EBS R12

We can create new application user from existing user with same responsibility, Which can be achieved from FNDLOAD utility.
Here I would like to create new user with name ‘APPADMIN’ (Target user) from existing user SYSADMIN (Source user).
SOURCE USER : SYSADMIN
TARGET USER : APPADMIN

To find the responsibilities of source user:
set pages 1200
set lines 200
SELECT frt.RESPONSIBILITY_NAME, furg.end_date
FROM
fnd_user_resp_groups furg,
FND_RESPONSIBILITY fr,fnd_responsibility_tl frt,fnd_user fu
WHERE fu.user_name = ‘&&username’
AND   fu.user_id = furg.user_id
AND   furg.responsibility_id = fr.RESPONSIBILITY_ID
AND   frt.responsibility_id = fr.RESPONSIBILITY_ID
ORDER BY 1;

 

STEP 1: Use FNDLOAD to download user SYSADMIN from your instance:
FNDLOAD apps/<apps password> 0 Y DOWNLOAD $FND_TOP/patch/115/import/afscursp.lct  SYSADMIN_USER.ldt FND_USER USER_NAME=SYSADMIN
STEP 2: Modify the ldt file (SYSADMIN_USER.ldt for the example above):
Change the line <BEGIN FND_USER “SYSADMIN”> to <BEGIN FND_USER “APPADMIN”>

 

BEGIN FND_USER “APPADMIN”
OWNER = “APPSMGR”
LAST_UPDATE_DATE = “2014/01/06″
START_DATE = “1951/01/01″

STEP 3: Use FNDLOAD to upload new user to your instance:
FNDLOAD apps/apps 0 Y UPLOAD $FND_TOP/patch/115/import/afscursp.lct  SYSADMIN_USER.ldt  FND_USER   USER_NAME=APPADMIN
STEP 4: Change the password of the new user from application and communicate.

 

Terminate runway process of cancel concurrent request

Even after cancel concurrent request, Resource related concurrent request process may not be released such processes are called RUNWAY processes. So we need to manually kill the processes from database.
Concurrent request id:

Find OS Process id:
Select request_id,os_process_id from fnd_concurrent_requests where request_id=’3574145′;
REQUEST_ID   OS_PROCESS_ID
———-               ————
3574145                162
 Check runways:
select s.sid , s.serial# from v$session s , v$process p where s.paddr = p.addr and s.process =’162′;
SID    SERIAL#
—    ——-
46    1742
KILL RUNWAY PROCESS:
ALTER SYSTEM KILL SESSION ’46,1742′;

FRM-92095: Oracle JInitiator version too low. Please install version 1.1.8.2

CAUSE: Latest version of Java installed and forms version is not compatible with currently installed JAVA

SOLUTION:
1. Check the version of java installed in your system
2. If you already have latest version of JAVA, Please go and uninstall(via Control Panel > Add/Remove Software)
3. Download the latest version of 1.6 (like 1.6.0_25 to 1.6.0_29) and install.
4. Then try open the application again with same browser.
OR you can perform below steps:
Click on startà –> Control Panel

Click on programs

Click on Java

Click on Java Tab as seen below

Click on View

After clicking on View we see Runtime Parameters
We need to set -Djava.vendor=”Sun Microsystems Inc.” under Runtime Parameters

Click ok and click Apply.
Give a try if it resolves the problem !!

Connect to apps user
[oracle@PRODEBS]$sqlplus apps/apps
QUERY 1:   SELECT home_url FROM icx_parameters;
QUERY 2:
SELECT profile_option_value
FROM fnd_profile_option_values
WHERE profile_option_id=
(SELECT profile_option_id
FROM fnd_profile_options WHERE profile_option_name = ‘APPS_FRAMEWORK_AGENT’)
AND level_value = 0;

How to Change Report Output XML Our HTML Our PDF in R12

R12 – Custom Check Payment Format

In R12, as part of the Upgrade the Custom Payment formats are not defaulted. To convert this we need to customize it, as R12 is using XML publisher to do the same. This document explains the steps required to create a Custom Payment Format.
Requirements to create a Custom Payment Format

The following are the Requirements

1. Create an .rtf
2. Create an XML Publisher template and attach the .rtf created
3. Create a Payment Format and attach the XML Publisher template
4. Create a Payment Process Profile and attach the Payment Format
5. Create Payables Document under Bank if it doesn’t have and attach the Payment Format (step3)

Steps

1. How to create a Custom Payment Format

Responsibility – Payables Manager
Navigation – Setup – Payment – Payment Administartor

Clicking on this menu, opens an OAF page, as shown below.
Under Oracle Payments Setup – Under Formats – see for Formats and click on the Go To Task Icon  (as shown in the picture below)


Enter the below mandatory fields


Enter the Code & Name .
In the Data Extract – choose Oracle Payments Disbursement Payment Instruction Extract, Version 1.0
In the XML Publisher Template – choose Standard Check Format (This we will be changing to the Custom XML Publisher Template. We will generate the output in xml and create an .rtf template with the xml code pulling necessary fields required in the final output – Refer to step 7)
Click on Apply. Now, the custom Payment Format is ready.

2. Create Payment Process Profile for the Payment Format just created

Navigation – Setup – Payment – Payment Administartor
Click on the Icon – Go to Task against the menu Payment Process Profiles as shown below

Clicking on the Icon leads to the screen below…

Click on Create.

Enter the Mandatory fields in the above shown picture.

Click on the Payment Instruction creation tab and enter the following

Click on Payment Instruction Format tab and attach the Payment Document created.

Click Apply to save the updates.

3. Create an XML  output by running the Payment Process Request

Through Applications Developer responsibility, change the Output Format of the concurrent program – Format Payment Instructions to XML and Save.

This will enable us to get the output as XML tag, which we can use to create a template from the Standard Check Format – type.
Run the Payment Process request through the Payables Manager.
Navigation – Payments – Entry – Payables Manager – Submit single request

This opens up an OAF page. Click on the Submit Single Payment Process Request

This opens an OAF page, as shown below. Enter the mandatory information as shown below..

Click on the Payment Attributes tab and enter the following information –
Pay Through Date , Payee, Payment Method , Invoice Batch Name.
Click on the Payment Attributes tab and enter the following info

Choose the Bank and Attach the Payment Document created in Step1 and the Payment Process Profile created in Step2.
Click on Submit.

Click on the Refresh Status and wait until the Invoices are selected, the Payments are built and the Format program completes.
Click on View – Requests – Find

These are the programs which gets submitted automatically when a Payment Process is submitted.

1. Auto Select
2. Scheduled Payment Selection
3. Build Payments
4. Format Payment Instruction

Choose Format Payment Instruction and click on View Log or View Output as shown below…

Clicking on View Log has the following screenshot..

Copy the xml tag into a Notepad/Wordpad and save as .xml extension (eg. Test.xml)
With the help of the xml file above, create a rtf template

4. Create a rtf template

Install BI Publisher to create a rtf template.
After installing – open MS Word to create the template.
In the MS Word click on Add-Ins as shown below

Clicking this has the screen as shown below

Click on Load XML Data and choose the above xml file which was saved. Click Open.

This leads to the below confirmation..

Now, click on Insert – Field as shown below

Choose the necessary fields required as shown below and click Insert..

Once the necessary fields are inserted, the document looks like below…

Save this file as .rtf extension (IBY_EmpPayCheck1.RTF)

5. Create an XML Template

Navigation – Setup – Payment – Payment Administartor
Under Formats – click on Go To Task icon – against the XML Publisher Format Templates, as shown below.

Here, we are going to create a Custom XML Template and we are going to attach the rtf template created in Step 4.

Click on Create Template as shown above.
Enter the below mandatory fields and choose the rtf file created in the last step.

In the Data Defintion tab – choose Oracle Payments Funds Disbursement Payment Instruction Extract 1.0
The XML Template looks like below

6. Update the Output Format of the concurrent program – Format Payment Instructions to PDF and Save. (This was changed to XML in Step3) 

7. Update the XML publisher Template in the Payment Document created in Step1 with the template created in Step 5

Navigation – Setup – Payment – Payment Administrator.
Click on Go to Task – against Formats
Query for the Formats with the Name – EmpPayCheck.
Click on the icon Update as shown below

Update the XML template to the template (EmpPayCheck) created in Step 5.  (Compare this to Step1 for the changes/updates)

8. Execute the upgrade script ibypaydocupg.sql in Patch<<6677057:R12.IBY.A >>  to create payment documents in CE_PAYMENT_DOCUMENTS table.

References – Metalink

1. How To Get An XML File To Use For Developing Custom Templates For Check Printing [ID 819066.1]
2. 11i Payment Documents Do not Exist in R12–How to create the payment documents from 11i data [ID 549024.1]
3. R12 How To Create / Modify Payment Formats IBY_PAY_CHK_STANDARD_1? [ID 562806.1]
4. How To Set XML Publisher Formatting Template? [ID 414336.1]