Post award requests (PAR) are stuck at Pre-Approved after approving the document with a large comment in it: ORA-12899: VALUE TOO LARGE FOR COLUMN (Doc ID 2244289.1)

Last updated on MARCH 15, 2017

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, Award/PO

Post award requests (PAR) are stuck at Pre-Approved after approving the document with a large comment in it.


ERROR
ORA-12899 value too large for requisition lines all actual 482 max 490

STEPS
The issue can be reproduced at will with the following steps:
1. Create Post award request
2. Submit for approval
3. PAR is stuck in pre-approved with the error message.

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