Thursday 12 April 2018

Profile Set For Output Showing In Oracle Apps R12

Problem: I have faceing one internal issue that getting error while extract the report output.
Solution: Profile Set For Output Showing
Applications Web Agent

The internal name for this profile option is APPS_WEB_AGENT Provides the base URL for the Apps Schema’s WebServer DAD.
You set this profile option during the install process.
This profile option must be set to the URL which identifies the mod_plsql PL/SQL Gateway Database Access Descriptor base URL for your Applications instance.
Oracle Applications use the value of this profile option to construct URLs for ’WWW’ type functions, Attachments, Export, and other features.
Use the following syntax to enter your URL:
https://<hostname>:<port>/pls/<dad_name>
Example:http://erptestappldb.in:8007/pls/TEST

All RDF Reports Running Forever With No Completion

Problem: I face one internal issue that in production instance , concurrent program are running from long time and are not getting completed.

Symptoms:
 All RDF reports like "ACTIVE USER" are running forever with no completion and no error in request/manager/internal manager log.

Submit Active Users with command line: CONCSUB

CONCSUB is a utility to submit the concurrent request from operating system level to run concurrent program, without having to log on to oracle applications.

$CONCSUB apps/<pass> SYSADMIN "System Administrator" SYSADMIN WAIT=Y CONCURRENT FND FNDSCURS PROGRAM_NAME='"Active Users"'

OR

$INST_TOP/ora/10.1.2/bin/appsrwrun.sh userid=apps/apps mode=character report=$FND_TOP/reports/US/FNDSCURS.rdf batch=yes destype=file desname=./ddr2.out desformat=$FND_TOP/reports/HPL pagesize=132x66 traceopts=trace_all tracefile=ddr2.trc tracemode=trace_replace

Get error:
Environment:Environment java.lang.UnsatisfiedLinkError: Can't find library rwu
(librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin:/devp/oracle/apps
/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/tech_st/10.1.2/lib32:/devp
/oracle/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devp/oracle/apps/tech_st/10.1.2/jdk
/jre/bin:/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/
apps_st/appl/cz/12.0.0/bin:/devp/oracle/apps/tech_st/10.1.2/lib32:/devp/oracle/a
pps/tech_st/10.1.2/lib:/usr/dt/lib:/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin:
/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/apps_st/a
ppl/sht/12.0.0/lib:/usr/lib
Environment:getEnvironmentStrings java.lang.UnsatisfiedLinkError: Can't find lib
rary rwu (librwu.a or .so) in sun.boot.library.path or java.library.path
sun.boot.library.path=/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin
java.library.path=/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin:/devp/oracle/apps
/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/tech_st/10.1.2/lib32:/devp
/oracle/apps/tech_st/10.1.2/lib:/usr/dt/lib:/devp/oracle/apps/tech_st/10.1.2/jdk
/jre/bin:/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/
apps_st/appl/cz/12.0.0/bin:/devp/oracle/apps/tech_st/10.1.2/lib32:/devp/oracle/a
pps/tech_st/10.1.2/lib:/usr/dt/lib:/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin:
/devp/oracle/apps/tech_st/10.1.2/jdk/jre/bin/classic:/devp/oracle/apps/apps_st/a
ppl/sht/12.0.0/lib:/usr/lib
REP-50125: Caught exception: java.lang.reflect.InvocationTargetException

Error in ddr2.trc:

REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-3000: Internal error starting Oracle Toolkit

Solution:

1. Check the E-Business (EBS) server environment DISPLAY as root user with commands: xhost + , xclock , echo $DISPLAY.
2. Change the DISPLAY setting in EBS context file to be value of step 1.
3. Retest the issue.