R12: Slow Performance In PDOI During Migration
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
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.
1. Insert multiple BPA Data records into interface tables (po_headers_interface, po_lines_interface).
2. Run concurrent program 'Import Price Catalog'
This was for fresh/upgrade implementation to release 12.
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