EEX9.2:Expense Workcenter Is Receiving An Error When Multiple Job Sequence Have Same EFFDT

(Doc ID 2155519.1)

Last updated on JULY 13, 2016

Applies to:

PeopleSoft Enterprise FIN Expenses - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Opening Expense Workcenter user is receiving an error when Multiple Job Sequence have same EFFDT

1. Make sure an employee’s JOB record has multiple sequence numbers, both records have the same effective date.
2. Make sure employee have some Prepaid Transactions in His My Wallet.

1. Log in as any user and open the Expense Work center

Actual Result
When opening Expense Workcenter below error appears:

Fatal SQL error occured. (2,125) FS_EX_WORKCENTER_DASHBOARD.Personal.MyWorkLinks.MyWorkLink.OnExecute
Name:GetRowCount PCPC:2343 Statement:46
Called from FS_WORKCENTER_DASHBOARD.MyWork.Pagelet.PageletController.OnExecute Name:GetRowCountLabel
Called from:FS_WORKCENTER_DASHBOARD.MyWork.Pagelet.PageletController.OnExecute Name:InitMyWorkLink
Called from:FSPC_MYWORK_PGLT.GBL.PostBuild Statement:98

A SQL error has occured, review the SQL to determine the cause of the error.

Review the program for error. If necessary, run a PeopleCode trace to determine the program that failed.

Expected Results
When opening Expense Workcenter no error should appear.


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