EAR9.2: PeopleCode Error When User Clicks on Collections Workbench Tab - Conversation Page
Last updated on JUNE 27, 2016
Applies to:PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
When attempting to Main Menu/ Accounts Receivable/ Collections Workbench,
the following error occurs:
"A fatal PeopleCode SQL error occured. Please consult your system log for details" with the message:
"SQL error in EXEC. (2,280) CWB_CONVR_PROMISES.Conversations.OnExecute Name:FetchLimitedConvr PCPC:40023 Statement:608
Called from:CWB_CONVR_PROMISES.Conversations.OnExecute Name:SelectConversation Statement:253
Called from:AR_CWB_WRK.FUNCLIB_02.FieldFormula Name:CustomerConversations Statement:229
Called from: AR_CWB_WRK.FUNCLIB_02.FieldFormula Name:DoTab Statement:382
Called from: COLLECTION_WRKBNCH.GBL.AR_CWB_WRK.HIDDEN_FLAG.FieldChange Statement 3
During the execution of SQL, an error occured in the Exec subroutine. The preceding message should have described the SQL being executed.
Steps To Replicate
The issue can be reproduced at will with the following steps:
- Navigate to Main Menu/ Accounts Receivable/ Collections Workbench;
- Select a Customer that has a Conversation added/saved already;
- Click on the Conversations tab;
- Fatal error is received: "A fatal PeopleCode SQL error occured. Please consult your system log for details".
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