My Oracle Support Banner

EAR9.2.When Going To Collections Workbench And Choose Different Actions From Action List, The Following SQL Error Appears:"Unexpected data type code: None. (180,605) "PAYMENTS_DISPLAY.CustPayments.OnExecute Name:ComputeCompleted PCPC:33647 Statement:51" (Doc ID 3010466.1)

Last updated on APRIL 18, 2024

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms



When going to Collection Workbench and then go to Action list and choose several actions : Review Customer Credit list , Dunning Letter Action, Refer to Collection Agency Action, Send Statement of Account- and clicking on Details button,

the following error is received :
 

ERROR
-----------------------

SQL Error ocured.Please consult your system log for details.

Unexpected data type code: None. (180,605) PAYMENTS_DISPLAY.CustPayments.OnExecute Name:ComputeCompleted PCPC:33647 Statement:514

Called from:PAYMENTS_DISPLAY.CustPayments.OnExecute Name:SelectCompleted Statement:456

Called from:PAYMENTS_DISPLAY.CustPayments.OnExecute Name:Select Statement:78

Called from:AR_CWB_WRK.FUNCLIB_02.FieldFormula Name:CustomerPayments Statement:140

Called from:AR_CWB_WRK.FUNCLIB_02.FieldFormula Name:DoTab Statement:369

Called from:COLLECTION_WRKBNCH.GBL.AR_CWB_WRK.HIDDEN_FLAG.FieldChange Statement:3

The evaluator encountered an unexpected data type code





The issue can be reproduced at will with the following steps:

  1. Go to AR>Collection workbench and populate SETID, leave BU and Customer blank. Click Search. Action list is retrieved for user VP1.
  2. Click on Details button beside action for customer 1000- Review Customer Credit list. Customer information is populated into Customer WorkBench header and tabs.
  3. By default, the Items tab is opened. Click on Payments tab.
  4. The mentioned above error appears.
  5. The issue is present when clicking on Dunning Letter Action – details button, Refer to Collection Agency Action- details button, Send Statement of Account- details.

 More details can be found in the Replication document attached.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.