EAR9.2: SQL Error Pops Up If Search Filter On Conversation Tab Of Collection Workbench (Doc ID 2306393.1)

Last updated on SEPTEMBER 12, 2017

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Issue:
================
SQL Error occurred on the Filter Conversation of Collection Workbench.

Error:
================
A SQL error occurred. Please consult your system log for details.
Error in PeopleCode ScrollSelect processing. (2,213)
CWB_CONVR_PROMISES.Conversations.OnExecute Name:FetchLimitedConvr PCPC:39887 Statement:606
Called from:CWB_CONVR_PROMISES.Conversations.OnExecute Name:FilterSelect Statement:432
Called from:COLLECTION_WRKBNCH.GBL.CWB_CONVR_WRK.FILTER_PB.FieldChange Statement:10

Step:
================
1. Navigate to Main Menu > Accounts Receivable > Collections Workbench
2. Select Unit, Customer and Level
3. Select "Tie to a New Conversation" and select one item
4. Enter Conversation and click Add Conversation Entry
5. Verify Conversation Entry added
6. Click Filter Conversation link
7. Enter criteria and click Search button
8. SQL error occurred

Actual Behavior:
================
SQL Error occurred on the Filter Conversation of Collection Workbench.

Expected Behavior:
================
SQL Error should not occur on the Filter Conversation of Collection Workbench.

Business Impacts:
================
Due to this issue, users cannot search Conversation through Collection Workbench.

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