GLPPOS Journal Posting Errors with ORA-00001: unique constraint (GL.GL_SUMMARY_INT_5_U1) violated or ORA-00001: unique constraint (GL.GL_SUMMARY_INT_7_U1) violated (Doc ID 853411.1)

Last updated on MARCH 18, 2016

Applies to:

Oracle General Ledger - Version 12.0.0 to 12.0.5 [Release 12.0]
Information in this document applies to any platform.
Executable:GLPPOS - Posting

Symptoms

On 12.0.6 in Production:
When attempting to post the journal, the program is completed with the following error:

ERROR
--------
SHRD0043: ERROR: ORA-00001: unique constraint (GL.GL_SUMMARY_INT_5_U1) violated
or
SHRD0043: ERROR: ORA-00001: unique constraint (GL.GL_SUMMARY_INT_7_U1) violated

Steps To Reproduce:
-------------------------
The issue can be reproduced at will with the following steps:
1. Journal > Post
2. Submit GLPPOS posting program

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