EGL9.2: Allocation Group Report Errors For 3char (ex. UIP) Allocation Group Name
Last updated on JANUARY 02, 2018
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.
'A SQL error occurred. Please consult your system log for details.'
In online trace file observed the below statement failing:
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;
ORA-01722: invalid number
01722. 00000 - "invalid number"
*Cause: The specified number was invalid.
*Action: Specify a valid number.
Steps to Replicate:
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