The WIP_SUPPLY_TYPE In The Mtl_system_items_interface Is Getting The Value -999999

(Doc ID 2250526.1)

Last updated on AUGUST 28, 2017

Applies to:

Oracle Item Master - Version 12.2.6 and later
Information in this document applies to any platform.


On : 12.2.6 version, Item Issues

Users are loading items into MTL_SYSTEM_ITEMS_INTERFACE along with TEMPLATE_NAME.
When "Import Items" concurrent program is executed the following error is observed.

"The column WIP_SUPPLY_TYPE must have one of the following values: 1 (Push), 2 (Assembly Pull), 3 (Operation Push), 4 (Bulk), 5 (Vendor), 6 (Phantom)."

> Value of WIP Supply Type given in Template is "Operation Pull"

> Value for WIP_SUPPLY_TYPE column in MTL_SYSTEM_ITEMS_INTERFACE after the "Import Items" program is -999999

The issue can be reproduced at will with the following steps:
1) Load the records into MTL_SYSTEM_ITEMS_INTERFACE with template.
2) Template should be having WIP_SUPPLY_TYPE as any valid value - say "Operation Pull"
3) Now execute the program "Import Items"
The program errors out with above error


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