My Oracle Support Banner

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.

Goal

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.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.