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.

Profile Set for enable/disable Report Output generation

Problem: Profile Set for enable/disable Output generation

Solution: Profile Set For Output Showing
Profile Name: 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

Address data entered in HRMS not visible in the CRM Resource Manager

Problem:
When an employee is created in HRMS, address of the employee will be
entered in the address button.
When the employee is imported as CRM Resource in CRM Resource Manager,
address of the corresponding resource could not be seen in Miscellaneous tab

Solution:

To resolve the issue do the following

Step 1:
Navigation: Super HRMS Manager > People > Enter and Maintain > (B) Address
Ensure that "Primary" check box is enabled in address window of HRMS

Step 2:
Navigation: System Administrator > Profile > System
Set the following Profile Options
1) HZ: Protect HR Person Information = No

2) JTFRS: Hide Sensitive HR Data = No

The above profile option can be set either at Site level or at
Responsibility level

Step 3:

Navigation: System Administrator > Application > Function. Query the
function "JTFRSDEF". Go to Form tab and enter the below parameter and save
Pass the parameter "P_HIDE_SENSITIVE_HR_DATA=N" to the Define Resources
form.

Now, go to Miscellaneous tab in CRM Resource Manager and view the
address data.