sucampbell Posted July 19, 2018 Share 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. Link to comment Share on other sites More sharing options...
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