My Oracle Support Banner

OPA 12 What-If Analysis Query (Doc ID 2480803.1)

Last updated on OCTOBER 25, 2019

Applies to:

Oracle Policy Automation - Version 12.2.8 and later
Information in this document applies to any platform.


The customer was facing a challenge executing What-If Analysis in OPA 12 because of Excel row limits. They need to conduct an analysis of ~80,000 real cases from Siebel, and some of the associated entities of the case have>1 million records. The row limits in Excel are preventing us from pulling and analyzing all the attributes we need. Is there any way to execute What If Analysis using entities that have attributes that require > 1 million rows? Are there any statistics on the system memory requirements to run What If Analysis on large data sets, we are experiencing timeout issues while executing what-if sheet having > 5000 cases.


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

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