Go to primary content
Oracle® Retail Merchandising Conversion Implementation Guide
Release 19.3.000
F44081-03
Next
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