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

Last updated on SEPTEMBER 16, 2016

Applies to:

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

Symptoms

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.

 

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