My Oracle Support Banner

WIP Material Issue Transactions Failing With No Subinv In Pending Transactions Screen (Doc ID 1910380.1)

Last updated on FEBRUARY 10, 2021

Applies to:

Oracle Work in Process - Version 12.1.1 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

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.


ERROR

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

 

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.