Concurrent programs taking too long to complete - EBS 12.2.5

Concurrent programs taking too long to complete and most of the time is spent in Output post processor Apply latest patch : 34091953 This patches creates a file oppjava.sh if you are on instance 12.2.5 or earlier Download 64 bit jre from the internet and place it in a location accessable by applmgr In my case I downloaded and unzipped it in below location /u25/TEST/JREOPP/JRE

-bash-4.1$ cd /u25/TEST/JREOPP/JRE/
bin/                         lib/                         man/                         release                      Welcome.html
COPYRIGHT                    LICENSE                      README                       THIRDPARTYLICENSEREADME.txt
-bash-4.1$ cd /u25/TEST/JREOPP/JRE/bin/
-bash-4.1$ ./java -version
java version "1.8.0_202"
Java(TM) SE Runtime Environment (build 1.8.0_202-b08)
Java HotSpot(TM) 64-Bit Server VM (build 25.202-b08, mixed mode)
-bash-4.1$

Open the oppjava.sh and modify JSERVJAVA parameter to the java location as seen below.

JSERVJAVA=/u25/TEST/JREOPP/JRE/bin/java

Add below entry in custom env file for 12.2

-bash-4.1$ cat /u25/TEST/fs1/inst/apps/TEST_testerp/appl/admin/customTEST_testerp.env
AFOPPJVM="Y"
export AFOPPJVM

Run the env file and verify the below env is accessible.

-bash-4.1$ env | grep AFOPPJVM
AFOPPJVM=Y

Shutdown the instance and update the java heap size to 3 / 4/ 5GB as required this will have implication on the system resources so ensure that you have enough of the same.

update FND_CP_SERVICES
     set DEVELOPER_PARAMETERS =
     'J:oracle.apps.fnd.cp.gsf.GSMServiceController:-Xmx4096M'
     where SERVICE_ID = (select MANAGER_TYPE from FND_CONCURRENT_QUEUES
     where CONCURRENT_QUEUE_NAME = 'FNDCPOPP');

commit;

Start the instance and verify the OPP health and run the concurrent program to see the difference. 

 

Thanks for reading. 

 regards, ZAHEER