My Oracle Support Banner

"ORA-01839: Date Not Valid for Month Specified" Error While Executing the Batch Repladj in a Leap Year (Doc ID 1504474.1)

Last updated on AUGUST 25, 2022

Applies to:

Oracle Retail Merchandising System - Version 13.0 to 13.0.6 [Release 13.0]
Information in this document applies to any platform.


When attempting to execute the batch job repladj on 29-FEB-2012 (last day of the month of February for a Leap Year), the batch fails with the following error:

Steps to Reproduce:

  1. Pre-requisites: Ensure SYSTEM_OPTIONS.CALENDAR_454_IND='C'
  2. Ensure PERIOD.VDATE=29-FEB-2012
  3. Create an Item.
  4. Add replenishment parameters such that Replenishment method is Floating Point.
  5. Approve the Item.
  6. Execute the batch rilmaint.
  7. Execute the batch repladj.
  8. Notice that the batch repladj fails with ORA-01839 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.