Task SIL_RetailSeasonDimensionLoad (seasnsil.ksh) Fails

(Doc ID 2355313.1)

Last updated on FEBRUARY 06, 2018

Applies to:

Oracle Retail Merchandising Insights - Version 15.0.1 and later
Information in this document applies to any platform.

Symptoms

Seasnsil.ksh job failed when prolonging an expired season

An expired season, which was integrated to RI, will be flagged as CURRENT_FLG='N'. When extending the End Date of that season to a date in the future, RI daily batch jobs will again integrate that season, with CURRENT_FLG='Y', into RI. This cause the error happens while inserting into table W_RTL_SEASON_D.

ERROR



Steps To Recreate:

1. Find a season in RI with CURRENT_FLG='N' (ex: season 303)
2. In RMS, open that season and edit its End Date to a future date (greater than VDATE)
3. Run required daily batch jobs to integrate that season to RI.
4. Note that when running at seasnsil.ksh, the "unique constraint violated" error will display.

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