Contents

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

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

1 Introduction

2 Pricing Batch Processes

• BDI Clearance Publishing (BDI_PRICING_CLR_TX _JOB)
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
  • Output
• BDI Price Change Publishing (BDI_PRICING_PC_TX_CYCLE_JOB)
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
  • Output
• Clearance Cache Batch
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• ClearanceInductionBatch (Clearance Induction Batch)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• ClearancePriceChangePublishBatch (Clearance Price Change Publish Batch)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Output File
    • Output File Layout
  • Design Assumptions
• ClearanceRDEDataBatch Design
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• FutureRetailPurgeBatch Design
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• FutureRetailRollUpBatch (Future Retail Roll Up Batch)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• ItemReclassBatch (Item Reclass Batch)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• NewItemLocationBatch (New Item Location Batch Batch)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• NightlyBatchCleanup (Nightly Cleanup Batch)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• Price Change Cache Batch
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• PriceChangeInductionBatch (Price Change Induction Batch)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• PriceEventExecutionBatch (Price Event Execution Batch)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
  • PriceEventExecutionForChunkCCEmergencyEvents Batch Design
    • Usage
    • Detail
    • Primary Tables Involved
    • Threading
  • ProcessPendingChunkBatch Batch Design
    • Usage
    • Details
    • Assumptions and Scheduling Notes
    • Primary Tables Involved
    • Threading
• Promotion Cache Batch
  • Design Overview
  • Scheduling Constraints
  • Key Tables Affected
  • Design Assumptions
• PromotionInductionBatch (Promotion Induction Batch)
  • Design Overview
  • Scheduling Constraints
  • Key Tables Affected
• Promotion Publishing (BDI_PRICING_PROMO_OFFER_TX_CYCLE_JOB)
  • Scheduling Constraints
  • Restart/Recovery
  • Promotions Integration
  • Payload Tables
    • Payload Population Logic
  • BDI Tables
  • Key Tables Affected
  • Output
    • PRC_PAYLD_MSG_HDR_OUT
    • PROMO_OFFER_OUT
    • PROMO_OFFER_COND_OUT
    • PROMO_OFR_REWARD_OUT
    • PROM_OFR_CND_MRCH_OUT
    • PROM_OFR_RWD_MRCH_OUT
    • PROMO_OFFER_LOC_OUT
    • PROMO_OFR_CANCEL_OUT
    • PROM_OFR_CNCL_ITM_OUT
    • PROM_OFR_CNCL_LOC_OUT
• Purge Batch (PurgeBatch)
  • System Options
  • Usage
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
• PurgeGTTCaptureBatch (Purge GTT Capture Batch)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• PurgeItemLocPayloadUnusedCCBatch
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Design Assumptions
• RegularPriceChangePublishBatch (Regular Price Change Publish Batch)
  • Design Overview
  • Scheduling Constraints
  • Restart/Recovery
  • Key Tables Affected
  • Output Files
    • Output File Layout
  • Design Assumptions

3 ReST Services

• Price Inquiry
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Initial Retail
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Price Change Induction
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Price Change Induction Submit
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Price Change Induction Poll
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Clearance Induction
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Clearance Induction Submit
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Clearance Induction Poll
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Promotion Create
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Promotion Create
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Promotion Induction Poll
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Item Price - v1
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Item Price - v2
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• • Request Body
• Item Promotion - v1
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body
• Item Promotion - v2
  • Business Overview
  • Service Type
  • REST URL
  • Roles Allowed
  • Request Headers
  • URL Query Parameters
  • Request Body
  • Response Body

4 Backend System Administration and Configuration

• Supported Environments
• Exception Handling
• Logging Configuration
  • ADF Logging
  • Batch Client Logging
  • Batch_logging Properties
• Configurable GTTCapture