Oracle Analytics Cloud export limits do not error out or warn users

Guillaume Lecouteux.

Organization Name

Greenergy International

Description

OAC has internal limits as documented in https://docs.oracle.com/en/cloud/paas/analytics-cloud/acsom/create-services-oracle-analytics-cloud.html#GUID-164D8568-9AE3-4A74-9F1A-0D87B78713C9 Under section - Limits When Querying or Exporting Data

When reaching export limits, OAC does not generate an error but instead truncate the output to the limits set by the system.

This leads to generate inadvertently inaccurate datasets and eventually fail compliance, audit, internal and external business controls requirements based on comprehensive and accurate data extracts.

Reaching the limit should be considered an error by OAC, notified to users and ultimately not generate an output at all since truncated.

 

 

 

Use Case and Business Need

As part of our compliance we have business controls based on financial data exports from our financial systems via OAC. These controls must be proven to be accurate and comprehensive to auditors.
Without any error message on query limits, users can potentially export inaccurate data sets and fail these controls inadvertently.

Original Idea Number: d8d072bd84