My Oracle Support Banner

'REGULARPRICECHANGE' Batch Aborts With 'ORA-01438' and Fails to Load Pricechange File (Doc ID 2740564.1)

Last updated on FEBRUARY 01, 2021

Applies to:

Oracle Retail Store Inventory Management - Version 16.0.2 and later
Oracle Retail Enterprise Inventory Cloud Service - Version 19.0 and later
Information in this document applies to any platform.

Symptoms

The 'RegularPriceChange.sh' batch fails to process and the following error occurs in the sim batch log.

ERROR:
-------

2020-07-27 17:00:16,127 ERROR [[ACTIVE] ExecuteThread: '37' for queue: 'weblogic.kernel.Default (self-tuning)'][o.r.s.s.d.d.PriceChangeOracleDao] Error executing batch statement: insert into PRICE_CHANGE_WORKSHEET (ID, STORE_ID, ITEM_ID, EFFECTIVE_DATE, END_DATE, PRICE_TYPE, ACTION_TYPE, STORE_REQUESTED, SELLING_RETAIL_CURRENCY, SELLING_RETAIL, SELLING_RETAIL_UOM, PROMO_RETAIL, PROMO_RETAIL_CURRENCY, PROMO_RETAIL_UOM, PROMOTION_NAME, CLEARANCE_RETAIL, CLEARANCE_RETAIL_CURRENCY, CLEARANCE_RETAIL_UOM, MULTI_UNITS, MULTI_UNIT_RETAIL_CURRENCY, MULTI_UNIT_RETAIL, MULTI_UNIT_RETAIL_UOM, MULTI_UNIT_CHANGE, SELLING_UNIT_CHANGE, REGULAR_PRICE_CHANGE_ID, CLEARANCE_ID, CLEARANCE_RESET_ID, PROMO_ID, PROMO_COMP_ID, PROMO_COMP_DTL_ID, PROMO_COMP_TYPE, BATCH_IMP_ID, EXTRACT_ID, STATUS, UPDATE_DATE, PROMO_DURATION_TYPE, EXTRACT_INFO, PROMOTION_DESCRIPTION, PROMO_COMP_CUST_TYPE) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
java.sql.BatchUpdateException: ORA-01438: value larger than specified precision allowed for this column

Steps to Recreate:

1. Create Pricechange file from Retail Price Management (RPM).
2. Run the RegularPriceChange.sh batch.
3. Note the above error.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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