My Oracle Support Banner Batch Aborts with "ORA-01400: CANNOT INSERT NULL" Error (Doc ID 2347857.1)

Last updated on FEBRUARY 15, 2019

Applies to:

Oracle Retail Store Inventory Management - Version 13.2.0 and later
Information in this document applies to any platform.


In Store Inventory Management (SIM) application, find that, the batch aborts with the following error, when trying to start a regular price change:

Steps to Recreate:

1. Enable Retail Integration Bus (RIB) processing between SIM and Retail Price Management (RPM)
2. Create a new item in Retail Merchandising System (RMS) and ensure that the item is found in both SIM and RPM
3. In RPM, create a regular price change for the item and find that a record is inserted into SIM database table RK_PRICE_CHANGE with status '1' (New)
4. Now run the batch and find that the batch aborts with the error.




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

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