Batch Schedule Definitions

The RDE jobs have been labeled and categorized by their primary purpose, so you can easily identify jobs you may want to enable or disable for your implementation. The bulk of the RDE jobs are divided into two main classifications, which are dimension jobs (those with RDE_EXTRACT_DIM_* in their job names) and fact jobs (those with RDE_EXTRACT_FACT_* in their job names). They are also grouped into execution phases based on their functional usage, as described in the tables below. The phases are all run in parallel to each other and don’t have dependencies between them, they are purely for ease of use.

Table 4-1 RDE Dimension Phases

DIMENSION PHASE No. GROUPING FACTOR

P1

Consists of dimension jobs that populate the GRP1, GRP2, and GRP3 staging tables

P2

Consists of the Security jobs (RAF table entries)

P3

Consists of dimension jobs related to the item (for example, Merch hierarchy, item charges, item season, RDW_DELETE*)

P4

Consists of dimension jobs related to Custom Flex Attributes (CFA)

P5

Consists of dimension jobs related to Replenishment

P6

Consists of dimension jobs related to Merch Organization Hierarchy (for example, location list, location traits, organization financial information, and so on)

P7

Consists of dimension jobs related to Transfers (for example, transfer details, transfer charges, and so on)

P8

Consists of dimension jobs related to extract of codes used by Merchandising (for example, Inventory Adjustment reasons, Inventory status types, codes, and so on)

P9

Consists of dimension jobs related to the supplier (for example, supplier traits, supplier information, and so on)

P10

Consists of dimension jobs related to Purchase Orders (for example, PO Details, Shipment Details, ELC, and so on)

P11

Consists of dimension jobs related to allocation (for example, Allocation detail, allocation charges, and so on)

P12

Consists of dimension jobs related to Merchandising Calendar information

P13

Consists of dimension jobs related to Merchandising promotions

P14

Consists of dimension jobs related to employee information

P15

Consists of dimension jobs related to competitor information

P16

Consists of dimension jobs related to Merchandising Parameter tables (*_GS).

P17

Consists of dimension jobs related to buyer information

P18

Consists of Merchandising Lookup Dimension information.

P19

Consists of Company Closure Dimension information.

P20

Consists of Deal Dimension information.

Table 4-2 RDE Fact Phases

FACT PHASE No. GROUPING FACTOR

P1

Consists of cost fact information jobs (for example, Base Cost, net Cost, and so on)

P2

Consists of price fact information jobs (for example, item price, competitor price, and so on)

P3

Consists of purchase order fact jobs

P4

Consists of transfer / RTV fact jobs

P5

Consists of Supplier fact jobs

P6

Consists of Stock Ledger fact jobs

P7

Consists of fact jobs related to inventory (for example, unavailable inventory, inventory receipt, and so on)

P8

Consists of fact jobs related to transactions - they mostly read from IF_TRAN_DATA (for example, deal income, intercompany margin, and so on)

P9

Consists of Allocation fact jobs

P10

Consists of stock count fact jobs

P11

Consists of replenishment fact jobs