FLUID APPROVALS ITEMS HAVE UNRESOLVED DATA FORMAT %RECORD.FIELDNAME% - ORA-00942 Error on Approvals Page

(Doc ID 2241844.1)

Last updated on SEPTEMBER 14, 2017

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
PeopleSoft 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%



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