Go to primary content
Oracle® Retail Pricing Operations Guide
Release 22.1.301.0
F60048-03
Next
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 Overview
Scheduling Constraints
Restart/Recovery
Key Tables Affected
Design Assumptions
FutureRetailPurgeBatch
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)
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
Usage
Detail
Primary Tables Involved
Threading
ProcessPendingChunkBatch Batch
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
Clearance Induction
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
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
Initial Price - v2
Business Overview
Service Type
REST URL
Roles Allowed
Request Headers
URL Query Parameters
Request Body
Response Body
Clearance Price - v2
Business Overview
Service Type
REST URL
Roles Allowed
Request Headers
URL Query Parameters
Request Body
Response 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