OTBI: Getting Error: exceeded configured maximum number of allowed output rows

Ashu Raj-Oracle

Summary:

Have created an OTBI analysis on "Sourcing: Supplier Awards real time". It has a couple of graphs and tables. But when running for a Negotiation with around 2500 rows, this gives the error: "exceeded configured maximum number of allowed output rows". It runs fine if we select less number of rows.

Can you please advise if there is any setting where we can configure the maximum allowed rows? Or is there any Oracle's benchmark regarding this?

We will need to inform our client of this issue accordingly.

Thank you!

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Joel Acha11111

Which version of OBIEE are you using?

Ashu Raj-Oracle

We are not using OBIEE license.. we are on Oracle Cloud 22A and created an OTBI report.

Raghavan p-Oracle

Fusion Apps, OTBI, Error Message: Exceeded Configured Maximum Number Of Allowed Output Prompts, Sections, Rows, Or Columns (Doc ID 2004256.1)

Fusion OTBI: Error: Exceeded configured maximum number of allowed output prompts, sections, rows, or columns - Error Codes: IRVLJWTA (Doc ID 2113475.1)

Gaurav Bharadwaj-Oracle

You are hitting system limits, since you are a SAAS customer, you may need to review the documents posted by Raghavan above.

Thanks

Rajasekhar Bandaru-Oracle

For extraction of huge volume of data use BICC as an alternate solution. Review the below documentation link

https://docs.oracle.com/en/cloud/saas/applications-common/20d/biacc/

Gaurav Bharadwaj-Oracle

Please use BICC as an alternate tool to extract large amounts of data you may use the latest documentation available here for the same : https://docs.oracle.com/en/cloud/saas/applications-common/22c/biacc/index.html

This applies to Fusion Release 22C.