My Oracle Support Banner

API GME_API_PUV.CREATE_MATERIAL_TXN errors with ORA-06502: PL/SQL (Doc ID 1446366.1)

Last updated on JUNE 01, 2018

Applies to:

Oracle Process Manufacturing Systems - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

The API GME_API_PUB.CREATE_MATERIAL_TXN errors as follows

Message 1 ORA-06502: PL/SQL: numeric or value error: character to number conversion error in Package GME_transactions_PVT Procedure gme_post_process
Message 2 Txn Success.

The material transaction (MTL_MATERIAL_TRANSACITONS) is created but the Actual Quantity on Batch Material Line is not updated (i.e. ACTUAL_QTY on GME_MATERIAL_DETAILS).

Example script wrapper calling the public API:

 

Changes

Applied <patch 13630492:R12.GME.A> attempting to fix the issue but the issue remained and the issue was unchanged.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.