Column ITEM_NUM too small in table RCV_TRANSACTIONS_INTERFACE
(Doc ID 2248358.1)
Last updated on MARCH 05, 2019
Applies to:Oracle Inventory Management - Version 12.1.3 and later
Information in this document applies to any platform.
When using RCV_TRANSACTIONS_INTERFACE table to receive Purchase Orders-POs and Return Material Authorizations-RMAs, Receiving Transactions Processor fails with the following error:
Cause: A SQL error has occurred in default_transaction. The SQL error is ORA-06502: PL/SQL: numeric or value error: character string buffer too small.
Action: Take note of both this error number and the actions you were trying to perform. Contact your system administrator for further assistance.
This is happening when item_num column > 81 characters.
The same transactions can be performed ok when using Core Receiving forms.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document