My Oracle Support Banner

Performance Of Ledger Reports Is Negatively Impacted By Pin_round_beid Function (Doc ID 2174226.1)

Last updated on JUNE 12, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.14.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

On : 7.5.0.14.0 version, General Ledger (GL)

ACTUAL BEHAVIOR
---------------
There is a significant issue with the function PIN_ROUND_BEID which results in poor GL Summary performance and impacts finance and database developers writing financial reports with this function.  Using a SELECT in a user-defined function creates additional context switching (burns CPU) and removes the ability to scale with parallelism.

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!


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