The WIP_SUPPLY_TYPE In The Mtl_system_items_interface Is Getting The Value -999999
(Doc ID 2250526.1)
Last updated on NOVEMBER 04, 2023
Applies to:
Oracle Item Master - Version 12.2.6 and laterOracle Product Hub - Version 12.2.6 to 12.2.6 [Release 12.2]
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
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |