EGL: Equitization Process Encountered 'SQLRT error in GLPQPROC-KA000 FLUSH BULK CLOG' When Run With Ownership Set Option As By Period End Date

(Doc ID 1576392.1)

Last updated on DECEMBER 09, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
-------
Equitization process (GLPQEQTZ) goes to error when the following scenario is processed:
- processing more than one Accounting Period (TimeSpan = YTD or BAL)
- Effective-Date Ownership Sets field is set to 'by Period End Date(s)'
- Create Calculation Log checkbox is selected on the Equitization Request

 

Error:
-------


Application Program Failed
 Action Type : FLUSH BULK
 In Pgm Section : SQLRT: XA000-FLUSH-BULK
 With Return Code: 00805
 Error Message : ORA-00001: unique constraint (SYSADM.PS_EQTZ_CALC_LOG) violated
 
SEVERE ERROR IN PGM:(5850,5) PI(104661) Program(GLPQPROC) SQLRT error in GLPQPROC-KA000 FLUSH BULK CLOG.
Program(GLPQEQTZ)  Equitization Processes ended. Requests Completed: 0 Successfully, 1 Errors.

Steps to Replicate:
---------------------


Set up equitization related detail
1.  Created 4 Business units
2.  Created Ledger/ledger group
3.  Setup ledger for a unit making sure all periods open for year
4.  Created Equitization tree
5.  Set up Consolidation Ledger set
6.  Set up Subsidiary ownership sets for 3 of the 4 bu's all owned 100% by
one of the other bu's
7.  Set up Net Income Equitization Rule(C_PTOI) using tree for chartfield
value set for incomestatement
  Not sure that it matters:
  NO SUBSIDIARY OFFSET
  NO MINORITY INTEREST
8.  Create Equitization Groups
SHARE = EQ_TEST
LEDGER SET = TEST
TIMESPAN = BAL
EFFECTIVE DATE FOR OWNERSHIP SETS =  BY PERIOD END
MASK    = EQTA
SOURCE  = CON

RULES  = C_PTOI
REVERSAL = BEGINNING OF NEXT

9.  Equitization Request

FREQUENCY= ALWAYS
SETID = SHARE
EQT GROUP = EQ_TEST
CURRENCY = USD
AS OF DATE = 2/28/2014
PROCESS EQUITIZATION CHECKED  
EDIT JOURNALS CHECKED
UNDO PREVIOUS PROCESS CHECKED  (after initial run)
TREE BU_DT_CN_COMB …PROCESS WHOLE TREE
TREE EFFECTIVE DATE USE AS OF DATE

10.  Make sure data includes at least two months worth of data

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