EAR9.2: PeopleCode Error When User Clicks on Collections Workbench Tab - Conversation Page (Doc ID 2153460.1)

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.

Symptoms

When attempting to Main Menu/ Accounts Receivable/ Collections Workbench,
the following error occurs:

ERROR
-----------------------
"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:

  1. Navigate to Main Menu/ Accounts Receivable/ Collections Workbench;
  2. Select a Customer that has a Conversation added/saved already;
  3. Click on the Conversations tab;
  4. Fatal error is received: "A fatal PeopleCode SQL error occured. Please consult your system log for details".



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