PO Approval Workflow Performance Issue After Upgrading the Application and Database
(Doc ID 1987728.1)
Last updated on JULY 02, 2018
Applies to:Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
After an upgrade users are reporting slow performance when submitting Purchase Orders (PO)s for approval. The performance has gone from approving in a few seconds to taking almost 5 minutes per document.
The Analyzer output from <Note 1525670.1> - R12: PO Approval Analyzer Diagnostic Script shows the following:
26-FEB-15 13:08:19 26-FEB-15 13:08:19 POAPPRV_TOP / GET_WORKFLOW_APPROVAL_MODE PO Approval Top Process Get Workflow Approval Mode COMPLETE BACKGROUND
26-FEB-15 13:16:31 26-FEB-15 13:16:31 POAPPRV_TOP / NOOP PO Approval Top Process When background_flag=Y, Wait for Background Process COMPLETE
Although the elapsed times in the above output were not significant, it was noted that the documents were moving to BACKGROUND rather than approving immediately.
Upgrade the application from 12.0.6 to 12.1.3 and the database from 10.2.04 to 126.96.36.199.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!