My Oracle Support Banner

Injector Fails with Invalid Number error When Processing New Clearance Reset Records. (Doc ID 2655530.1)

Last updated on DECEMBER 01, 2021

Applies to:

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

Symptoms

When attempting to create new clearance records through injector batch it fails with the following error.


Steps To Reproduce: 

  1. .Create and approve a SKU/ZONE level clearance with NULL reset_date.
  2. Insert into RPM_STAGE_CLEARANCE_RESET a record for that clearance with status 'N'. 
  3. Run injector for NR
  4. Observed that the records updated with status = 'F' and failed with error in database.

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.