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

Received Response
1
Views
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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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