My Oracle Support Banner

EEBI: Account Summary Page (EB_ACTG_SUMRY_FL) In Fluid User Interface Time Out After A Performance Degradation Due To Scanning All Existing Payment Attachments (Doc ID 2619790.1)

Last updated on DECEMBER 13, 2019

Applies to:

PeopleSoft Enterprise SCM eBill Payment - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms


A performance degradation has been observed when a User tries to open/load the Account Summary Tile from the eBill Payment Fluid Homepage through the Customer Portal. Even though the User logged into the system is linked to a Customer with a low volume of Invoice transactions, whenever trying to open the Account Summary page, the system times out, and the User is kicked out of the session altogether.

    - Page EB_ACTG_SUMRY_FL (Account Summary)
    - Component EB_ACCTG_SUMMRY_FL
    - Menu EBILL_PAYMENT

From further analysis, a similar problem was already resolved through the fix from <Bug 27424441> (EBILL PAYMENT FLUID TILES NOT LOADING PAGES AFTER APPLYING <BUG 25459037> ON PUM23), which was delivered within FSCM 9.2 Image #28. However, the problem looks as if it has returned, as the codeline is executing in the background a sweep on the Payment Attachments Record (Table PS_PAYMENT_WS_ATT), which contains over 110,000 rows at this moment.

REPLICATION STEPS:

    1.- Log into the FSCM Online Application Customer Portal as an eBill Payment Customer Contact
    2.- Load the eBill Payment Homepage under Fluid User interface
    3.- Click on the Account Summary Tile
    4.- The system gets stuck spinning the wheel trying to load the transaction data, but never gets around to do it, eventually timing out the session


The eBill Payment Customer Contacts are unable to review their Customer's Account Summary information: Balance, Recent Invoices, Recent Payments, Credit Information, Aging Information, and alike. As such, Contacts are unable to perform their tasks on paying outstanding Invoices without a proper understanding of the Customer's current balance.

The Account Summary page should be displayed in a timely manner, taking into consideration the volume of transaction data referent to that one single Customer, and not checking the Payment Attachments of all other Customers.

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.