My Oracle Support Banner

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.

Symptoms

On : 12.2.6 version, Item Issues

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

ERROR
-----------------------
"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)."

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

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


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


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.