Material Exceptions Doing Partial Negative Incremental Backflush (Doc ID 2093313.1)

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.

Symptoms

On : 12.1.3 version, Batches

ACTUAL BEHAVIOR
---------------
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.

EXPECTED BEHAVIOR
-----------------------
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.

STEPS
-----------------------
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.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot do partial negative incremental backflushes.

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