My Oracle Support Banner

CCG COMPARISON ERROR "Error in Insert Comparison Data. ORA-12899: value too large fo r column "AMHOME"."TICK_COMPARE_DATA_DETAIL"."OBJECT_PK_DISP_ONE" (actual: 261, maximum: 250)" (Doc ID 989539.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

Oracle Configuration Controls Governor - Version 5.5 and later
Information in this document applies to any platform.

Symptoms


On : CCG 5.5 version, Integra Apps

When attempting to run a comparison of snapshots for any object
the following error occurs. Note that example here is in PO 12.0.4 Supplier Sites.

ERROR
-----------------------
Error in Insert Comparison Data. ORA-12899: value too large for column "AMHOME"."TICK_COMPARE_DATA_DETAIL"."OBJECT_PK_DISP_ONE" (actual: 261,
maximum: 250)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create 2 snapshots of PO 12.0.4 Supplier Sites.
2. Run comparison of the two snapshots.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot view comparison report.

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
References


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