EPro,PO,Receipts Are Not Getting Saved Till PO_POCALC Runs To Success. (Doc ID 2276433.1)

Last updated on JULY 20, 2017

Applies to:

PeopleSoft Enterprise SCM eProcurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

ePro requisition, PO and Receipts online transactions are not getting saved when PO calculation batch process(PO_POCALC) is in processing status These transactions gets saved the moment PO calculation batch process runs to success. It's a contention between these transactions and PO calculation process. Looks like PO_POCALC is locking some of the tables which these three transactions are also trying to update. Based on our observation, PO_POCALC is locking the table: BUS_UNIT_TBL_PM and ePro requisition, PO and Receipts save actions are also trying to update the same table. If PO_POCALC runs for 3 minutes, then all online users have to wait for 3 minutes which is not appropriate. ePro requisition, PO and Receipts online transactions are allowed 24 * 7 and running PO_POCALC every 15 minutes.
 
The issue can be reproduced at will with the following steps:
1. Create enough ePro requisitions(at least 600 to 800 requisition lines) so that PO_POCALC runs for at least 2 to 3 mins.
2. Source the requisition lines.
3. Run PO Calc process
4. Submit an ePro transaction when PO Calc batch process is in progress




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms