Sunday, May 30, 2021

Concurrent Request Status Codes and Phase Codes

 

Normally we can see four PHASES when we submit Concurrent Requests in oracle EBS Applications .


Below are the PHASES and their Meaning .


Picture
And we can use below PHASE_CODEs to update or Monitor requests from backed .

​Below are the concurrent Requests PHASE_CODES and their Meaning .
Picture
​Within each phase, a request's condition or status may change. Below appears a listing of each phase and the various states that a concurrent request can go through.

The status and the description of each meaning given below:
Picture
Below is the info about PHASE and running status and their Meaning .
Picture
Picture

Wednesday, May 19, 2021

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

When we submit concurrent request, we may see below error in log file .

ERROR:

Enter Password:

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

Cause:

This message occurs when the concurrent process attempts to open the Oracle Reports executable and your local preference file cannot be found or opened. This is just a warning, so the request will continue to run even if this occurs.

Solution:

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 /sharp01/prod/apps/tech_st/10.1.2/tools/admin to the directory  /home/appprod/.

NOTE:
For a report developed by xml publisher getting the same error, create/HDDATA/xml_tmp directory (environment dependent) on the system server after checking Administration from XML Publisher Administrator responsibility -> Configuration -> General -> Temporary directory column is /HDDATA/xml_tmp.


ORACLE DATABASE CONTENT

ORACLE DATABASE 11gR2 & 12C  CONTENT Pre-Requisite: UNIX, SQL Basics Introduction to Oracle Database §   Introduction of Database ...