Last updated on AUGUST 23, 2017
Applies to:Oracle Work in Process - Version 12.1.1 to 126.96.36.199 [Release 12.1]
Information in this document applies to any platform.
Work In Process (WIP) material issue transactions entered via the WIP transactions form fail to process with an error in the pending transactions table (MTL_MATERIAL_TRANSACTIONS_TEMP) indicating no subinventory was entered.
INV-NO SUBINVENTORY RECORD
No subinventory record found for &SUBINV in organization &ORG
Cause: The Subinventory record is missing in MTL_SECONDARY_INVENTORIES for the &SUBINV in organization &ORG.
Action: Define the subinventory using inventory setup forms.
STEPS TO REPRODUCE
1. Navigate to WIP Material Transactions :
> Enter the JOB#
> Select Transaction Type as WIP Issue
> Select either all Material or specific component> continue>
2. Enter the part# and all the other information like locator, subinventory, lot/serial if required qty. etc
3. Choose Done.
4. Monitor the transaction to ensure it processes.
*** Find that in some cases that the WIP Material Transaction has created a transaction with a missing subinventory ***
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