Column ITEM_NUM too small in table RCV_TRANSACTIONS_INTERFACE
Last updated on MAY 29, 2017
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.
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