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.

Symptoms

On : 12.1.3 version, LOTSERATT

ACTUAL BEHAVIOR
---------------
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.

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

STEPS
-----------------------
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.

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