APXINUPD: Performance Issue On Mtl_serial_numbers Table When Running Supplier Merge Program (Doc ID 2050329.1)

Last updated on AUGUST 31, 2015

Applies to:

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


On : 12.1.3 version, LOTSERATT

The Supplier Merge program, APXINUPD, encounters a performance issue in INV_VENDORMERGE_GRP.

SQLTXTRACT shows Full Table Scan on MTL_SERIAL_NUMBERS for all execution plans.

Expect the Supplier Merge to run in a reasonable amount of time.

The issue can be reproduced at will with the following steps:
1. Submit Supplier Merge Program for supplier#SUPP101 and site code 'Denver-01'.
2. It is currently taking around 19 hours to complete.


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