AP:Application Engine FSPC_UPD_USR Issues SQL Error Due To Missing Field

(Doc ID 2332546.1)

Last updated on NOVEMBER 27, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

 
ISSUE:
 

When clicking on 'Activate My Work Settings' push button in 'My Work' tab in any Work center pagelet configuration, the following error occurs,

ERROR
 

'A SQL error occurred. Please consult your system log for details'.
Process 198013 ABENDED at Step FSPC_UPD_USR.STARTPG.Step04 (SQL) -- RC = 904 (108,524)

CallAppEngine: Application FSPC_UPD_USR: AppEngine error. (2,653) FSPC_ADMIN_CONFIG.GBL.FSPC_MYWORK_WRK.UPD_USER_CONFIG.FieldChange PCPC:1071 Statement:11

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information.

File: e:\pt85603c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #: 1725 Error Position: 567 Return: 904 - ORA-00904: "C"."FSPC_DATA_SOURCE": invalid identifier
Failed SQL stmt: DELETE FROM PS_FSPC_USR_STRTPG WHERE PAGELET_CONFIG_ID = 'AP' AND FSPC_PGLT_TYPE = '3' AND NOT EXISTS ( SELECT 'X' FROM PS_FSPC_ADM_WRKLST B WHERE B.PAGELET_CONFIG_ID = PS_FSPC_USR_STRTPG.PAGELET_CONFIG_ID AND B.FSPC_GROUP_ID = PS_FSPC_USR_STRTPG.FSPC_GROUP_ID AND B.FSPC_LINK_ID = PS_FSPC_USR_STRTPG.FSPC_LINK_ID AND B.SHOW_LINK = 'Y') AND NOT EXISTS( SELECT 'X' FROM PS_FSPC_USR_WRKLST C WHERE C.PAGELET_CONFIG_ID = PS_FSPC_USR_STRTPG.PAGELET_CONFIG_ID AND C.FSPC_GROUP_ID = PS_FSPC_USR_STRTPG.FSPC_GROUP_ID AND C.FSPC_LINK_ID = PS_FSPC_USR_STRTPG.FSPC_LINK_ID AND C.FSPC_DATA_SOURCE = '2')

Process 138550 ABENDED at Step FSPC_UPD_USR.STARTPG.Step04 (SQL) -- RC = 904 (108,524)

Process 138550 ABENDED at Step FSPC_UPD_USR.STARTPG.Step04 (SQL) -- RC = 904 (108,524)

CallAppEngine: Application FSPC_UPD_USR: AppEngine error. (2,653) FSPC_ADMIN_CONFIG.GBL.FSPC_MYWORK_WRK.UPD_USER_CONFIG.FieldChange PCPC:1071 Statement:11

During a CallAppEngine builtin function call, the Application Engine detected an error. The Application Engine log may provide more information.


STEPS:
 
1. Navigate to Main Menu > Enterprise Components >WorkCenter/Dashboards > Configure pagelets
2. Select any Configuration IS/Workcenter
3. Navigate to 'My Work' tab
4. Click on 'Activate My Work Settings' push button
5. The above errors occurs.


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