InjectorPriceEventBatch with Clearance Event Type Gets Stuck (Doc ID 2128333.1)

Last updated on APRIL 20, 2016

Applies to:

Oracle Retail Price Management - Version 13.2.4 and later
Information in this document applies to any platform.

Symptoms

Find that the InjectorPriceEventBatch with Clearance Event Type gets stuck - it just hangs there.

Steps:

1. Kick off the injectorPriceEventBatch process to inject Clearance Prices, and see that it gets stuck in the started status.
2. Check the err.run_injectorPriceEventBatch.log, and find the following INFO:

The error should be more useful.

In RPM_STAGE_CLEARANCE, found the ZONE_ID (from RPM_ZONE_LOCATION) in the staged record did not exist. Thus, the batch process just hung.
The incorrect data can be corrected, but there is an issue with the error handling, as the system is not raising any error message indicating that the ZONE_ID does not exist.

Cause

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 hundreds of Community platforms