Purchase Order Creation Using Po_pdoi_grp Is Slow At Times (Doc ID 1678599.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

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

Symptoms

After doing the firmware update to AIX database tier have been having performance with calling po_pdoi_grp.start_process inline in the code.
seeing WAIT #47: nam='SQL*Net message to dblink.
This is not data or system load related. It can happen with a small PO or large and at any time.

This wait is seen mostly when PO_WF_PO_CHARGE_ACC.SET_NULL_RESP_ID is being executed.

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