Archive and Purge: ORA-12899 Value too large for column AR_ARCHIVE_HEADERS COMMENTS

(Doc ID 1581893.1)

Last updated on MARCH 21, 2017

Applies to:

Oracle Receivables - Version 11.5.10.2 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
ARPURGE module: New Archive and Purge

Symptoms

When running the New Archive and Purge Concurrent Program and receive the following error:

ORA-12899 Value too large for column AR_ARCHIVE_HEADERS  COMMENTS

Steps to Reproduce:
Responsibility:  Receivables Archive and Purge
Navigation:  Click on Archive and Purge
1. Select LOV and pick Call New Archive and Purge
2. Enter required parameters, then Submit
3. Click OK to run the Request

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