My Oracle Support Banner

POSTING: SHRD0043: ERROR: ORA-00001: Unique Constraint (GL.GL_SUMMARY_INT_1_U1) Violated (Doc ID 1505411.1)

Last updated on OCTOBER 10, 2022

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Posting

When attempting to post journal in the newly upgraded instance
the following error occurs.


SHRD0114: Executing Pro*C statement Insert into gl_sum_int ...

SHRD0043: ERROR: ORA-00001: unique constraint (GL.GL_SUMMARY_INT_1_U1) violated

Same journal entered on R11 application version is not erroring out.

The hierarchy has not been changed since upgraded from R11 application version.

The issue can be reproduced at will with the following steps:
1. post journal

Same error could occur in the Adding new summary template program.


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

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