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.

Symptoms

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

Steps
Setup:
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.

Steps:
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
Statement:46
Called from:FS_WORKCENTER_DASHBOARD.MyWork.Pagelet.PageletController.OnExecute Name:InitMyWorkLink
Statement:86
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.

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