EGL: EFFDT Conversion Causes "Data Being Updated Does Not Exist (18,4)" or "Allocation Group XXX does not contain any active steps. (5810,11)" Error During Upgrade to 9.1 (Doc ID 1268455.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.
***Checked for relevance on 19-Jun-2014***
****Checked for Currency on 26-NOV-2015****

Symptoms



Upgrade to 9.1

Issue
=====
The effective date being added to allocation groups during the upgrade process is the current datetime instead of the original effective date from prior releases.


Error message
------------------
Following errors related to above issue may occur.

1. "Data Being Updated Does Not Exist. (18,4)
- When updating and saving an existing Allocation Group in correction mode.

2. "WARNING: Allocation Group XXXXX for Business Unit XXXXX does not contain any active steps. (5810,11) "
- When running allocation on any existing allocation group.


Impact
======
The existing allocation groups cannot be deleted or have their effective date modified because the effective date value stored in the database is a datetime and no matching value can be found when saving the changes to allocation group.

Additionally, after upgrade, if customer run the process on existing allocation group/step, they would also run into the (5810,11) error even if these steps are active as shown on PIA page and via backend query.

This is because AE step FS_ALLC_PROC..Process.GetSteps ,which fetches data on the allocation step, does not return any matching value when comparing the EFFDT (in 'YYYY-MM-DD-HH24.MI.SS.FF' format with the run control as of date in 'YYYY-MM-DD' format.

Concerned SQL.

SELECT....................................
FROM PS_ALLOC_STEP_TBL S , PS_ALLOC_GRSTP_TBL G WHERE S.SETID = 'TJU' AND S.PROCESS_STEP = G.PROCESS_STEP AND G.EFFDT = ( SELECT MAX( EFFDT ) FROM PS_ALLOC_GROUP_TBL WHERE SETID = G.SETID AND PROCESS_GROUP = G.PROCESS_GROUP AND EFF_STATUS = 'A' AND EFFDT <= TO_DATE('2010-09-01','YYYY-MM-DD')) AND S.EFFDT = ( SELECT MAX( EFFDT ) FROM PS_ALLOC_STEP_TBL WHERE SETID = S.SETID AND PROCESS_STEP = S.PROCESS_STEP AND EFFDT <= TO_DATE('2010-09-01','YYYY-MM-DD')) AND S.EFF_STATUS = 'A' AND G.SETID = S.SETID AND G.PROCESS_GROUP = 'TJUHMM' AND G.SEQUENCE_NBR_6 >= 0 AND ' ' = ' ' ORDER BY G.SEQUENCE_NBR_6

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