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

(Doc ID 2317622.1)

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.

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

'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


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