WIP Byproduct Return Transaction Correction Incorrectly Uses The WIP Completion Transaction Type (Doc ID 2146739.1)

Last updated on JULY 03, 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, API Issues

WIP Byproduct Return transaction correction uses the WIP Completion transaction type instead of the WIP Byproduct Completion transaction type.
Have identified an issue with the APPS.gme_api_pub.update_material_txn.
The public version of this package checks the Transaction_type_id and verifies the batch material detail line type.
For WIP Completion Transaction Type ID of 44 the line type should be 1. And for WIP Byproduct Completion Transaction Type ID of 1002 the line type should be 2.
In the public package (and the private version) - the offsetting transaction type id created for a WIP Byproduct Return is 44 (this is the transaction type id for WIP Completion).

ERROR
-----------------------
Product allocation failed for lot API Error Msg:
TrnsID: 111111 the line type and transaction type do not match.
Ingredients can have the transaction types WIP Iusse = 35 or WIP Return = 43
Products can have the transaction types WIP Completion = 44 or WIP Completion Return = 17
Byproducts can have the transaction types WIP Byproduct Completion = 1002 or WIP Byproduct Return = 1003


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Production Supervisor > Batches
Created a batch
1. Entered normal material transactions.
2. Added a WIP Byproduct Completion (Transaction_Type_ID = 1003) material transaction.
3. Added a WIP Byproduct Return (Transaction_Type_ID = 1002) material transaction.
4. Used Correct Material Transaction to update the WIP Byproduct Return quantity from 1000 to 1100.
a. This created a WIP Completion (Transaction_Type_ID = 44) material transaction for 1000.  The transaction type is incorrect.
b. This created a WIP Byproduct Return (Transaction_Type_ID = 1002) material transaction for 1100.
5. Used Correct Material Transaction to update the WIP Byproduct Completion from 10000 to 10100.
a. This created a WIP Byproduct Return (Transaction_Type_ID = 1002) material transaction for 10000.  The transaction type is correct.
b. This created a WIP Byproduct Completion (Transaction_Type_ID = 1003) material transaction for 10100.



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