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 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


When Posting Journals the process fails with the following 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
SHRD0043: ERROR: ORA-00001: unique constraint (GL.GL_ACCOUNT_HIERARCHIES_U1)
 <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
sqlcaid:   sqlabc: 0  sqlcode:  -1  sqlerrml: 69
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


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.