PO Approval Workflow Performance Issue After Upgrading the Application and Database
Last updated on OCTOBER 07, 2016
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 220.127.116.11.
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