R12 GLSTPM Add/Delete Summary Accounts And GLPPOS Posting Programs Error With SHRD0043: ERROR: ORA-00001: unique constraint (GL.GL_SUMMARY_INT_2_U1) violated (Doc ID 779949.1)

Last updated on MARCH 15, 2017

Applies to:

Oracle General Ledger - Version 12.0.4 and later
Information in this document applies to any platform.
Executable:GLSTPM - Add/Delete Summary Accounts
Executable:GLPPOS - Posting

Symptoms

When running the Add/Delete Summary template program for the fist time it errors. ALso when run the Posting program it also errors.

The GLSTPM log shows the following error:

GLSTPM module: Add/Delete Summary Accounts

<< glucmt() 29-JAN-2009 15:01:15
STPM0003: The template "D-D-Expenses-T-T" has been validated. All rollup groups are defined.

>> glsdsh() 29-JAN-2009 15:01:15
SHRD0119: Deleted 0 record(s) from GL_SUMMARY_HIERARCHIES.
SHRD0119: Deleted 0 record(s) from GL_SUMMARY_HIERARCHY_INT.


>> glsgsmi() 29-JAN-2009 15:01:15
SHRD0114: Executing Pro*C statement Insert into gl_sum_int ...

SHRD0043: ERROR: ORA-00001: unique constraint (GL.GL_SUMMARY_INT_2_U1) violated

<x glsgsmi() 29-JAN-2009 15:01:15

<x gls_csa_rollup() 29-JAN-2009 15:01:15
SHRD0075: Error in gls_csa_rollup().

<x glsmah() 29-JAN-2009 15:01:15
SHRD0075: Error in glsmah().

<x glstadd() 29-JAN-2009 15:01:15
SHRD0075: Error in glstadd_addtmp().

 

 

THE GLPPOS log shows the following error:
SHRD0043: ERROR: ORA-00001: unique constraint (GL.GL_SUMMARY_INT_2_U1) violated

 


Due to this error the summary accounts are not being created.
This is occuring in all instances.

Changes

This has not worked in the past - new setup.

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