Material Exceptions Doing Partial Negative Incremental Backflush
Last updated on MARCH 08, 2017
Applies to:Oracle Process Manufacturing Process Execution - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Batches
When doing partial negative Incremental Backflush (returning less than the total that was originally backflushed), the system sometimes gives Material Exceptions for an ingredient, and the debug log contains a statement about material status being invalid. This is occurring on an ingredient that has a default material status that does not allow WIP Issue, although the onhand status had been changed before the initial WIP Issue to a status that does allow WIP Issue.
Some of the time that this occurs it is when the initial WIP Issue had consumed the entire onhand quantity, and therefore there is no longer any onhand material status for the lot. When the negative IB needs to return only a portion of the lot, it first does a WIP Return of the full consumed qty, and then tries to do a new WIP Issue for the quantity that is not being reversed. However, when the WIP Return is done, the material status takes on the default status, which then does not allow the subsequent WIP Issue, so this fails.
If you try to do the same thing (that is, return a portion of the quantity) for the lot using Correct Material Transactions, however, it goes through and the onhand is created with the material status that the material had when the initial WIP Issue was done. This is because a change was made in the Corrections code specifically to handle this scenario.
Expect negative IB to work the same way as Corrections, to be smart enough to realize that you are really returning a portion of the quantity, and so to allow this to go through.
The issue can be reproduced at will with the following steps:
1. Consume entire quantity of a lot in a location for an ingredient that has a default material status that does not allow WIP Issue (but the material status for this lot in this location has been changed to allow WIP Issue) with incremental backflush.
2. Try to do a partial negative Incremental backflush that would require returning only a portion of the ingredient to onhand inventory.
The issue has the following business impact:
Due to this issue, users cannot do partial negative incremental backflushes.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms