EEBI: Account Balance, and eBill Payment Landing Pages Issue Error Message (2,116) if Contact Customer Has Only Prenote Row in PS_DD_CONTROL Table
(Doc ID 2622623.1)
Last updated on MAY 05, 2021
Applies to:PeopleSoft Enterprise SCM eBill Payment - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.
The system is triggering an Error Message when accessing the eBill Payment Account Balance page, or the eBill Payment Landing page, should this last one contain the Account Summary pagelet.
This is taking place if the Contact Customer being inquired has just one single row in Record PS_DD_CONTROL, and this one belongs to a Prenote Transaction (PS_DD_CONTROL.PRENOTE_FLAG = 'Y').
1.- Create a new Customer
2.- Create new MICR for this customer
3.- Update the Customer to Direct Debit Payment method
4.- Select the PreNote Required check on the "Bill To Options" page, confirm after 3 days
5.- Add this Customer to existing Customer Contact/eBill user
6.- Login to eBill Payment Portal and select this Customer. No Error Message on the landing page
7.- Create Direct Debits for this Customer (AR_DIRDEBIT). Process creates a Prenote transaction
8.- Remit the Prenote transaction, and ensure the status of the Direct Debit is C (Completed).
9.- Login to eBill Payment Customer Portal using the Customer Contact (same as step# 6)
10.- Set up Preferences, Profile, and Customer settings
11.- Go to the eBill Payment Landing page, and confirm the Error Message
12.- Go to the eBill Payment Account Balance page, and confirm also the same Error Message takes place
To gather more information concerning this scenario and its related problem, refer to the available Replication Steps PDF Document here linked containing the complete configuration and the replication steps necessary to reproduce the issue.
" Invalid parameter 2 for function ConvertCurrency. (2,116) AR_ACCBAL_WRK.AR_SS_BAL_TITLE.RowInit Name:GetRecentActivity PCPC:17655 Statement:185
Called from:AR_ACCBAL_WRK.AR_SS_BAL_TITLE.RowInit Name:GetAccountBalance Statement:262
Called from:AR_ACCBAL_WRK.AR_SS_BAL_TITLE.RowInit Name:InitAccSummaryPagelet Statement:328
Called from:AR_SSCUST_AL_VW.CUST_ID.FieldFormula Name:SetupCustomer Statement:106
Called from:AR_SSCUST_SEL.Activate Statement:1
The specified parameter is not correct for the function. It may be the wrong type of parameter (string, number, record.field, etc) or an invalid value in this context.
Review the program for errors. If necessary, run a PeopleCode trace to determine the program that failed. Alternatively, for functions defined within PeopleCode, check the function declaration to verify that they are correct. "
Contact Users are unable to properly review their Customer's eBill Payment Account Balance information, nor get displayed all details on the eBill Payment Landing page. This renders useless a big part of the module's functionality, and prevents Users from taking proper actions if not all information is available to them.
The Account Balance, and eBill Payment Landing pages should be displayed without any Error Message.
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