My Oracle Support Banner

Generate Balance Forward Billing Performance Issue (Doc ID 2076625.1)

Last updated on NOVEMBER 01, 2024

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.
ARBFB_GEN: Generate Balance Forward Bills

Symptoms

Performance issue when running Generate Balance Forward Bills


It takes more than a day when run for all customers.
It finishes fast when run for a single customer.

Following sql was giving performance issue (as seen from trace/ AWR)
 

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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?
References


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