My Oracle Support Banner

AUTOMATIC CASH APPLICATION MASTER PROGRAM ORA-12899: VALUE TOO LARGE FOR COLUMN (Doc ID 2734846.1)

Last updated on JULY 14, 2021

Applies to:

Oracle Receivables - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Receipts Related

Automatic Cash Application Master Program is ending in error

ERROR
-----------------------
java.sql.SQLException: ORA-12801: error signaled in parallel query server P006, instance dbc-pts-vm-3049:TS3CLF2 (2)
ORA-12899: value too large for column "AR"."AR_TRX_OPEN_INTERSECTION_GT"."CT_REFERENCE" (actual: 57, maximum: 50)
ORA-06512: at "APPS.ARP_AUTOAPPLY_API", line 4059
ORA-06512: at line 1

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Automatic Cash Application Master Program

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run Automatic Cash Application Master Program.

Changes

 

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
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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