Column ITEM_NUM too small in table RCV_TRANSACTIONS_INTERFACE (Doc ID 2248358.1)

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.

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

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