Retail Merchandising System (MOSC)

MOSC Banner

Loading Sales Transaction to RDW

edited Jun 9, 2015 10:00AM in Retail Merchandising System (MOSC) 5 commentsAnswered

Hi Everyone,

I have some doubts about how the load process of RDW for SAles transactions (SLSILDMDM.KSH) rejected transaction from de input file (slsildmdm.txt.)

I have a test case where:

1) We're evaluating the business_Date "14/04/2015" for the store "02" since 26/05/2015.

2) There're  4519 transactions in SA_TRAN_HEAD table, excluding TOTAL and DCLOSE tran_type for this store/day.

3) All the Transactions (4519) are inserted into SA_EXPORTED table with system_code = 'RDW' and status "E"

4) The RDWT file contain all the transactions exported, in its corresponding export datetime.

5) The slsildmdm.txt file contain all the transactions.

6) The slsildmdm.ksh completed successfully.

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