GLPPOSS Posting: Single Ledger ORA-00001: unique constraint (GL.GL_ACCOUNT_HIERARCHIES_U1) violated
Last updated on SEPTEMBER 16, 2016
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
SHRD0043: ERROR: ORA-00001: unique constraint (GL.GL_ACCOUNT_HIERARCHIES_U1) violated
The glxacovl.sql script has been run, but returns no results.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms