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
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****
Upgrade to 9.1
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.
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.
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.
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
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