BILL_NOW For Hierarchy Account Structure Is Slow (Doc ID 1367299.1)

Last updated on APRIL 03, 2023

Applies to:

Purpose

In the BILL_NOW calculation, due to the way it is organized, the tax calculation is done on all members of a hierarchy instead of being done once on the account level. The standard procedure takes into account all possible variants of the tax procedures of the different members. When there are many accounts to bill with bigger hierarchies (for instance greater than 200 on average) this can take a long time.
The goal of this document is to show a way to accelerate this calculation.

Details

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