PO Approval Workflow Performance Issue After Upgrading the Application and Database (Doc ID 1987728.1)

Last updated on OCTOBER 07, 2016

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

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.

Changes

 Upgrade the application from 12.0.6 to 12.1.3 and the database from 10.2.04 to 11.2.0.4.

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