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

Last updated on AUGUST 23, 2017

Applies to:

Oracle Work in Process - Version 12.1.1 to 12.1.3.4 [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

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