EEX9.2:Expense Workcenter Is Receiving An Error When Multiple Job Sequence Have Same EFFDT
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
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.
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