EAR9.2: SQL Error When Clicking On Receivables WorkCenter Menu Item
Last updated on NOVEMBER 28, 2016
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
On : 9.2 version Image 13, Receivables WorkCenter
When attempting to click on Receivables WorkCenter the following error occurs.
SQL error in Exec. (2,280) FS_AR_WORKCENTER_DASHBOARD.MyWorks.MyInterfaces.MyWorkLink.OnExecute Name:GetRowCount PCPC:2463 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
The issue can be reproduced with the following steps:
- Navigate to: Main Menu > Accounts Receivable > Receivables WorkCenter
- Click on the Receivables WorkCenter menu item, the above error is displayed.
- Click on OK button this error message, the WorkCenter is displayed, but ‘My Work’ section cannot be used.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms