Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Report Error: ORA-01438: value larger than specified precision allowed for this column

in Reporting and Analytics for ERP 3 comments

Summary:

Hey,

I am running a custom report in BI Enterprise and keep getting the error below. The report is failing for only a few circumstances and am able to run it for 90% of my prompt scenarios. BI publisher only allows 200 rows of output, so am having trouble putting my finger on the issue. Everything I read is related to INSERT/UPDATE statements and I am only running a SELECT.

Is anyone familiar with the below Oracle SQL error?

ORA-01438: value larger than specified precision allowed for this column


Content (required):

Hey,

I am running a custom report in BI Enterprise and keep getting the error below. The report is failing for only a few circumstances and am able to run it for 90% of my prompt scenarios. BI publisher only allows 200 rows of output, so am having trouble putting my finger on the issue. Everything I read is related to INSERT/UPDATE statements and I am only running a SELECT.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!