EGL: Equitization Process Goes To Error With Unique Constraint On Calculation Log When Using By Period End Date On Ownership Set (Doc ID 1576392.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

Customer Environment
====================
Tools 8.51,
Application release 9.1
Bundles: MP11, Bundle 24

Upgrade test environment

Error
====
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

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
 
EVERE 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.


What works
=========
works as long as calculation log is not selected

What does not work
================
rerun process equitization with undo selected and calculation log selected too

 

REPLICATION STEPS
=================
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

Business impact
===============
Failure impacting upgrade testing/ upgrade time limne

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