Task SIL_RetailSeasonDimensionLoad (seasnsil.ksh) Fails
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.
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.
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.
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