| Course Overview |
11 |
| Course Objectives |
1 |
| Module 1: Course components |
3 |
| Lesson 1: Oracle Retail (Retek) Merchandising System overview |
4 |
| Lesson objectives |
4 |
| Oracle Retail (Retek) Merchandising System components |
5 |
| RMS Integration |
6 |
| RMS Architecture |
7 |
| Online and batch overview |
8 |
| RMS start form (screen) |
9 |
| Lesson 2: Oracle Retail (Retek) directory structure |
10 |
| Lesson objectives |
10 |
| RMS directory structure |
11 |
| Module 2: Batch processing |
13 |
| Lesson 1: Batch overview |
14 |
| Batch processing |
15 |
| Process large volume of data |
15 |
| Interface with external systems |
15 |
| Perform internal maintenance |
15 |
| Lesson 2: Batch schedule |
16 |
| Lesson objectives |
16 |
| The batch cycle and the batch window |
17 |
| Batch schedule and phases |
17 |
| Lesson 3: System administration and control files |
26 |
| Lesson objectives |
26 |
| Restart/Recovery |
27 |
| Restart/Recovery tables |
29 |
| Multi-threading |
29 |
| Daily record deletion [dylprg] |
30 |
| Prepost for multi-threadable programs [prepost] |
31 |
| System date setting [dtesys] |
31 |
| Module 3: Organizational hierarchy |
33 |
| Lesson 1: Organizational hierarchy overview |
34 |
| Lesson objectives |
34 |
| Organization hierarchy |
35 |
| Lesson 2: Organizational hierarchy data model |
37 |
| Lesson objectives |
37 |
| Data model |
38 |
| Key table description |
44 |
| Other tables |
45 |
| Lesson 3: Organizational hierarchy online process |
46 |
| Lesson objectives |
46 |
| Online forms |
47 |
| Online data flow |
48 |
| Lesson 4: Organizational hierarchy batch process |
49 |
| Lesson objectives |
49 |
| Batch programs |
50 |
| Batch process and integration data flow |
51 |
| Module 4: Merchanise hierarchy |
53 |
| Lesson 1: merchandise hierarchy overview |
54 |
| Lesson objectives |
54 |
| Merchandise hierarchy |
55 |
| Lesson 2: Merchandise hierarchy data model |
58 |
| Lesson objectives |
58 |
| Data model |
59 |
| Key table description |
61 |
| Other tables |
62 |
| Lesson 3: Merchandise hierarchy online process |
63 |
| Lesson objectives |
63 |
| Online forms |
64 |
| Online data flow |
65 |
| Lesson 4: Merchandise hierarchy batch process |
66 |
| Lesson objectives |
66 |
| Lesson objectives |
66 |
| Batch programs |
67 |
| Batch process and integration data flow |
68 |
| Module 5: Supplier |
69 |
| Lesson 1: Supplier overview |
70 |
| Lesson objectives |
70 |
| Supplier |
71 |
| Vendor managed inventory (VMI) |
71 |
| Pre-assigned (Pre-issued) order process |
71 |
| Supplier set up and interfaces flow |
72 |
| Lesson 2: Supplier data model |
73 |
| Lesson objectives |
73 |
| Data model |
74 |
| Key table descriptions |
79 |
| Other tables |
80 |
| Lesson 3: Supplier online process |
81 |
| Lesson objectives |
81 |
| Online forms |
82 |
| Online data flow |
83 |
| Lesson 4: Supplier batch process |
84 |
| Lesson objectives |
84 |
| Batch programs |
85 |
| Batch and integration data flow |
86 |
| Module 6: Item maintenance |
871 |
| Lesson 1: Item maintenance overview |
88 |
| Lesson objectives |
88 |
| Items |
89 |
| RMS items characteristics |
89 |
| Item number types |
89 |
| Transaction level |
90 |
| Item approval |
91 |
| Merchandise and item hierarchy |
92 |
| Lesson 2: Item maintenance data model |
94 |
| Lesson objectives |
94 |
| Data model |
95 |
| Key table description |
101 |
| Other tables |
103 |
| Lesson 3: Item maintenance online process |
104 |
| Lesson objectives |
104 |
| Online forms |
105 |
| Online data flow |
107 |
| Lesson 4: Item maintenance batch process |
109 |
| Lesson objectives |
109 |
| Batch programs |
110 |
| Batch process and integration data flow |
112 |
| Module 7: Pack-item maintenance |
115 |
Lesson 1: Pack-item maintenance overview
Lesson objectives
Pack items
Types of packs
Key points of RMS packs
Pack inventory
|
116
116
117
117
117
118
|
Lesson 2: Pack-item maintenance data model
Lesson objectives
Data model
Key table descriptions
Other tables
|
119
119
120
121
121
|
Lesson 3: Pack-item maintenance online process
Lesson objectives
Online forms
Online data flow
|
122
122
123
125
|
|
Lesson 4: Pack-item maintenance batch process
|
126
|
| Module 8: Cost maintenance |
127 |
Lesson 1: Cost maintenance overview
Lesson objectives
Cost change within RMS
|
128
128
129
|
Lesson 2: Cost maintenance data model
Lesson objectives
Data model
Key table description
Other tables
|
130
130
131
133
133
|
Lesson 3: Cost maintenance online process
Lesson objectives
Online forms
Online data flow
|
135
135
136
137
|
Lesson 4: Cost maintenance batch process
Lesson objectives
Batch programs
Batch process and integration data flow
|
138
138
139
140
|
| Module 9: Purchase order |
141 |
Lesson 1: Purchase order maintenance overview
Lesson objectives
Purchase orders
Methods of purchase order creation
|
142
142
143
144
|
Lesson 2: Purchase order maintenance data model
Lesson objectives
Data model
Key table description
Other tables
|
145
145
146
151
153
|
Lesson 3: Purchase order maintenance online process
Lesson objectives
Online forms
Online data flow
|
154
154
155
158
|
Lesson 4: Purchase order maintenance batch process
Lesson objectives
Batch programs
Batch process and integration data flow
|
159
159
160
163
|
| Module 10: Replenishment |
165 |
Lesson 1: Replenishment overview
Lesson objectives
Replenishment
Stock category
Order control
Replenishment Method
Lead time
|
166
166
167
167
168
169
174
|
Lesson 2: Replenishment data model
Lesson objectives
Data model
Key table description
Other tables
|
175
175
176
181
181
|
Lesson 3: Replenishment online process
Lesson objectives
Online forms
Online data flow
|
186
186
184
187
|
Lesson 4: Replenishment batch process
Lesson objectives
Batch programs
Batch process and integration data flow
|
188
188
189
192
193
|
| Module 11: Transfers |
197 |
Lesson 1: Transfer overview
Lesson objectives
Transfers
Transfer set up
Transfer type
Transfers with finishing
Transfer status
Mass return transfers
Mass transfer status
|
198
198
199
199
199
200
201
202
202
|
Lesson 2: Transfer data model
Lesson objectives
Data model
Key table description
Other tables
|
203
203
204
207
208
|
Lesson 3: Transfer online process
Lesson objectives
Online forms
Online data flow
|
209
209
210
212
|
Lesson 4: Transfer batch process
Lesson objectives
Batch programs
Batch process and integration data flow
|
213
213
214
218
|
| Module 12: Stock count |
221 |
Lesson 1: Stock count overview
Lesson objectives
Stock counts
|
222
222
223
|
Lesson 2: Stock count data model
Lesson objectives
Data model
Key table description
Other tables
|
224
224
225
226
227
|
Lesson 3: Stock count online process
Lesson objectives
Online forms
Online data flow
|
228
228
229
232
|
Lesson 4: Stock count batch process
Lesson objectives
Batch programs
Batch process and integration data flow
|
233
233
234
236
|
| Module 13: Stock ledger |
241 |
Lesson 1: Stock ledger overview
Lesson objectives
Stock ledger
Methods of accounting
Cost method of accounting calculations
WAC Calculation
Standard Cost Calculations
Retail method of accounting calculations
Retail method Calculations
Stock counts and budget shrinkage
End of year (NWP) inventory
|
242
242
243
244
245
246
247
248
249
250
250
|
Lesson 2: Stock ledger data model
Lesson objectives
Data model
Key table description
Other tables
|
251
251
252
255
257
|
Lesson 3: Stock ledger online process
Lesson objectives
Online forms
Online data flow
|
258
258
259
260
|
Lesson 4: Stock ledger batch process
Lesson objectives
Batch programs
Batch process and integration data flow
|
261
261
262
264
|
| Appendix: System Variables |
265 |
