My Oracle Support Banner

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.

Symptoms

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').

REPLICATION STEPS:

    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.

ERROR MESSAGE:

    " 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.

NOTE: In the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance). Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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.