Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Customer Support
• Review Patch Documentation
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction

• Contents of This Guide
  • Volume 1 - Batch Overviews and Designs
  • Volume 2 - Message Publication and Subscription Designs
    • External Subscription RIB APIs
• RMS Modules
• Batch Schedule
  • Pro *C Input and Output Formats
  • General Interface Discussion
  • Standard File Layouts
  • Detail-Only Files
    • Master and Detail Files

2 Administration Batch

• Program Summary
• async_job_status_retry_cleanup.ksh (Purge Asynchronous Job Tables)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Input/Out Specification
• prepost (Pre/Post Helper Processes for Batch Programs)
  • Design Overview
  • Scheduling Constraints
  • Restart Recovery
  • Key Tables Affected
• dlyprg (Daily Purge of Foundation Data)
  • Design Overview
  • Scheduling Constraints
  • Restart Recovery
  • Key Tables Affected
  • Input/Output Specification
• taxevntprg (Tax Event Purge)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Input/Output Specification
• dtesys (Increment Virtual Business Date)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Input/Output Specification
• trunctbl.ksh (Truncate Table Script)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rms_oi_purge.ksh (Purge Dashboard Working Tables)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• raf_notification_purge.ksh (Purge RAF Notifications)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• batch_archive_purge_hist.ksh (Archive and Truncate Purge History Tables)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specifications
• admin_api_purge.ksh (Purge Manage Admin Records)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specifications

3 Foundation Data Maintenance

• Batch Design Summary
• admin_api_purge (Purge Manage Admin records)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
• batch_compeffupd (Update ELC Components)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• batch_expprofupd (Apply Pending Rate Changes to Expense Profiles)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• batch_depchrgupd (Apply Pending Up-Charge Cost Component Changes to Departments)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• batch_itmcostcompupd (Apply Pending Item Cost Component Updates)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• batch_alloctsfupd (Update Allocation and Transfer Based on Changes to Up-Charges)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• batch_ordcostcompupd (Apply Pending Cost Component and ELC Changes to Purchase Orders)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• elcexcprg (Purge Aged Cost Component Exceptions)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• dfrtbld (Build Diff Ratios Based on Sales History)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
  • Input File Layout
  • Design Assumptions
