In the current FDI product, we have implemented a conditional drill feature in our reports. However, we are encountering the following issue:
- When executing a report with conditional drill enabled, we receive the error message: “Exceeded configured maximum number of allowed input records” whenever the query processes more than 500,000 records.
- It is important to note that the same report runs successfully and returns expected results when the conditional drill feature is removed, even when processing large data volumes.
We request Oracle to review and update the code or configuration in the FDI product, so that reports using conditional drill can process and display results for record sets larger than 500,000—similar to standard reports without conditional drill. This enhancement will be helpful for ensuring consistent report functionality.
