Improved Lookup Table Processing for Large Hierarchies

Lookup Table processing supports rules containing multiple large hierarchies without expanding all hierarchy and lookup combinations. Source data is processed in controlled slices; leaf members are resolved to their ancestors and then matched with the Lookup Table to determine and update the return value only for nodes provided as lookup data.

Avoids excessive intermediate data expansion that can cause long-running or stalled processes. The sliced approach improves scalability and processing stability for customers with large, complex hierarchies.

Steps to enable and configure

You don't need to do anything to enable this feature.

Key resources

https://docs.oracle.com/en/industries/financial-services/ofs-analytical-applications/profitability-balance-sheet-base/index.html