AIP: cron_import_order.sh is Failing with ORA-01438 Error During Quantity Conversion
(Doc ID 2663208.1)
Last updated on DECEMBER 01, 2021
Applies to:Oracle Retail Advanced Inventory Planning - Version 15.0.2 and later
Information in this document applies to any platform.
As part of the AIP batch cron_import_order.sh (load), data from vendor_to_wh_order.dat (via scripts/import/ord_imp_non_cont_ord_fcst_in.sh) is loaded into WAREHOUSE_PURCHASE_ORDER table through a staging table named I_NON_CONTENTS_ORDER_FORECAST. The data is copied from WAREHOUSE_PURCHASE_ORDER to NON_CONTENTS_ORDER table during merge (that runs before release) process. The initial load process is performed through RETL_LOAD package - import_wh_purchase_order procedure.
This process is failing when the input quantity is greater than 8 decimal length (after division by pack_size), with below error:
In this case, the pack size was kept as '1' and quantity is greater than 8 digits.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!