R12.2: Workflow Java Deferred Listener Goes Down with java.sql.SQLException: ORA-01000 ,WF_EVENT_OJMSTEXT_QH.ENQUEUE on Maximum Open Cursor

Issue : 


R12.2: Workflow Java Deferred Listener Goes Down with java.sql.SQLException: ORA-01000 ,WF_EVENT_OJMSTEXT_QH.ENQUEUE on Maximum Open Cursor 

Solution :

To implement the solution, please execute the following steps:

1. Download and Review the Patch 19634693 readme for its application instructions.

2. For E-Business Suite (EBS) patches, use ADADMIN to enable Maintenance Mode and then Shut down the EBS application service or middle tier.

3. Ensure that you have taken a backup of your system before applying the recommended patch on test environment.

4. Unzip the patch and go to the unzipped directory.

5. Using ADADMIN,Apply Patch 19634693 , You need to applied u19634693.drv (This is the unified driver) on the Middle Tier.

6. Once applied ,Use ADADMIN to Disable the Maintenance.

Confirm the following file versions are delivered :

fnd  java/wf/bes  WebServiceInvokerSubscription.java 120.20.12020000.6

You can use the commands like the following:
$ strings -a $<PROD>_TOP/filename |grep ‘$Header’

7. Restart the EBS Application Services to retest the issue.

8. Migrate the solution as appropriate to other environments.

  • July 3, 2019 | 38 views
  • Comments