My Oracle Support Banner

GLPPOS Posting Journals Process Fails Violating GL.GL_ACCOUNT_HIERARCHIES_U1 Unique Constraint (Doc ID 1011796.6)

Last updated on SEPTEMBER 18, 2019

Applies to:

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

***Checked for relevance on 12-Feb-2008 ***
Executable:GLPPOS - Posting
Executable:GLSIMS - Program - Incremental Add/Delete Summary Templates

Symptoms

When Posting Journals the process fails with the following error:

Error
-----------
>> glsiah() 19-MAR-2001 15:34:34
 SHRD0114: Executing Pro*C statement Insert into gl_account_h...
GL_PROPABLE_DUPLICATE_RANGES: APP-00001  cannot find message name
GL_PROPABLE_DUPLICATE_RANGES
SHRD0043: ERROR: ORA-00001: unique constraint (GL.GL_ACCOUNT_HIERARCHIES_U1)
violated
 <x glsiah() 19-MAR-2001 15:34:34

<x gls_csa_norollup() 19-MAR-2001 15:34:34
SHRD0075: Error in gls_csa_norollup().

<x glsmah() 19-MAR-2001 15:34:34
SHRD0075: Error in glsmah().

<x glsamn() 19-MAR-2001 15:34:34
SHRD0042: Error en RUTINA: glsamn, status: 0
SHRD0043: ERROR:
***************************************************
sqlcaid:   sqlabc: 0  sqlcode:  -1  sqlerrml: 69
sqlerrmc:
ORA-00001: unique constraint (GL.GL_ACCOUNT_HIERARCHIES_U1) violated

sqlerrp:        sqlerrd: 0 0 4 0 0 0
sqlwarn:           sqltext:  
*****************************************************
SHRD0044:  Process logging off database and exiting ...
PPOS0064: Posting exited with error status

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!


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