My Oracle Support Banner

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.