Output Post Processor (OPP) in oracle R12

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).

The integration of XML Publisher within Concurrent Processing is done by means of a specialized concurrent manager called the Output Post Processor (OPP). If a request is submitted which has an XML Publisher template specified as a layout for the 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.

An overview of the actions involved:

1. An application user submits an XML Publisher based report.
2. The standard concurrent manager processes the request.
3. The XML data file is generated by the standard concurrent manager. This can be done by various methods:
o Oracle Reports - Report Definition File (RDF)
o XML Publisher Data Template - XML data template linked to the Data Definition
o Any other process that produces XML output
4. A post processing action defines that the output needs to be generated by the Output Post Processor hence it is triggered by the standard manager.
5. The Output Post Processor generates the final report and informs the standard concurrent manager whether that was successful.
6. The standard concurrent manager finalizes the concurrent request.

Processes in OPP:


There should always be at least one OPP process active in the system. If no OPP service is available to process concurrent requests, completed requests that require OPP post-processing will complete with a status of Warning.

One service instance of the OPP service is seeded by default. This seeded OPP service instance has one workshift with one process.

 A concurrent manager contacts an available OPP process when a running concurrent request needs an OPP post-processing action. Concurrent managers use a local OPP process (on the same node) by default, but will choose a remote OPP if no local OPP process is available.


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

Output Post Processor (OPP) in oracle R12

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).

The integration of XML Publisher within Concurrent Processing is done by means of a specialized concurrent manager called the Output Post Processor (OPP). If a request is submitted which has an XML Publisher template specified as a layout for the 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.

An overview of the actions involved:

1. An application user submits an XML Publisher based report.
2. The standard concurrent manager processes the request.
3. The XML data file is generated by the standard concurrent manager. This can be done by various methods:
o Oracle Reports - Report Definition File (RDF)
o XML Publisher Data Template - XML data template linked to the Data Definition
o Any other process that produces XML output
4. A post processing action defines that the output needs to be generated by the Output Post Processor hence it is triggered by the standard manager.
5. The Output Post Processor generates the final report and informs the standard concurrent manager whether that was successful.
6. The standard concurrent manager finalizes the concurrent request.

Processes in OPP:


There should always be at least one OPP process active in the system. If no OPP service is available to process concurrent requests, completed requests that require OPP post-processing will complete with a status of Warning.

One service instance of the OPP service is seeded by default. This seeded OPP service instance has one workshift with one process.

 A concurrent manager contacts an available OPP process when a running concurrent request needs an OPP post-processing action. Concurrent managers use a local OPP process (on the same node) by default, but will choose a remote OPP if no local OPP process is available.


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

The concurrent manager has timed out waiting for the Output Post-processor to finish this request.

The concurrent manager has timed out waiting for the Output Post-processor to finish this request.

Check that there are enough Output Post-processor service processes running.

More information may be found in the service process logfile.

Output Post Processor (OPP) issue



Solution:

Two profiles options actually control the timeouts of OPP.

             i.        Concurrent:OPP Response Timeout
            ii.        Concurrent:OPP Process Timeout

  1. OPP No Response: 
                      i.        Increase the value (in seconds) for the profile option 'Concurrent:OPP Response Timeout'. If the current value is 120 then set it to 7200. 
                     ii.        Increase the number of processes or threads (or both) of the OPP via System Administrator >Profile>
Find Both like that or set value 7200..
 %Concurrent%OPP%Process%Timeout%
7200
%Concurrent%OPP%Response%Timeout%
7200

Save it.

                    iii.        Bounce application services.

REP-0004 INVOKING THE ORACLE REPORTS BUILDER

REP-0004 INVOKING THE ORACLE REPORTS BUILDER (Doc ID 1013620.6)

APPLIES TO:

Oracle Reports Developer - Version 6.0 to 11.1.2.2.0 [Release 6 to 11g]
Oracle Application Object Library - Version 11.0.0 to 12.1 [Release 11 to 12.1]
Generic UNIX
Checked for relevance on 20-Oct-2015

SYMPTOMS

You are receiving the following error from Oracle Reports:

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

 There may also be other errors like:

REP-0003  - Warning - Unable to open global preference file.

REP-3000 - Internal error starting Oracle Toolkit.

CAUSE

 There are several causes of this error.

SOLUTION

Possible causes and solutions of REP-0004 include the following:

1.  No prefs.ora file in HOME directory:

Oracle Reports will look into the user's HOME directory for the prefs.ora preferences file.
 If a prefs.ora file does not exist in your HOME directory, you can copy the prefs.ora
file that came with the Oracle Tools.

A prefs.ora file is shipped with the Oracle Tools, and is located in:

$ORACLE_HOME/tools/admin/prefs.ora

You can also create a prefs.ora file the first time you are in the Reports Builder

To create a prefs.ora file from the Oracle Reports Builder

Oracle Reports 6.0.X:

