HSTBLD Batch Aborts With Error 'ORA-01438: Value larger than specified precision allowed for this column'
(Doc ID 2167331.1)
Last updated on FEBRUARY 21, 2019
Applies to:Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.
When attempting to run the hstbld batch with 'rebuild' as parameter, the following error occurs:
"hstbld_1~<TIMESTAMP>~process_class~class_sales_hist~-1438~ORA-01438: value larger than specified precision allowed for this column~INSERT: dept = <DEPT>, class = <CLASS>, store = <STORE>"
Steps to Recreate:
1. Run batch hstbld with parameter as 'rebuild'.
2. Note that the batch aborts with error "ORA-01438".
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document