How to Manually Update Stock Ledger Tables For All Existing Location Department Combinations (Doc ID 871035.1)

Last updated on JULY 17, 2017

Applies to:

Oracle Retail Merchandising System - Version 12.0 to 13.2 [Release 12.0 to 13.2]
Information in this document applies to any platform.
Scope : This document explains the procedure to be followed to ensure the stock ledger tables WEEK_DATA, MONTH_DATA, HALF_DATA, MONTH_DATA_BUDGET, and HALF_DATA_BUDGET are updated with records for all existing department-location combination's. Under normal conditions this data will be populated during the scheduled batch run of salinas based on the updates in the STOCK_LEDGER_INSERTS table.


Goal

What is the procedure to be followed to update the stock ledger tables WEEK_DATA, MONTH_DATA, HALF_DATA, MONTH_DATA_BUDGET, and HALF_DATA_BUDGET with records for all existing department-location combination ?

Solution

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