Retail Merchandising System (MOSC)

MOSC Banner

Is there a purge job for the concession_data table?

edited Jul 5, 2014 5:00AM in Retail Merchandising System (MOSC) 2 commentsAnswered

While trying to delete an entry from the item_master, I found that the job failed due to a foreign key link to the concession_data table.

I've checked everywhere I can think of to look for a purge job that clears out the concession_data table, but cannot find one.

I was wondering if anyone knew if Oracle Retail has a purge job that specifically purges the concession_data table, or if there is a patch for dlyprg (for either VALIDATE_RECORDS_SQL.DEL_ITEM or DELETE_ITEM_RECORDS_SQL.DEL_ITEM) that will either log an entry in the daily_purge_error_log table or purge the concession_data table (I'm leaning more towards the logging an entry in the daily_purge_error_log table) when an item is being purged that has an entry in the concession_data table; alternatively I will need to either raise an SR, find a patch for dlyprg, or roll up in a little ball and cry myself to sleep at

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center