• lclrbld (Rebuild Dynamic Location Lists)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• batch_rfmvcurrconv (Refresh Currency Conversion Materialized View)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• refmvlocprimaddr (Refresh Address Materialized View)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• cremhierdly (Process Pending Merchandise Hierarchy Changes from External Systems)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• reclsdly (Reclassify Items in Merchandise Hierarchy
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• supmth (Rollup of Supplier Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• schedprg (Purge Aged Store Ship Schedule)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• prchstprg(Purge Aged Price History Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• tcktdnld (Download of Data to be Printed on Tickets)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Output File Layout
  • Design Assumptions
• refmvl10entity (Refresh MV MV_L10N_ENTITY)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • Key Tables Affected
• likestorebatch (Like Store Batch Processing)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• straddbatch.ksh (Store Add Asynchronous Process)
  • Business Overview
  • Key Tables Affected
  • Design Assumptions
    • Queue Creation
  • Design Overview - Process Steps
  • Running entire store-add as batch in case of AQ issues
  • Building Schedule Dependencies between Async process and other batches
  • Monitoring Progress of Store-Add Processes
• CORESVC_STORE_ADD_SQL. ADD_STORE (Store Add Asynchronous Process)
  • Business Overview
  • Key Tables Affected
  • Design Assumptions
    • Queue Creation
  • Design Overview - Process Steps
  • Package Impact
    • Function Level Description - ADD_STORE
    • Function Level Description - ENQUEUE_STORE_ADD
    • Function Level Description - ENQUEUE_STORE_ADD_RETRY
    • Function Level Description - NOTIFY_STORE_ADD
  • Operations and Monitoring
    • Running entire Store-Add as Batch in Case of AQ Issues
    • Building Schedule Dependencies between Async Process and other Batches
    • Monitoring Progress of Store-Add Processes

4 Item Maintenance

• Program Summary
• sitmain (Scheduled Item Maintenance)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• vatdlxpl (Mass VAT Updates for Items/Locations)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• iindbatch.ksh (Upload Item Data)
  • Design Overview
  • Scheduling Constraints
  • Key Tables Affected
• itm_indctn_purge.ksh (Purge Item Induction Staging Tables)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• Pricingeventprocess.ksh (Main Processing of Executing the Price Events)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
  • Financial Transaction

5 Custom Flexible Attributes Solution

• Program Summary
• cfagen (CFAS Database Object Creation Script)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
• cfamigrate (CFAS Metadata Migration script)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• cfastgload (Bulk load of CFAS Attribute Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification

6 Purchase Order

• Batch Design Summary
• edidlord (Download of Purchase Orders from RMS to Suppliers)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• ediupack (Upload Purchase Order and Purchase Order Change Acknowledgements from Suppliers to RMS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Input File
  • Design Assumptions
• vrplbld (Build Purchase Orders for Vendor Generated Orders)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• genpreiss (Generate Pre-Issued Order Numbers)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• supcnstr (Scale Purchase Orders Based on Supplier Constraints)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• orddscnt (Apply Deal Discounts to Purchase Orders)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• ordupd (Update Retail Values on Open Purchase Orders)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• ordautcl (Auto Close Purchase Orders)
  • Design Overview
    • Category 1
    • Category 2
    • Category 3
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• ordrev (Write Purchase Order Information to Purchase Order History Tables)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• ordprg (Purge Aged Purchase Orders)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• poindbatch.ksh (Upload Order Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• po_indctn_purge.ksh (Purge PO Induction Staging Tables)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

7 Deals

• Program Summary
• dealupld (Upload of Deals from 3rd Party Systems)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
• batch_ditinsrt.ksh (Deal Calculation Queue Insert Multithreading)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• ditinsrt (Insert into Deal Calculation Queue)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• discotbapply (Update OTB After Deal Discounts)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• dealact (Calculate Actual Impact of Billback Deals)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• dealinc (Calculate Weekly/Monthly Income Based on Turnover)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• dealday (Daily Posting of Deal Income to Stock & General Ledgers)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• dealfct (Calculates/Update Forecasted Values for Deals)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
• vendinvc (Stage Complex Deal Invoice Information)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
• vendinvf (Stage Fixed Deal Invoice Information
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
• dealcls (Close Expired Deals)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• dealprg (Purge Closed Deals)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected

8 Contracts

• Batch Design Summary
• edidlcon (Download Contracts to Suppliers)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
• ediupavl (Upload Item Availability for Type A & D Contracts from Suppliers)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• cntrordb (Create Replenishment Orders for Item/Locations on Type B Contracts)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• cntrprss (Apply Type A, C and D Contracts to Orders Created by Replenishment)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• cntrmain (Contract Maintenance and Purging)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

9 Cost Chances

• Batch Design Summary
• sccext (Supplier Cost Change Extract)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• ccprg (Cost Change Purge)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

10 Open To Buy

• Batch Design Summary
• otbdnld (Download Current & Future OTB by Subclass)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File
  • Design Assumptions
• otbdlord (Download Summary of Outstanding Orders on OTB by Subclass)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File
  • Design Assumptions
• otbupld (Upload OTB Budget from Planning Systems)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• otbprg (Purge Aged Open To Buy Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

11 Future Cost

• Future Cost Events
• Future Cost Engine Run Type Configuration
  • Synchronous
  • Asynchronous
  • Batch
• Future Cost Engine Concurrency Control
• Future Cost Engine Error Handling
• Future Cost Engine Threading/Chunking
• Future Cost Process
• Batch Design Summary
• fcthreadexec (Prepare Threads for Batch Calculation/Recalculation of Future Cost Values)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• fcexec (Execute Batch Calculation/Recalculation of Future Cost Values)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• fc_pricechg (Use Pending Price Changes to Drive Recalculation of Pricing Cost for some Franchise Item/Locations)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• costeventprg (Purge Aged Cost Events)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

12 Invoice Matching

• Batch Design Summary
• edidlinv (Download of Invoice For ReIM)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Output File Layout
  • Design Assumptions
• invclshp (Close Aged Shipments to Prevent them from Matching Open Invoices)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• invprg (Purge Aged Invoices)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

13 Replenishment

• Replenishment Sub Processes
  • Establishment/Management of Replenishment Calculation Attributes
  • Calculation of Recommended Order Quantity (ROQ)
  • Build Transactions to Replenish Inventory
  • Cleanup Replenishment Data
• Batch Design Summary
• replsizeprofile (Update Replenishment Size Profile)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rplatupd (Update Replenishment Calculation Attributes)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rilmaint (Update Replenishment Calculation Attributes by Item/Loc)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• repladj (Recalculate Maximum Levels for Floating Point Replenishment)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• replroq.ksh (Calculate Net Inventory)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• batch_reqext.ksh (Multithreading Wrapper for reqext)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• reqext (ROQ Calculation and Distribution for Item/Locs Replenished from WH)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rplext.ksh (ROQ Calculation and Distribution for Item/Locs Replenished from Supplier
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Key Tables Affected
  • Design Assumptions
• ibexpl (Determines Eligible Investment Buy Opportunities)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• ibcalc (Calculate ROQ for Profitable Investment Buys)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rplbld (Build Replenishment Orders)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• supsplit (Split Replenishment Orders Among Suppliers)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rplsplit (Truck Splitting Optimization for Replenishment)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rplapprv (Approve Replenishment Orders)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• batch_rplapprvgtax.ksh (Update Replenishment Order Taxes)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• repl_wf_order_sync.ksh (Sync Replenishment Franchise Orders
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rplprg (Purge Aged Replenishment Results)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rplathistprg (Purge Replenishment Attribute History)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• rplprg_month (Purge Replenishment Results History by Month)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• repl_indctn_purge.ksh (Purge Scheduled Replenishment Induction Staging Tables)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• replindbatch.ksh (Upload Replenishment Induction Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected

14 Inventory

• Batch Design Summary
• edidlprd (Download Sales and Stock On Hand From RMS to Suppliers)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
  • Output File Layout
  • Design Assumptions
• ordinvupld (Upload and Process Inventory Reservations from ReSA)
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
  • Input File Layout
  • Design Assumptions
• wasteadj (Adjust Inventory for Wastage Items)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• refeodinventory (Refresh End of Day Inventory Snapshot)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• invaprg (Purge Aged Inventory Adjustments)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• customer_order_purge.ksh (Purge Aged Customer Orders)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Security Considerations

15 Transfers, Allocation, and RTV

• Batch Design Summary
• docclose (Close Transactions with no Expected Appointments, Shipments or Receipts)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• dummyctn (Reconcile Received Dummy Carton IDs with Expected Cartons)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• tamperctn (Detail Receive Damaged or Tampered with Cartons)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• distropcpub (Stage Regular Price Changes on Open Allocations/Transfers so Publishing Sends New Retail to Subscribing Applications)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Integration Contract
  • Design Assumptions
• mrt (Create Transfers for Mass Return Transfer)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• mrtrtv (Create Return to Vendor for Mass Return Transfer)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• mrtupd (Close Mass Return Transfers)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• mrtprg (Purge Aged Mass Return Transfers and RTV)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rtvprg (Purge Aged Returns to Vendors)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• tsfclose (Close Overdue Transfers)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• tsfprg (Purge Aged Transfers)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• allocbt (Create Book Transfers for Allocations Between Warehouses in the Same Physical Warehouse)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

16 Sales Posting

• Creating a POSU File
• Sales Posting Business Process
• Batch Design Summary
• uploadsales.ksh (Upload POSU File for Processing)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Key Tables Affected
  • Security Considerations
  • Integration Contract
  • Input File Layout
  • Design Assumptions
    • Rolling up transactions to the item/store/price point
• uploadsales_all.ksh (Process Multiple POSU Files)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Key Tables Affected
  • Security Considerations
  • Integration Contract
  • Input File Layout
• salesprocess.ksh (Main Processing of Staged Sale/Return Transactions)
  • Design Overview
  • Scheduling Constraints
  • POSU Chunking
  • Restart/Recovery
  • Locking Strategy
  • Security Consideration
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
  • Financial Transactions
• salesgenrej.ksh (Reject POSU Transactions)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• salesuploadarch.ksh (Archive Successfully Posted Transactions)
  • Design Overview
  • Scheduling Constraints
  • Key Tables Affected
• salesuploadpurge.ksh (Purge Aged Archived POSU Transactions)
  • Design Overview
  • Scheduling Constraints
  • Performance Considerations
  • Key Tables Affected
• sales_reprocess.ksh (Re-processing of Sale/Return Transactions Due to Chunk Not Process Issue)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions

17 Sales History

• Batch Design Summary
• rpmmovavg (Maintain Smoothed, Moving Average Sales History for RPM)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Input/Output Specification
• hstbld (Weekly Sales History Rollup by Department, Class, and Subclass)
  • Design Overview
  • Scheduling Constraints - Rebuild
  • Scheduling Constraints - Normal Weekly Processing
  • Restart/Recovery
  • Key Tables Affected
• hstbld_diff (Weekly Sales History Rollup by Diff)
  • Design Overview
  • Scheduling Constraints - Normal Weekly Processing
  • Scheduling Constraints - Upon Request
  • Restart/Recovery
  • Key Tables Affected
• hstbldmth (Monthly Sales History Rollup By Department, Class And Subclass)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• hstbldmth_diff (Monthly Sales History Rollup By Diffs)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Key Tables Affected
  • Integration Contract
• hstmthupd (Monthly Stock on Hand, Retail and Average Cost Values Update)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
• hstwkupd (Weekly Stock on Hand and Retail Value Update for Item/Location)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
• hstprg (Purge Aged Sales History)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
• hstprg_diff (Purge Aged Sales History by Diff)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected

18 Stock Count

• Batch Design Summary
• lifstkup (Conversion of RWMS Stock Count Results File to RMS Integration Contract)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Input/Output Specification
  • Input File Layout
  • Output File Layout
  • Design Assumptions
• stockcountupload.ksh (Upload Stock Count Results from Stores/Warehouses)
  • Design Overview
  • Scheduling Constraints
  • Key Tables Affected
  • Input/Output Specification
  • Input File Layout
  • Design Assumptions
• stkdly (Calculate Actual Current Shrinkage and Budgeted Shrink to Apply to Stock Ledger)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• stkprg (Purge Aged Stock Count)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumption
• stkschedxpld (Create Stock Count Requests Based on Schedules)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumption
• stkupd (Stock Count Snapshot Update)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumption
• stkvar (Update Stock On Hand Based on Stock Count Results)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumption
• stkxpld (Explode Stock Count Requests to Item Level)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumption
• stockcountprocess.ksh (Process Stock Count Results)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumption

19 Oracle Retail Trade Management

• Simplified RTM Configuration
• Simplified RTM Batch Program Notes
• Batch Design Summary
• cednld (Download of Customs Entry Transactions to Brokers)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• htsupld (Harmonized Tariff Schedule Upload)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Input File Layout
  • Original Input File
• tranupld (Transportation Upload)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Input File Layout
• lcadnld (Letter of Credit Application Download)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
• lcmt700 (SWIFT File Conversion - Letter of Credit Application)
  • Design Overview
  • Scheduling Constraints
  • Integration Contract
  • Output
• lcupld (Letter of Credit Confirmation Upload)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Input File Layout
• lcmt730 (SWIFT File Conversion - Letter of Credit Confirmation)
  • Design Overview
  • Scheduling Constraints
  • Integration Contract
  • Input File Layout
  • Output File Layout
• lcmdnld (Letter of Credit Amendment Download)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Input File Layout
• lcmt707 (SWIFT File Conversion – Letter of Credit Amendment)
  • Design Overview
  • Scheduling Constraints
  • Integration Contract
  • Output
• lcup798 (Letter of Credit Drawdowns and Charges)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Input File Layout
• lcmt798 (SWIFT File Conversion – Letter of Credit Charges and Drawdowns)
  • Design Overview
  • Scheduling Constraints
  • Integration Contract
  • Input File Layout
  • Integration Contract
  • Output File Layout

20 Stock Ledger

• Stock Ledger Set Up and Accounting Methods
  • Process Flow
• Batch Design Summary
• salstage (Stage Stock Ledger Transactions for Additional Processing)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• salapnd (Append Stock Ledger Information to History Tables)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• saldly (Daily Rollup of Transaction Data for Stock Ledger)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumption
• salweek (Weekly Rollup of Data/Calculations for Stock Ledger)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• salmth (Monthly Rollup of Data/Calculations for Stock Ledger)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• salmaint (Stock Ledger Table Maintenance)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • Key Tables Affected
  • I/O Specification
• saleoh (End Of Half Rollup of Data/Calculations for Stock Ledger)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• salprg (Purge Stock Ledger History)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• nwppurge (Purge of Aged End of Year Inventory Positions)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• nwpyearend (End of Year Inventory Position Snapshot)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• stlgdnld (Daily or Weekly Download of Stock Ledger Data)
  • Design Overview
  • Scheduling Constraints
  • Normal Weekly Data
  • Historical Data
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Input File Layout
  • Output File Layout
  • Design Assumptions
• otbdlsal (Open To Buy Download Stock Ledger)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • Key Tables Affected
  • Integration Contract
  • File Layout
• trandataload.ksh (External Transaction Data Upload)
  • Design Overview
    • Chunking Logic
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification - Input File Specification
    • File Layout
  • Design Assumptions
• trandataprocess.ksh (External Transaction Data Process)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

21 Franchise Management

• Customers
• Costing
• Franchise Orders
• Franchise Returns
• Batch Design Summary
• fcosttmplupld (Upload Cost Buildup Template)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
  • SQL Loader Input File Layout
  • Design Assumptions
• fcosttmplprocess (Process Cost Buildup Template Upload)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• fcosttmplpurge (Purge Staged Cost Template Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• fcustomerupload (Franchise Customer Upload)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
  • Design Assumptions
• fcustomerprocess (Process Uploaded Franchise Customers and Customer Groups)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Commit Points
  • Key Tables Affected
  • Process Flow
• fcustupldpurge (Franchise Customer Staging Purge)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• wfordupld.ksh (Franchise Order Upload)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
  • SQL Loader Input File Layout
  • Design Assumptions
• wf_apply_supp_cc.ksh (Apply Supplier Cost Change to Franchise Orders)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• wfordcls (Franchise Order Close)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• wfordprg (Franchise Order Purge)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• wfretupld.ksh (Franchise Return Upload)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
  • SQL Loader Input File Layout
  • Design Assumptions
• wfretcls (Franchise Return Close)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• wfrtnprg (Franchise Return Purge)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• wfslsupld.ksh (Upload of Franchise Sales to RMS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Input File Layout
  • Design Assumptions
• wfbillex.ksh (Franchise Billing Extract)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Output File Layout
  • Design Assumptions

22 Competitive Pricing

• Batch Design Summary
• cmpupld (Upload Competitor's Prices)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Input File Layout
  • Design Assumptions
• cmpprg.pc (Purge Aged Competitive Pricing Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

23 Item Induction

• Batch Design Summary
• loadods.ksh (Item Induction)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • SQL Loader Input File Layout
• iindbatch.ksh (Upload Item Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• ld_iindfiles.ksh (Upload Data From Templates)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• itm_indctn_purge (Purge Item Induction Staging Tables)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions

24 Integration with Xstore

• Foundation Data Bulk Export
  • Foundation Data RIPB Publishing
  • Foundation Data Bulk Export
• Bulk Export Pattern
• Points of Note
• Base Oracle Retail Usage
• Client Specific Usage Recommendations
• Batch Design Summary
• export_merchhier.ksh (Extract of Merchandise Hierarchy data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
  • Design Assumptions
• export_orghier.ksh (Extract of Organizational Hierarchy Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• export_stores.ksh (Extract of Store Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• export_diffs.ksh (Extraction of differentiators data defined for a differentiator type)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• export_diffgrp.ksh (Extraction of differentiator groups data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• export_itemloc.ksh (Extraction of item location data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• export_itemvat.ksh (Extraction of vat item data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• export_itemmaster.ksh (Extraction of item data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• export_vat.ksh (Extraction of vat data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• export_relitem.ksh (Extraction of item data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• export_stg_purge.ksh (Purging of all the extracted data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions

25 Integration with Third Party POS

• Program Summary
• taxdnld (Tax Download to 3rd Party POS in Global Tax [GTAX] Implementations)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • I/O Specification - Output File Layout
• poscdnld (Download of POS Configuration Data to 3rd Party POS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
  • Output File Layout

26 Integration with Advanced Inventory Planning

• Foundation Data vs Transaction/Inventory Data
• Program Summary
• rmse_aip_batch (Optional Wrapper Script to run all AIP Extracts)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Integration Contract
• pre_rmse_aip (Extract of RMS System level settings for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
• rmse_aip_merchhier (Extract of Merchandise Hierarchy for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• rmse_aip_orghier (Extract of Organization Hierarchy for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• rmse_aip_item_master (RMS Extract of Items for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • Key Tables Affected
  • Integration Contract
  • File Layout
  • Integration Contract
• rmse_aip_store (Extract of Stores for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• rmse_aip_wh (Extract of Warehouses for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
  • Integration Contract
  • File Layout
  • Integration Contract
  • File Layout
• rmse_aip_substitute_items (Extract of Substitute Items for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
  • File Layout
• rmse_aip_suppliers (Extract of Suppliers for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
  • Integration Contract
  • File Layout
  • Integration Contract
  • File Layout
• rmse_aip_alloc_in_well (Extract of Allocations in the Well Quantities for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• rmse_aip_cl_po (Extract of AIP Generated POs, Allocations and Transfers Cancelled or Closed in RMS for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• rmse_aip_future_delivery_alloc (Extract of Allocation Quantities for Future Delivery for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• rmse_aip_future_delivery_order (Extract of Purchase Order Quantities for Future Delivery to AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• rmse_aip_future_delivery_tsf (Extract On Order and In Transit Transfer Quantities for Future Delivery for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• rmse_aip_item_loc_traits (Extract of Shelf Life on Receipt Location Trait for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• rmse_aip_item_retail (Extract of Forecasted Items for AIP)
  • Design Overview
    • Non-Pack Items
    • Simple Pack Components
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• rmse_aip_item_sale (Extract of Scheduled Item Maintenance On/Off Sale Information for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
  • Integration Contract
  • File Layout
  • File Layout
• rmse_aip_item_supp_country (Extract of Order Multiples by Item/Supplier/Origin Country for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
  • Integration Contract
  • File Layout
  • File Layout
• rmse_aip_rec_qty (Extract of Received PO, Allocation and Transfer Quantities for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • I/O Specification
  • File Layout
• rmse_aip_store_cur_inventory (Extract of Store Current Inventory data for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
• rmse_aip_tsf_in_well (Extract of Transfer in the Well Quantities to AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
  • File Layout
• rmse_aip_wh_cur_inventory (Extract of Warehouse Current Inventory for AIP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout

27 Integration with General Ledger

• Batch Design Summary
• dealfinc (Calculation of Fixed Deal Income for General Ledger)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• fifgldn1 (Interface to General Ledger of Item/Loc Level Transactions)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• fifgldn2 (Interface to General Ledger of Rolled Up Transactions)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• fifgldn3 (Interface to General Ledger of Month Level Information)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• gl_extract.ksh (Extraction of General Ledger transaction data from RMS and RESA)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • File Layout
  • Design Assumptions

28 Integration with Oracle Retail Planning

• Foundation Data vs Transaction/Inventory Data
• RPAS Integration Program Summary
• RDF Integration Program Summary
• MFP Integration Program Summary
• pre_rmse_rpas (Extract of RMS System level settings for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_rpas_suppliers (Extract of Suppliers for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_rpas_merchhier (Extract of Merchandise Hierarchy for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_rpas_orghier (Extract of Organizational Hierarchy for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Output File Layout
  • Integration Contract
    • Output File
  • Design Assumptions
• rmse_rpas_wh (Extract of Warehouses for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_rpas_store (Extract of Stores for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_rpas_item_master (Extract of Items for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_rpas_domain (Extract of Domains for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_rpas_attributes (Extract of User Defined Attributes for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
• rmse_rpas_weekly_sales (Extract of Weekly Sales of Forecasted Items for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_rpas_daily_sales (Extract of Daily Sales of Forecasted Items for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_rpas_stock_on_hand (Extract of Stock On Hand of Forecasted Items for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_rpas (RMS-Planning Extract Wrapper Script)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Integration Contract
  • Design Assumptions
• rmsl_rpas_update_retl_date (Update Last RPAS Extract Date)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• soutdnld (Stockout Download)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• ftmednld (Download of Time Hierarchy for Planning Systems)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rms_oi_forecast_history.ksh (Retain Item Forecast History)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rmsl_rpas_forecast (RMS Load of Forecast from RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • File Layout
  • Design Assumptions
• fcstprg (Purge Forecast Data)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• rmse_rdf_daily_sales (Extract of Daily Sales of Forecasted Items for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • File Layout
  • Design Assumptions
• rmse_rdf_weekly_sales (Extract of Weekly Sales of Forecasted Items for RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_mfp_inventory (Extract of Inventory Aggregation for MFP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• rmse_mfp_onorder (Extract of On Order for MFP)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• onictext (On Inter-Company Transfer Exhibit)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • Key Tables Affected
  • Integration Contract
    • File Layout
  • Integration Contract
    • Staging Table
• onordext (On Order Extract)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • Key Tables Affected
  • Integration Contract
  • Integration Contract
• gradupld (Upload of Store Grade Classifications from RPAS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Input File Layout
  • Design Assumptions
• onorddnld (On Order Download to Financial Planning)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Locking Strategy
  • Security Considerations
  • Performance Considerations
  • Key Tables Affected
  • Integration Contract
    • Output File Layout

29 Oracle Retail Sales Audit Batch Process and Designs

• Oracle Retail Sales Audit Dataflow Diagram
• Oracle Retail Sales Import Process
• POS File Validation/Upload Sub-Process saimiptlog vs saimptlogi
• Total Calculations and Rules
  • Totals when Transactions are Modified
• Oracle Retail Sales Export Process
  • Full Disclosure and Post Export Changes
• Batch Design Summary of ReSA Modules
  • Import Process Programs
  • Totals/Rules Programs
  • Export Programs
  • Other Programs
• sastdycr (Create Store Day for Expected Transactions)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• sagetref (Get Reference Data for Sales Audit Import Processing)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • File Name: Item File
    • File Name: Waste Data File
    • File Name: Reference Item Data
    • File Name: Primary Variant Data File
    • File Name: Variable Weight UPC Definition File
    • File Name: Valid Store/Day Combination File
    • File Name: Codes File
    • File Name: Error Information File
    • File Name: Store POS Mapping File
    • File Name: Tender Type Mapping File
    • File Name: Merchant Code Mapping File
    • File Name: Partner Mapping File
    • File Name: Supplier Mapping File
    • File Name: Employee Mapping File
    • File Name: Banner Information File
    • File Name: Currency Information File
    • File Name: Promotion Information File
    • File Name: Physical Warehouse Information File
    • File Name: Inventory Status Information File
  • Design Assumptions
    • Making Changes in the CODE_DETAIL Table
    • Primary Variant Relationships
• saimptlog/saimptlogi (Import of Unaudited Transaction Data from POS to ReSA)
  • Design Overview
  • Scheduling Constraints
  • Restart and Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
    • Control Files
    • ReSA Interface File Layout [rtlog]
    • Common Requirements/Validations
    • Requirements per Record Types
    • Code Type Validations
    • Transaction of Type SALE
    • Transaction of Type PVOID
    • Transaction of type RETURN
    • Transaction of type SPLORD
    • Transaction of type EEXCH
    • Transaction of type PAIDIN
    • Transaction Type PAIDOU
    • Transaction of Type PULL
    • Transaction of Type LOAN
    • Transaction Type Cond
    • Transaction of Type TOTAL
    • Transaction of Type METER
    • Transaction of Type PUMPT
    • Transactions of Type TANKDP
    • Transaction of Type DCLOSE
    • Transaction of Type OTHER
  • Design Assumptions
  • DCLOSE Transaction Type
• saimptlogtdup_upd (Processing to Allow Re-Upload of Deleted Transactions)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• saimptlogfin (Complete Transaction Import Processing)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• savouch (Sales Audit Voucher Upload)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Input File Layout
  • Design Assumptions
• saimpadj (Import Total Value Adjustments From External Systems to ReSA)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Input File Layout
  • Design Assumptions
• satotals (Calculate Totals based on Client Defined Rules)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• sarules (Evaluate Transactions and Totals based on Client Defined Rules)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• sapreexp (Prevent Duplicate Export of Total Values from ReSA)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• saexprms (Export of POS transactions from ReSA to RMS)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • File Layout
  • Design Assumptions
• saordinvexp (Export Inventory Reservation/Release for In Store Customer Order & Layaway Transactions from ReSA)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• saexpdw (Export from ReSA to Oracle Retail Analytics)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Oracle Retail Sales Audit (ReSA) - File Layout - Retail Analytics
    • RDWT File Layout
    • Transaction Item Information Produced by saexpdw.pc after Translation by resa2dw
    • RDWF File
    • Retail Analytics Form of Payment File after Translation by resa2dw
    • RDWS File
    • Store Totals Information after Translation by resa2dw
    • RDWC File
    • Cashier/ Register Totals Information after Translation by resa2dw
  • Design Assumptions
• saexpsim (Export of Revised Sale/Return Transactions from ReSA to SIM)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File
  • Design Assumptions
• saexpim (Export DSD and Escheatment from ReSA to Invoice Matching)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• saexpgl (Post User Defined Totals from ReSA to General Ledger)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• ang_saplgen (Extract of POS Transactions by Store/Date from ReSA for Web Search)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File Layout
  • Design Assumptions
• saescheat (Download of Escheated Vouchers from ReSA for Payment)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• saescheat_nextesn (Generate Next Sequence for Escheatment Processing)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• saexpach (Download from ReSA to Account Clearing House (ACH) System)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Security Considerations
  • Key Tables Affected
  • Integration Contract
    • Output File
  • Design Assumptions
• saexpuar (Export to Universal Account Reconciliation System from ReSA)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
    • Output File
  • Design Assumptions
• saprepost (Pre/Post Helper Processes for ReSA Batch Programs)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions
• sapurge (Purge Aged Store/Day Transaction, Total Value and Error Data from ReSA)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Integration Contract
  • Design Assumptions