Error ' GME_LINE_TYPE_TXN_TYPE_DIFF' In Wip Completion Transaction when using the API GME_API_PUB.CREATE_MATERIAL_TRANSACTION API

(Doc ID 2103022.1)

Last updated on NOVEMBER 03, 2016

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

Error in WIP Completion transaction when using  through gme_api_pub.create_material_transaction API

The error code  is 'GME_LINE_TYPE_TXN_TYPE_DIFF', the error text is

"The line type and the transaction type do not match. Ingredients can have the transaction types Wip Issue = 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."

The user might also see this error

When others exception in GME_transactions_PVT.gme_txn_message Error is ORA-12899: value too large for column "INV"."MTL_TRANSACTIONS_INTERFACE"."ERROR_EXPLANATION" (actual: 327, maximum: 240)

 

This is because the above error text is too large to fit into the test field provided to hold it.

 

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