Header Ads Widget

Oracle Retail Merchandising System Interview Questions - RMS Essentials

Hello everyone, Today I am going to list down all the Oracle Retail Merchandising topics. Oracle retail resource should know all of these to crack interview. Use this link to find answers to this questions. First check the topic then open the below link, else you will waste your time.. https://oretail.blogspot.com/2016/07/oracle-retail-merchandising-system-rms.html?m=0

Application Overview

1. Define RMS

2. Explain the Oracle Retail solution footprint

Organizational Hierarchy

1. Identify tables involved in the organizational hierarchy and understand the relationship between each table

2. Identify online forms involved in the organizational hierarchy

3. Explain the relationship between each form and its base table involved in the organizational hierarchy

4. Identify batch programs involved in the organizational hierarchy

5. Explain the relationship between each batch program and its driving table or file involved in the organizational hierarchy

Read this also How to prepare for oracle retail interviews 

Merchandising Hierarchy

1. Identify tables involved in the merchandise hierarchy and the relationship between each table

2. Identify online forms involved in the merchandise hierarchy

3. Understand the relationship between each form and its base table involved in the merchandise hierarchy

4. Identify batch programs involved in the merchandise hierarchy

5. Understand the relationship between each batch program and its driving table or file involved in the merchandise hierarchy

Suppliers and Supplier Sites

1. Describe setting up suppliers in RMS

2. Identify tables involved in supplier maintenance and understand the relationship between each table

3. Identify online forms involved in supplier maintenance

4. Understand the relationship between each form and its base table involved in supplier maintenance

5. Identify batch programs involved in supplier related processes

6. Understand the relationship between each batch program and its driving table or file involved in supplier related processes

7. Explain supplier sites

Item Maintenance

1. Identify and explain the item online processes, batch processes and data flows

2. Identify the high-level integration points associated with items

3. Identify key tables and understand the relationship between each table in item maintenance

4. Identify online forms and understand the relationship between each form and its base table involved in item maintenance

5. Identify batch programs and understand the relationship between each batch program and its driving table or file involved in item maintenance related processes.

6. Define UDA and its maintenance.

Pack Item Maintenance

1. Identify and explain the pack item online processes

2. Name key tables associated with pack items

3. Identify and explain the pack item batch processes

4. Identify the data flow of the online and batch processes associated with pack items

5. Identify the high-level integration points associated with pack items

Cost Maintenance

1. Identify and explain the cost maintenance online processes and batch processes

2. Identify high-level integration points, key tables, online forms, batch programs involved in cost maintenance related processes

3. Understand the relationship between each table, online form, base table, and batch program involved in cost maintenance related process

Purchase Order

1. Identify and explain the purchase order maintenance online processes

2. Name key tables associated with purchase order maintenance

3. Identify and explain the purchase order maintenance batch processes

4. Identify the data flow of the online and batch processes associated with purchase order maintenance

5. Identify the high-level integration points associated with purchase order maintenance

Replenishment

1. Identify and explain the replenishment online processes

2. Name key tables associated with replenishment

3. Identify and explain the replenishment maintenance batch processes

4. Identify the data flow of the online and batch processes associated with replenishment

5. Identify the high-level integration points associated with replenishment

Transfer

1. Identify and explain the transfer online processes

2. Name key tables associated with transfers and understand the relationship between each table

3. Identify online forms involved in the transfer process

4. Understand the relationship between each form and its base table involved in transfer

5. Identify batch programs involved in transfer processes

6. Understand the relationship between each batch program and its driving table or file involved in transfer process

Stock Count

1. Describe the stock count functionality in RMS

2. Identify and explain the stock count online processes, batch processes, and online forms

3. Name key tables associated with stock counts

4. Understand the relationship between the tables, forms, and batch programs in stock counts

Stock Ledger

1. Describe the stock ledger in RMS

2. Explain the stock ledger online and batch processes

3. Identify key tables, online forms, and batch programs involved in stock ledger process

4. Describe the relationships between the key tables, online forms, and batch programs involved in the stock ledger process

Deals

1. Identify and explain the deals online processes

2. Name key tables associated with deals

3. Identify and explain the deals batch processes

4. Identify the data flow of the online and batch processes associated with deals

5. Identify the high-level integration points associated with deals

Multiple Set of Books (MSOB)

1. Describe the enterprise structure of MSOB

2. Describe the components of MSOB

3. Explain various system options and table structures for MSOB

4. Identify and explain the MSOB online processes

4. Identify changes to batch processes to support MSOB

Wholesale / Franchise

1. Define wholesale / franchise

2. Describe wholesale / franchise changes in the database, forms, batch, and reports

3. Explain wholesale / franchise's impact on costing / pricing, ordering, and financials

Custom Flex Attributes

1. Describe CFAS Components

2. Explain CFAS Database Objects

3. Discuss CFAS Data Flow

4. Define Attribute Structures

Post a Comment

0 Comments