You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need Guidance on BI Report Performance Discrepancy (AR Invoices) - 25D Patch

in Reporting and Analytics for SCM

Hi everyone,

We’re running into a puzzling issue with a BI report based on AR Invoices and hoping for some advice or shared experience.

Scenario:

  • Our report joins ra_customer_trx_all and pjb_invoice_headers using pih.SYSTEM_REFERENCE = rcta.customer_trx_id.
  • This join works fine (good performance) in all our 25C Oracle Cloud instances.

Issue:

  • When we test the same report in our 25D patch instance, the join suddenly causes major performance issues.
  • Per an explain plan, the join is the bottleneck.

Workaround Tried:

  • We switched to a join between ra_customer_trx_lines_all and
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!