Start the Oracle Reports Builder
Select Tools->Preferences
Select your preferences
Press the OK button
This will save a prefs.ora file in your HOME directory when you exit Reports Builder.
Oracle Reports 9.x / 10.x /11.x:

Start the Oracle Reports Builder
Select Edit->Preferences
Select your preferences
Press the OK button
This will save a prefs.ora file in your HOME directory when you exit Reports Builder.

2.  Location of the prefs.ora file:

If you want to use a prefs.ora file in a different directory than HOME (for versions < 11g) or
ORACLE_INSTANCE/config/FRComponent/frcommon/tools/admin/ for 11g, set the
 $ORACLE_LOCALPREFERENCE environment variable to that directory.

Example:  You want all users to access a common prefs.ora file located in /home/allusers/prefs.ora.

% setenv ORACLE_LOCALPREFERENCE /home/allusers

              OR

% export ORACLE_LOCALPREFERENCE=/home/allusers

3.  Insufficient privileges on the prefs.ora file:

The user invoking Oracle Reports must have read privileges on the prefs.ora file.  

4.  A system error made it impossible to open the file. 

The preferences file may have become corrupted.  If you suspect file corruption,
copy $ORACLE_HOME/tools/admin/prefs.ora and respecify your preferences.  

Note:
Oracle Forms and Oracle Graphics also read prefs.ora, thus you will have to respecify
all preferences that were set in the corrupted prefs.ora file.
Consult your operating system documentation or contact your system administrator for assistance
 setting environment variables or file privileges.

REP-0004

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

Metalink id:
R12: Request Logs Contain the Message "REP-0004: Warning: Unable to open user preference file" [ID 1120529.1]


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.

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

[applprod@sujeet ~]$ cd /apps/prod/apps/tech_st/10.1.2/tools/admin/

[applprod@sujeet  admin]$ ls
prefs.ora  

[applprod@sujeet  admin]$ cp prefs.ora /home/applprod/

Note: Bounce apache service.



Issue resolved.


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.

APP-FND-00362

"APP-FND-00362: Routine afpbep cannot execute request &REQUEST for program &PROGRAM,
 because the environment variable &BASEPATH is not set for the application to
which the concurrent program executable &EXECUTABLE belongs."


Cause :- 

The issue is caused by a custom executable name for the Invoice on Hold report: XXX_APXINROH


Solution :-

(R) : System Administrator
(N) : Concurrent > Program > Define

Search for short name : APXINROH
1 - Change the Executable Name from XXX_APXINROH to APXINROH
2 - Re-run the report and confirm the error is resolved.

If issue not resolved please try below steps.

OR

The error occurs when run only Thai Localization Reports.
And your customer confirms, the issue was solved after setting the basepath of $CLA_TOP in .env file.

Linux 7 installation steps

 Red Hat Enterprise Linux 7 (64 bit) Installation steps by steps

Once you insert and boot your machine with the RHEL DVD, you will get the below screen. 

Select "Install Red Hat Enterprise Linux 7 and Press "Enter".

Select the Language preference.

The Next screen contains almost all the configuration which has to be performed for the installation. Since we have already selected our Language and Keyboard preferences, we can skip that step here.

Lets start by setting the Date and Time.

Select your Location as for me it is Asia/Kolkata.

Next we will select the packages which we want to install. So Select "Software Installation" which will lead you to the below screen. In my case I will install the "Base Installation" package having "Server with GUI" and in case you want to add any extra Add On, you can select the same from the left panel as shown below.

Next we need to configure partitions. So select "Installation Destination"

Select the hard disk which you have used to install RHEL 7, as for my case as you can see 200 GB hard drive.

Also if you want the OS to automatically create the partition select the same or else for this article lets manually create the partitions.

I will create /boot, /, swap space 
note- swap space depend on RAM size if RAM-10 GB than Swap-20 GB.

Click on Done and select Accept Changes.

The last one is to Configure Network.

Change the Ethernet device name or else you can skip that part. Next configure you IP details as per your environment i.e IPv4 or IPv6. We are using IPv4 so selected the "IPv4 Settings" and added the IP, Netmask,Gateway and DNS details in the same.. Click on "Done" to save the configuration and go a step back.

So we are done here with all the options on this screen. Next we can "Begin Installation"

As you see the installation has begun in the mean time you can add a password for your root user. Also you can create additional user by using the "User Creation" thumbnail.

Provide a password for root account.

Create a user.(Optional).

In the mean time let the installation complete. Once done click on Reboot.

Once the machine reboots, next it will prompt the below screen. Click on "License Information"

Accept the Terms and Conditions.

Click on "Finish Configuration".

Next you will get the Kdump configuration page.

Let us enable the Kdump and let the machine decide the amount of memory required for the same.

I do not want to register my system to RHN as for now,also we can perform this step later so let us skip this part for now.

Next you get your Login Screen which means we have successfully installed our Operation System i.e. RHEL 7.0 (64 bit).





ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%'

 This MySQL error — ERROR 1396 (HY000): Operation ALTER USER failed for 'Mysql'@'%' — means that MySQL cannot find the user ...