Contents

List of Figures

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Customer Support
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Help Center (docs.oracle.com)
• Conventions

1 Introduction

• Roles and Responsibilities

2 Data Entities

• Base Seeding and Manual Configuration
• Functional Conversion
• Foundation Data and Item
  • Core Foundation
  • Optional Foundation
  • Hierarchies
  • Pricing Foundation
  • Suppliers and Partners
  • Core Item
  • Optional Item
  • Other
• Pricing
  • Future Retail
  • Clearance Markdowns
  • Key Assumptions
• Purchase Orders
  • Key Assumptions
• Inventory Transactions
  • Customer Orders
    • Create Customer Orders
  • Key Assumptions
  • Sales History and Warehouse Issues
    • Key Assumptions
• Stock on Hand and Stock Ledger
  • Non-Sellable Inventory
  • Stock on Hand
  • Stock Ledger
  • Key Assumptions
• Converting Other Data
  • Sales Audit Totals and Rules
  • Custom Flex Attributes (CFAS)
  • Custom Validation Rules
  • Data Filtering
  • Duty and Privilege Configuration for Roles
  • Converting Non-Merchandising Solutions

3 Getting Started

• Key Assumptions

4 Prepare for Conversion

• Overall Customer Responsibilities
  • Download Templates
  • Key Data File Assumptions
  • Department Example
  • Integration Triggers
  • Golden Gate Replication

5 Data Conversion Application

• Logging In
• Import from File
  • View Upload Errors
  • Correct Import Errors
• Data Validation
  • View Data Validation Errors
  • Correct Data Validation Errors
• Business Validation
  • View Business Validation Errors
  • Correct Business Validation Errors
• View Uploaded Data
• Mass Upload
  • Mass Upload Results
  • View Errors
  • Download Errors
    • Download Errors
    • Download Failed Data
  • Search for a Mass Upload Process

6 Load to Production Environment

• Monitoring and Troubleshooting
  • Contextual Reports
  • User Interface Monitoring
  • Database Monitoring

7 Mock Conversions

• Important Notes

8 Task Execution Engine

• Important Notes

A Appendix: Entity Sequence List

• Entity Groups
• Entity Details
• Entities

B Appendix: Offline File Validator

• Prerequisites
  • Download the Off-line File Validator
  • Use the Off-line File Validator
  • Bulk Offline Validation

C Appendix: Loading Replenishment Data

• Manual Spreadsheet Upload
• Bulk Upload Batch
• Replenishment Schedule ReST Service
• Custom Load Script
• Key Considerations

D Appendix: Best Practices

• Data Conversion Tool
• Item Conversion
• Item Location Conversion
• Purchase Orders Conversion

E Appendix: Conversion APIs

• Entities Supported
• Key Considerations
  • Key Data File Assumptions
• Use Conversion API
  • Loading to Staging Tables
  • Loading to Merchandising Main Tables
  • Stock Ledger Initialization Job
  • Backup and Purge Job
• Conversion Process Flow

F Appendix: Publication Tables and Triggers

• MFQUEUE Triggers
• Publication Tables

G Appendix: Tables List

H Appendix: Frequently Asked Questions