R12: Slow Performance In PDOI During Migration (Doc ID 428948.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 12.0 and later
Information in this document applies to any platform.
EXECUTABLE:POXPDOI - Import Price Catalogs

Symptoms

 Performance of 'Import Price Catalog' is slow while migrating blankets.  This is happening when 'UPDATE' action is used on the blanket.  Custom wrapper/scripts were inserting header records for each line updated or created.

STEPS
1. Insert multiple BPA Data records into interface tables (po_headers_interface, po_lines_interface).
2. Run concurrent program 'Import Price Catalog'

Changes

This was for fresh/upgrade implementation to release 12.

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