EGL92:Allocation Group Report Errors For 3char (ex. UIP) Allocation Group Name

(Doc ID 2317622.1)

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.

Symptoms


Issue:

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

ERROR
-----------------------
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;


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



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