Memory Based Snapshot Worker Fails With Error "mrsstr_snp_trans_resources failed due to ORA-01455: converting column overflows integer datatype" (Doc ID 2917038.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

When attempting to run an ASCP plan, Memory Based Snapshot Worker is failing
the following error occurs.

ERROR
-----------------------

APP-FND-01564: ORACLE error 1455 in mrsstr_snp_trans_resources

Cause: mrsstr_snp_trans_resources failed due to ORA-01455: converting column overflows integer datatype
.

The SQL statement being executed at the time of the error was: select mism.transaction_id ,mism.from_organization_id ,mism.to_organiz and was executed from the file /scratch/EBS64_TOOL/APS64_R122_WORKER/msc/120/src/mslsra.pc.
APP-MRP-22075: An internal error has occurred (mrnspxt, 16, 10013, )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (mrnspgpt, 14, 202 , 10013, )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
APP-MRP-22075: An internal error has occurred (main, 13, , )
@ERRORTEXT Cause: The current routine encountered the specified@ERRORTEXT x Action: Contact your customer supportrepresentative.
Error string=
Statement with the error:
select mism.transaction_id ,mism.from_organization_id ,mism.to_organiz
/scratch/EBS64_TOOL/APS64_R122_WORKER/msc/120/src/mslsra.pc

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Launch ASCP plan.

Nav: Advanced Supply Chain Planner (R) -> Supply Chain Plan -> Launch.

2. See the above error.

Cause

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