EGL92:Allocation Group Report Errors For 3char (ex. UIP) Allocation Group Name
Last updated on OCTOBER 13, 2017
Applies to:PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Allocation Group report errors if the allocation group name is less than 3 char.This error does NOT occur if the allocation group name is 4+chars (ex. UIP_CONSOL); the Allocation Group report runs successfully.
SELECT SETID, PROCESS_GROUP, VERSION_GRP, EFFDT, TO_CHAR(EFFDT,'YYYY-MM-DD'),
EFF_STATUS, DESCR FROM PS_ALLOC_GROUP_TBL
WHERE SETID='UMICH' AND PROCESS_GROUP='UIP'
AND VERSION_GRP='UIP' AND EFFDT<=TO_DATE('2008-09-30','YYYY-MM-DD')
ORDER BY SETID, PROCESS_GROUP, VERSION_GRP DESC, EFFDT DESC;
The issue can be reproduced at will with the following steps:
1. Create a new allocation Group report with allocation group name is less than 3 char
2)Hit the save
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