FLUID APPROVALS ITEMS HAVE UNRESOLVED DATA FORMAT %RECORD.FIELDNAME% - ORA-00942 Error on Approvals Page
(Doc ID 2241844.1)
Last updated on JANUARY 26, 2024
Applies to:
PeopleSoft Enterprise HCM Human Resources - Version 9.2 and laterPeopleSoft Enterprise PT PeopleTools - Version 8.54 and later
PeopleSoft Enterprise HCM eProfile Manager Desktop - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
Symptoms
ISSUE
Fluid Approvals page EOAWMA_MAIN_FL items have unresolved data in format %RECORD.FIELDNAME%
Example:
Absence: %HGA_NAME_VW.NAME_DISPLAY%
ePerformance: %EP_APPR_SUM_VW.NAME%
Click the item and go to the page EOAWMA_TXNHDTL_FL
See Error: "A SQL error occurred. Please consult your system log for details."
Logs show the following error:
PSAPPSRV.5008 (476) 1-178 10.20.28 314.635000 SQL error. Function: Rowset.Fill Error Position: 349
Return: 942 - ORA-00942: table or view does not exist
Statement: select fill.eopcobj_button_l0,fill.eopcobj_button_l0a,fill.eopcobj_button_l0b,fill.eopcobj_button_l0c,fill.eopcobj_button_l0d,fill.eopcobj_link_l0,fill.eopcobj_link_l0a,fill.eopcobj_link_l0b,fill.eopcobj_link_l0c,fill.eopcobj_link_l0d,fill.eopcobj_tapb_l0,fill.eopcobj_tapb_l0a,fill.eopcobj_tapb_l0b,fill.eopcobj_tapb_l0c,fill.eopcobj_tapb_l0d from PS_EOAW_EOPCPB0_WK FILL
Original Statement: %SelectAll(:1 FILL)
PSAPPSRV.5008 (476) 1-179 10.20.28 0.000000 Exception happend in CScrollObjRef::Fill method(), pszWhere=
PSAPPSRV.5008 (479) 1-180 10.21.55 86.614000 Cur#1.5008.HRDEV RC=0 Dur=0.000000 COM Stmt=SELECT VERSION FROM PSVERSION WHERE OBJECTTYPENAME = 'SYS'
PSAPPSRV.5008 (479) 1-181 10.21.55 0.013000 7: %Response.Write("<span class='PSERRORTEXT'>PC Trace is On</span>" | Char(10));
PSAPPSRV.5008 (479) 1-182 10.21.55 0.000000 8: End-Function;
REPLICATION
The issue can be reproduced at will with the following steps:
1. login and go to MSS > note that the count of Approvals appears to be correct
2. click Approvals Tile
3. observe that the listing of approval items contains " %#####%" for items, appearing to be variables for the fields
e.g. %HRS_JOBOPEN_VW3.HRS_JOB_OPENING_ID%
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |