When Approving Purchase Orders, the Automatically Launched PO Output for Communication Concurrent Program Takes Too Long To Complete and Has Performance Issue Releated to the PO_WF_USER_TMP Table (Doc ID 2994609.1)

Last updated on DECEMBER 22, 2023

Applies to:

Symptoms

When approving a Purchase Order, the workflow stops at Activity "MAIL_DOC_PROCESS / WAITFORCONCURRENTPROGRAM-1" and appears to hang at this Activity without progressing to the subsequent workflow activities to notify the supplier about the Purchase Order. 

The workflow has stopped at this Activity as it is waiting on the launched PO Output for Communication program to complete.   This program creates the PDF to include in the notification to the supplier users.  

It is observed when this issue occurs it is specific to certain suppliers.   All Purchase Orders for an affected supplier will encounter the same issue. 

Trace files reveal a performance issue while building the list of supplier users to notify about this Purchase Order.   The long running sql is below and it also appears to run in a loop in the trace files 

 
The issue can be reproduced using these steps
1. Go to Purchasing responsibility and Purchase Orders > Purchase Orders
2. Create Purchase Order for affected supplier
3. Submit for approval
4. Workflow stops at WAITFORCONCURRENTPROGRAM-1 waiting on long running "PO Output for Communication" program

 

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.