sucampbell Posted July 19, 2018 Posted July 19, 2018 I have an Ad Hoc View using a domain with multiple tables, including a derived table. The derived table has a sum field, Reserve Amount. In the Ad hoc view, i have a filter on the Reserved Amount where the value is greater than or equal to 3000000. The Ad hoc View works fine, however, when I try to export the data, i get a server Error exception getting data Strategy and a java.sql.SQLException: ORA-01438: value larger than specified precision allowed for this column. The values in the table are much higher than this 3M filter. And if i lower the filter to 30000, it will export fine.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now