My Oracle Support Banner

GLPPOSS Posting: Single Ledger ORA-00001: unique constraint (GL.GL_ACCOUNT_HIERARCHIES_U1) violated (Doc ID 1534219.1)

Last updated on AUGUST 11, 2021

Applies to:

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


Posting a journal gives the following error in the log file:

GLPPOSS module: Posting: Single Ledger
Current system time is 15-JAN-2012 11:06:42

>> glpmai() 15-JAN-2012 11:06:42
PPOS0003: *** Posting Process Started ***
PPOS0004: All phases to posting will be detailed in this log.


<< glstmt() 15-JAN-2012 11:06:42
SHRD0114: Executing Pro*C statement Insert into gl_account_h...

STPM0019: Oracle General Ledger cannot create summary accounts because a detail segment value rolls up to a
parent value multiple times.  You can determine where the problem lies by contacting your system
administrator and having him or her run the glxacovl.sql script to look for this problem.  The glxacovl.sql
script can be found under GL_TOP in the sql directory.

NOTE: Once you have fixed the segment value hierarchy, you will need to run the Program - Incremental
Add/Delete program from the Standard Report Submission screen for this new segment value hierarchy to
take effect.
SHRD0043: ERROR: ORA-00001: unique constraint (GL.GL_ACCOUNT_HIERARCHIES_U1) violated



The glxacovl.sql script has been run, but returns no results.



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.