Injector Batch Logging Invalid Time Stamp Error When TIMEBASED_DTL_IND=1 and TimeStamp Is Specified

(Doc ID 2050988.1)

Last updated on FEBRUARY 28, 2018

Applies to:

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

Symptoms is not properly validating timestamps for simple promotions integrated from external systems when TIMEBASED_DTL_IND=1 in RPM_STAGE_SIMPLE_PROMO staging table.
The errors "INVALID_TIME_STAMP_ON_PROMO_END_DATE" and "INVALID_TIME_STAMP_ON_PROMO_START_DATE" are logged in the staging table when start date and end date are not entered as 00:00:00 and 23:59:00 respectively.

It was found that the code is always expecting time format as 00:00:00 for start date and 23:59:00 for end date, no matter the value of TIMEBASED_DTL_IND.
Below is the code which is found in RPM 14.1.1:

Steps to Reproduce:

  1. Set up the data in RPM_STAGE_SIMPLE_PROMO with TIMEBASED_DTL_IND=1
  2. Provide the PROMO_START_DATE = VDATE+1 followed by time as 02:30:50
  3. Provide the PROMO_END_DATE = VDATE+1 followed by time as 05:40:50
  4. Provide the DTL_START_DATE = VDATE+1 followed by time as 02:30:50
  5. Provide the DTL_END_DATE = VDATE+1 followed by time as 05:40:50
  6. Log in to RPM Unix box and run the batch " event_type=SP status=N"
  7. Batch will fail with error


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