Retail Merchandising System (MOSC)

MOSC Banner

Quantities and amounts load double in RDW

After execution of the SLSILDMDM job, the quantities and amounts are loaded into the table "sls_item_lm_dm" with twice the value written in the file slsildmdm.txt. Transactions are fine in the archive. No changes have been made to the production environment.

In some cases the transactions don't even load either.

I have reviewed the bug id "8603617 SALES QUANTITY GETTING DOUBLED IN TABLES OF RDW", however, it is designed for version 12 and is already applied in dim_lkup.ksh

The version of ORDW is 13.1.4

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