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.

Symptoms

When using RCV_TRANSACTIONS_INTERFACE table to receive Purchase Orders-POs and Return Material Authorizations-RMAs, Receiving Transactions Processor fails with the following error:

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.

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!


In this Document
Symptoms
Cause
Solution
References


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