My Oracle Support Banner

Lockbox Validation Fails With Error AR-ARLPLB: -12899 ORA-12899: Value Too Large for Column (Doc ID 1400661.1)

Last updated on FEBRUARY 13, 2019

Applies to:

Oracle Receivables - Version 12.0.0 and later
Information in this document applies to any platform.
Executable:ARLPLB - Process Lockboxes


Symptoms

Attempting to run the Lockbox program and receive the following error in the Lockbox validation:

AR-ARLVCU Error from arlpid.
exiting arlpid
Current system time is 17-NOV-2011 17:25:13
AR-ARLVAL: arlpid returned FALSE.
AR-ARLVAL: Error from arlval.
exiting arlval
Current system time is 17-NOV-2011 17:25:14
AR-ARLPLB: arlval returned FALSE.
AR-ARLPLB: Error in main.
AR-ARLPLB: -12899 ORA-12899: value too large for column "AR"."AR_PAYMENTS_INTE

This happens when tje column "Invoice1" VARCHAR2(50) in AR_PAYMENTS_INTERFACE_ALL has a value that exceeds a length of 20 characters and it tries to update the column "Resolved_matching_number1" (VARCHAR2(20) with that value.

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
 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.