Retail Merchandising System (MOSC)

MOSC Banner

How does the DAILY_DATA_TEMP table populated?

edited Apr 27, 2015 1:16PM in Retail Merchandising System (MOSC) Question

Hello All,

I would like to know, how does the DAILY_DATA_TEMP table got populated? From the OG I can see that the records are inserted by the SALDLY.PC program.

But whenever i run the SALDLY.PC it does not insert records into DAILY_DATA_TEMP table, due to this transaction details from DAILY_DATA table not rolled up by the SALWEEK job.

From the ProC code i can see there is a string comparison between two dates which is eow_date and last_end_eow_date. Please refer the below code.

Currently my vdate is 01-MAR-15 and last_eow_date as per SYSTEM_VARIABLES table is - 28-FEB-15.

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