R12.2.4: RVCTP: RVTPT-050: ORA-01455: Converting Column Overflows Integer Datatype (Doc ID 2004225.1)

Last updated on JANUARY 19, 2017

Applies to:

Oracle Inventory Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Receiving Functions

After populating data in rcv_headers_interface and rcv_transactions_interface, when attempting to run the Receiving Transaction Processor it runs into the following error:


ERROR
-----------------------
Concurrent program RVCTP returned error

Cause: RVCTP encountered an internal error. Parameters: RVCTP,BATCH,33520,83,

Action: Note both this error number and the actions you are trying to perform. Contact your system admi
RVTBM-007: Subroutine rvtbm_batch_mngr() returned error

Cause: Subroutine rvtbm_batch_mngr() returned an internal error.

Action: Note this error number and the actions you are trying to perform. Contact your system admini
RVTBM-080: Subroutine rvtptcontrol() returned error

Cause: Subroutine rvtptcontrol() returned an internal error.

Action: Note this error number and the actions you are trying to perform. Contact your system administrator
RVTPT-050: ORA-01455: converting column overflows integer datatype
  

Cause: A SQL error has occurred in RVTPT. The SQL error is &LSQL_ERR.

Action: Take note of both this error number and the actions you were t
Concurrent Manager encountered an error while attempting to start your immediate concurrent program RVCTP. Routine &ROUTINE received a return code of failure.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Populate data in rcv_headers_interface and rcv_transactions_interface.
2. Launch RVCTP: Receiving Transaction Processor.
3. The concurrent program will run into above mentioned error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create receipts using ROI.

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