Oracle Retail Knowledge Base

4 AI Foundation Applications Standalone Processes

36 min read

Mirror of Oracle documentation

Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.

Edit RSELMASTER_-ADHOC_JOB

Enable Job T @ Enabled Parameters -ix —from:20201012 —to:20201031 —extfrom:Y —extto:N| External Status Update None v Skip On Error — Disabled * Threshold Run Time (Sec) 0 “a

  • Sales Aggregation - Product

  • Sales Aggregation - Product Attribute

  • Sales Aggregation - Product Hierarchy

  • Sales Aggregation - Weekly

  • • Sales Forecast Aggregation - Product Attribute (Legacy) • Sales Forecast Aggregation - Product Hierarchy (Legacy)

  • Sales Shares - Product Attribute

  • Sales Transaction Load

Customer Metrics - Base Calculation

Module Name RSE_CUST_ENG_METRIC_BASE_ADHOC Description Calculate base values for customer engagement metrics. Dependencies RSE_SLS_TXN_ADHOC Business Activity Analytical Batch Processing

Design Overview

This process aggregates sales transaction data for use in customer engagement metric calculations. The process runs for a range of weeks, depending on which weeks of sales have had a run already performed. It will output the results to a database table for downstream consumption. The RSE_SLS_TXN_ADHOC job is normally a prerequisite for this, as it is used to refresh or load additional sales data.

Running this process requires parameters to specify the start and end date range for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Key Tables Affected

Table Usage RSE_SLS_TXN Input RSE_SLS_BASE_ATTR Output

Customer Metrics - Final Calculation

Module Name RSE_CUST_ENG_METRIC_CALC_ADHOC Description Finalize the customer engagement metrics calculation. Dependencies RSE_CUST_ENG_METRIC_BASE_ADHOC Business Activity Analytical Batch Processing

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Design Overview

This process calculates customer engagement metrics based on numerous inputs, including sales transaction aggregates (for behavioral and predictive metrics) and product attributes (for attribute loyalty metrics). Currently, supported product attributes must have a group type of BRAND , STYLE , COLOR , LOC_LOYALTY , or PRICE_EFF_LOYALTY , as defined in

RSE_BUSINESS_OBJECT_ATTR_MD . The RSE_CUST_ENG_METRIC_BASE_ADHOC job is normally a prerequisite for this, as it calculates the aggregated customer sales data.

Running this process requires parameters to specify the start and end date range, for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Key Tables Affected

TableUsage
RSE_SLS_BASE_ATTRInput
RSE_PROD_ATTRInput
RSE_CUST_ATTR_LOY_DTLInput
RSE_CUST_SLS_ATTROutput

Customer Metrics - Loyalty Score

Module NameRSE_CUST_ATTR_LOY_ADHOC
DescriptionCalculate customer loyalty score metrics.
DependenciesRSE_CUST_ENG_METRIC_BASE_ADHOC
Business ActivityAnalytical Batch Processing

Design Overview

This process calculates customer engagement loyalty data based on numerous inputs, including sales transactions and product attributes. Currently, supported product attributes must have a group type of BRAND , STYLE , COLOR , LOC_LOYALTY , or PRICE_EFF_LOYALTY , as defined in RSE_BUSINESS_OBJECT_ATTR_MD . The RSE_CUST_ENG_METRIC_BASE_ADHOC job is normally a prerequisite for this, as it calculates the aggregated customer sales data.

Running this process requires parameters to specify the start and end date range, for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Key Tables Affected

Table Usage RSE_SLS_BASE_ATTR Input RSE_PROD_ATTR Input RSE_CUST_ATTR_LOY_DTL Output

Data Cleanup Utility

Module Name AIF_APPS_MAINT_DATA_CLEANUP_ADHOC_PR OCESS Description Erases database tables within the AIF Apps database schema ( RASE01 ) Dependencies None Business Activity Initial Data Loads

Design Overview

As you are loading and reloading data into AIF applications, you may run into conflicts or constraint violations where you need to purge old data that is causing issues. An ad hoc process is available in the AIF APPS schedule to facilitate this cleanup activity. The job invokes the rse_data_cleanup.ksh program. The cleanup that will be done is determined based on the parameters passed into the POM job for each execution. Initially, no parameter is indicated in the job in POM. The user enters the parameters depending on their requirement. This truncates the tables based on the entered parameters. Use the table below to identify the parameters you need to use.

-h <input value> This parameter indicates which hierarchy type will be cleaned up ( PRODUCT , LOCATION , CALENDAR , PROMOTION , or CUSTSEG ).

Valid values:

  • ALL - All Hierarchy records will be cleaned up. This includes Product, Location, Calendar, Promotion and Customer Segment Hierarchies. Alternate Hierarchies are also included for location and product.

  • PRODUCT - Product Hierarchy Data

  • LOCATION - Location Hierarchy Data

  • CALENDAR - Calendar Hierarchy Data

  • PROMOTION - Promotion Hierarchy Data

  • CUSTSEG - Customer Segment Hierarchy Data

Note

If this parameter is not indicated, no hierarchies will be cleaned up even if you are using the other parameters to clean app data.

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

-r <input value> This parameter indicates whether all tables referencing the hierarchy IDs directly or indirectly will also be deleted.

Valid values:

  • Y (Yes)

  • N (No)

Default value is Y to ensure no stranded records will remain. This means any data referencing a hierarchy ID will be purged along with the hierarchy itself. All affected tables will be deleted in full; no data will be preserved.

-a <input value> This parameter indicates whether AIF application tables (such as for PMO, SPO, and so on) will be deleted.

Global Values:

  • ALL - All application tables will be cleaned up.

  • NONE - Application tables will NOT be cleaned up.

Default value is ALL to avoid any stranded records that will no longer work after data is purged. This parameter can also be used to clean up specific application tables that reference the hierarchies (directly or indirectly).

Application Values:

  • CDT (Customer Decision Tree)

  • CIS (Advanced Clustering & Segmentation)

  • DT (Demand Transference)

  • IO (IPO - Inventory Optimization)

  • MBA (Affinity Analysis / Market Basket Analysis)

  • PMO (Lifecycle Pricing Optimization – PMO_* tables)

  • PRO (Lifecycle Pricing Optimization – PRO_* tables)

  • RODS (Retail Operational Data Store)

  • SO (Space Optimization)

  • SPO (Size Profile Optimization)

-o <input value> This parameter is to indicate whether ONLY the application data will be deleted, but not any hierarchies.

Valid values:

  • Y (Yes)

  • N (No)

Note

Application Data parameter ( -a ) should also be indicated. Default value is N if not indicated. PMO and RODS don’t have specific app tables, hence they are not covered by this option. All affected tables will be deleted in full; no data will be preserved.

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Examples

To clean up all the hierarchy tables together with dependent tables and app tables, add the following as the parameter in POM:

  • -h ALL -r Y -a ALL -o N

To clean up only the location hierarchy tables together with AIF Apps dependent tables and app tables, add the following as the parameter in POM:

  • -h LOCATION -r Y -a ALL -o N

To clean up only the application tables:

  • -a ALL -o Y

To clean up only a specific application (in this example, the CIS - Clustering application tables):

  • -a CIS -o Y

Fake Customer Identification

Module Name RSE_FAKE_CUST_ADHOC Description Identify fake customers by looking through sales transaction data, so they can be automatically excluded from some applications. Dependencies RSE_SLS_TXN_ADHOC Business Activity Sales Preprocessing

Design Overview

This process analyzes sales transaction data looking for “fake” customers, which usually represent excessive sales attributed to a single customer ID. This could be caused by store cards used at the register, corporate cards used by many people, or wholesale transactions involving large numbers of sales. These kinds of transactions can have negative effects on processes like Demand Transference because they are not representative of real customer activity. The threshold for identifying a customer as fake is set using the RSE_CONFIG property FAKE_CUST_DAY_TXN_THRESHOLD .

Running this routine requires parameters to specify the start and end date range, for which data should be re-processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Key Tables Affected

Table Usage RSE_SLS_TXN Input RSE_FAKE_CUST Output

File Export Execution

Module Name RSE_POST_EXPORT_ADHOC Description Runs the export processes for any prepared AI Foundation export files, which includes file movement, zipping, and export to SFTP. Dependencies RSE_EXPORT_PREP_ADHOC Business Activity Outbound Integrations

Design Overview

This process moves, zips, and exports files from the AI Foundation applications based on the file export type. It accepts a single input parameter for the file frequency type, using one of DAILY , WEEKLY , QUARTERLY , INTRADAY , or ADHOC . This process is the second step in the data flow and assumes files have already been prepared for export using the dependent process.

File Export Preparation

Module Name RSE_EXPORT_PREP_ADHOC Description Export preparation job for a specific group of AI Foundation export files. Dependencies None Business Activity Outbound Integrations

Design Overview

This process will prepare a set of export files from the AI Foundation applications based on the file export type. It accepts a single input parameter for the file frequency type, using one of DAILY , WEEKLY , QUARTERLY , INTRADAY , or ADHOC . This is the first step in the data flow and does not perform the file movement to SFTP; it only prepares the files of the specified type so that the RSE_POST_EXPORT_ADHOC process can consume them.

Forecast Aggregates

Module Name PMO_ACTIVITY_LOAD_ADHOC_PROCESS Description Refresh the PMO_ACTIVITIES table used by AIF forecasts to manually regenerate the aggregates used for specific run types. Dependencies None Business Activity Initial Data Loads

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Design Overview

This process regenerates aggregate data on the PMO_ACTIVITIES table for a subset of forecast run types and time periods. You may want to use this process if you have loaded new historical data into AIF and want it reflected on your existing forecast run types. Make sure the run types are active in the UI before attempting to run this process on them. The process has 2 jobs: PMO_ACTIVITY_STG_ADHOC_JOB and PMO_ACTIVITY_LOAD_ADHOC_JOB . All of the parameters must be provided on the STG job.

Options:

  • -n Number of weeks to process

  • -f Force updates to existing data

  • -s Start date in YYYYMMDD format

  • -e End date in YYYYMMDD format

  • -S Start calendar day ID

  • -E End calendar day ID

  • -w Calendar week ID to process

  • -N New Forecast Run Type Aggregation Flag

  • -r Forecast Run Type ID

  • -? Display this usage information

Running this routine requires parameters to specify the start and end date range for weeks of data to process. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

-s YYYYMMDD -e YYYYMMDD -f Y -N N

Lifecycle Pricing Optimization Run

Module Name PRO_OPT_ADHOC Description Runs the LPO optimization process outside of the normal batch. Dependencies None Business Activity Analytical Batch Processing

Design Overview

This process triggers the lifecycle pricing optimization batch processing outside of the normal batch window. All of the necessary steps to calculate optimization results are included in the ad hoc job and no parameters are used. The process triggers the Java libraries on the application server that are responsible for the optimization.

Location Ranging

Module Name DT_LOC_RANGE_ADHOC

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Description Refresh Location Ranging data for Demand Transference. Dependencies DT_PROD_LOC_RANGE_ADHOC Business Activity Application Setup

Design Overview

This process calculates SKU Counts for the available ranges of products, for a given CM Group, Store Location, and Week, which may be needed during implementation of Demand Transference when using CM Groups.

Running this routine requires parameters to specify the start and end date range for weeks of data to process. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Key Tables Affected

TableUsage
DT_PROD_LOC_STATUSInput
DT_CM_GRP_LOC_STATUS_AGGROutput

Master Data Load - AA

Module NameMBA_MASTER_ADHOC_PROCESS
DescriptionRun the Afnity Analysis/Market Basket Analysis master script. This is
the best way to execute all the initial processing steps for the MBA
application module.
DependenciesRSE_MASTER_ADHOC_PROCESS
Business ActivityInitial Data Loads

Design Overview

This process controls the master set of batch programs for loading data into the Affinity Analysis (also known as Market Basket Analysis or MBA) application. It accepts one or more single-character parameters to control which steps in the process are executed. Multiple steps executed in sequence should be passed as one string.

Options:

  • -A Process all steps

  • -R <Option> Resume processing all steps, starting with the step associated with the provided option (see below options) for order

  • -e Execute MBA ETL routines

  • -c Execute ARM configuration load routines

  • -a Execute ARM processes

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

  • -r Execute RI ARM processes

  • -b Execute Baseline processes

  • -? Display this usage information

Options -A and -R will enable processing of appropriate steps. Any switch provided more than once, or after a -A or -R will toggle the switch On/Off. This will enable excluding a small number of steps from processing, without requiring specifying all other switches

Example
  • -Aa will result in running all steps except -a

Master Data Load - AC

Module Name CIS_MASTER_ADHOC_PROCESS

Description Dependencies RSE_MASTER_ADHOC_PROCESS Business Activity Initial Data Loads

Run the Advanced Clustering/Customer Segmentation master script. This is the best option to run all initial processing steps for the AC/CS modules. NOTE: when running through POM, if any — options are required, use : instead of = to separate the option from the value.

Design Overview

This process controls the master set of batch programs for loading data into the Advanced Clustering and Customer Segmentation applications. It accepts one or more single-character parameters to control which steps in the process are executed. Multiple steps executed in sequence should be passed as one string.

Options:

  • -A Process all steps

  • -R <Option> Resume processing all steps, starting with the step associated with the provided option (see below options) for order

  • -a Attribute Maintenance

  • -h Product/Attribute Share Processing

  • -t Loading cluster templates

  • -v Setup a new version

  • -s Update sales data for use by any versions

  • -m Market Sales Aggregation load

  • -c Update new versions with all the attribute summary information

  • -? Display this usage information

Options -A and -R will enable processing of appropriate steps. Any switch provided more than once, or after a -A or -R will toggle the switch On/Off. This will enable excluding a small number of steps from processing, without requiring specifying all other switches.

Example
  • -Ah will result in running all steps except -h

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

  • --from Start date of the data processing timeframe. Must be provided in YYYYMMDD format with no spaces. For example, --from:20170101 . Must be accompanied by the end date and optionally by the extfrom flag

  • --to End date of the data processing timeframe. Must be provided in YYYYMMDD format with no spaces. For example, --to:20170201 . Must be accompanied by the end date and optionally by the extto flag

  • --extfrom Optional flag to indicate if the start date must be extended to the start of the week. Accepts Y or N (default). For example, --extfrom:Y , with no spaces

  • --extto Optional flag to indicate if the end date must be extended to the end of the week. Accepts Y or N (default). For example, --extto:Y , with no spaces

Master Data Load - AE

Module Name AE_MASTER_ADHOC_PROCESS Description Run the Attribute Extraction master script. This is the best way to trigger all initial processing for the AE application. Dependencies RSE_MASTER_ADHOC_PROCESS Business Activity Initial Data Loads

Design Overview

This process controls the master set of batch programs for loading data into the Attribute Extraction application. It accepts one or more single-character parameters to control which steps in the process are executed. Multiple steps executed in sequence should be passed as one string.

Options:

  • -A Process all steps

  • -R <Option> Resume processing all steps, starting with the step associated with the provided option (see below options) for order

  • -G Global Lists of Strings loading

  • -C Product Categories loading

  • -P Product loading

  • -? Display this usage information

Options -A and -R will enable processing of appropriate steps. Any switch provided more than once, or after a -A or -R will toggle the switch On/Off. This will enable excluding a small number of steps from processing, without requiring specifying all other switches.

Example
  • -AGP will result in running all steps except -G and -P

Master Data Load - Common

Module Name RSE_MASTER_ADHOC_PROCESS

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Description Run the AI Foundation Cloud Services common master script. This is the first step that should be run once data has been loaded into RI, and is ready to initialize data needed by all the other application modules. Dependencies None Business Activity Initial Data Loads

Design Overview

This process controls the master set of batch programs for loading data into the Retail AI Foundation Cloud Services foundation data tables. This process is generally required as the first step in loading data to any AI Foundation application. It accepts one or more singlecharacter parameters to control which steps in the process are executed. Multiple steps executed in sequence should be passed as one string.

Options:

  • -A Process all steps

  • -R <Option> Resume processing all steps, starting with the step associated with the provided option (see below options for order)

  • -p Product Hierarchy

  • -c CM Group Product Hierarchy

  • -l Location Hierarchy

  • -t Trade Area Location Hierarchy

  • -X Alternate (Flex) Product & Location Hierarchy

  • -d Calendar Hierarchy

  • -r Promotion Hierarchy

  • -g Customer Segment Hierarchy

  • -s Consumer segment data

  • -P Product Attributes

  • -L Location attributes

  • -K Like Location / Product data load

  • -G Customer Segment Attributes

  • -z Price zone ETL

  • -h Holiday data load

  • -i Inventory data load

  • -x Sales transaction data

  • -f Fake customer data load

  • -k Fake customer data identification

  • -w Weekly Aggregate Sales data (Load or Calc)

  • -a Aggregate Sales data processing

  • -F Forecast Aggregate Sales data processing

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

  • -C Price and Cost data load

  • -u UDA load

  • -E Export Group Setup

  • -W Weather Driven Demand data load

  • -T Weekly Return transactions

  • -e Weekly Return Aggregation

  • -S Weekly Sales Return Price Consolidation

  • -m Customer Engagement Attribute

  • -o Forecast Plan Load

  • -b Budget Allocation Load

  • -O Order Cost data Load

  • -n Promotion data Load

  • -D Daily data Load

  • -U Supplier, Supplier Item, Daily Supplier Cost, Supplier Inv Mgmt Load

  • -N Season Phase Item Load

  • -J Rules Engine data for PRO

  • -j Rules Engine data for IO

  • -q Group Flex Load

  • -H Buyer, Allocation, Purchase Order, Transfer Loads

  • -M Forecast Spread Profiles Load

  • -V Forecast Lifecycle Classification Load

  • -I Load Item replacement mapping

  • -v Exit Dates Load

  • -B Baseline Sales and Sku/Store Ranging Calculations

  • -? Display this usage information

Options -A and -R will enable processing of appropriate steps. The A flag indicates to run all steps except the letters following it, while the R flag indicates to resume from the letter following it. Any switch provided more than once, or after a -A or -R will toggle the switch On/Off. This will enable excluding a small number of steps from processing, without requiring specifying all other switches.

Examples:

  • -Act will result in running all steps except -c and -t

  • -Rc -t will result in running all steps starting with c , but excluding step t

  • -pldgxwa will result in extracting the product, location, calendar, customer segment, and sales data from the data warehouse and populating all the core AIF aggregates for sales (this is a common set of load steps for first-time runs)

Additional optional flags may be specified after the sequence of steps is provided, as listed below. Date ranges will apply to any step that extracts historical data, such as sales and inventory loads. If no date range is provided, then the job will attempt to determine the range of dates in the data warehouse and extract that entire range. If a step has already extracted data

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

from the data warehouse once, then you must specify dates on additional runs of that step to ensure only that date range is re-extracted.

  • --alt_prod_hier Run only the alternate (flex) product hierarchy load steps

  • --alt_loc_hier Run only the alternate (flex) location hierarchy load steps

  • --alt_hier_setup Run only the alternate (flex) hierarchy setup steps

  • --prioritizefiles Specifies that data files should be prioritized as the source for a load instead of RI, where it is possible to get data from either source

  • --from Start date of the data processing timeframe. Must be provided in YYYYMMDD format with no spaces. For example --from:20170101 . Must be accompanied by the end date and optionally by the extfrom flag

  • --to End date of the data processing timeframe. Must be provided in YYYYMMDD format with no spaces. For example, --to:20170201 . Must be accompanied by the end date and optionally by the extto flag

  • --extfrom Optional flag to indicate whether the start date must be extended to the start of the week. Accepts Y or N (default). For example, --extfrom:Y , with no spaces

  • --extto Optional flag to indicate whether the end date must be extended to the end of the week. Accepts Y or N (default). For example, --extto:Y , with no spaces

Master Data Load - DT

Module Name Description

DT_MASTER_ADHOC_PROCESS

Run the Demand Transference master script. This is the best way to run all the initial processing steps needed by the DT application module. NOTE: when running through POM, if any — options are required, use : instead of = to separate the option from the value.

Dependencies RSE_MASTER_ADHOC_PROCESS Business Activity Initial Data Loads

Design Overview

This process controls the master set of batch programs for loading data into the Demand Transference application. It accepts one or more single-character parameters to control which steps in the process are executed. Multiple steps executed in sequence should be passed as one string.

Options:

  • -A Process all steps

  • -R <Option> Resume processing all steps, starting with the step associated with the provided option (see below options) for order

  • -r Load Store Sku Ranging Data

  • -l Aggregate Location Ranging Statistics

  • -b Calculate Baseline

  • -i Update model intervals

  • -g Run Group Load

  • -? Display this usage information

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Options -A and -R will enable processing of appropriate steps. Any switch provided more than once, or after a -A or -R will toggle the switch On/Off. This will enable excluding a small number of steps from processing, without requiring specifying all other switches.

Examples

  • -Ab will result in running all steps except -b

  • --from Start date of the data processing timeframe. Must be provided in YYYYMMDD format with no spaces. For example, --from:20170101 . Must be accompanied by the end date and optionally by the extfrom flag

  • --to End date of the data processing timeframe. Must be provided in YYYYMMDD format with no spaces. For example, --to:20170201 . Must be accompanied by the end date and optionally by the extto flag

  • --extfrom Optional flag to indicate if the start date must be extended to the start of the week. Accepts Y or N (default). For example, --extfrom:Y , with no spaces

  • --extto Optional flag to indicate if the end date must be extended to the end of the week. Accepts Y or N (default). For example, --extto:Y , with no spaces

Master Data Load - Forecast Estimation

Module Name PMO_MASTER_ADHOC_PROCESS Description Run the master script for processing forecast input loads and calculations. This is the way to prepare certain inputs for the forecast such as returns and activities tables. Dependencies RSE_MASTER_ADHOC_PROCESS Business Activity Initial Data Loads

Design Overview

This process controls the master set of batch programs for loading data into the Forecasting module which is in addition to the common master data load ( RSE_MASTER_ADHOC_PROCESS ). It accepts one or more single-character parameters to control which steps in the process are executed. Multiple steps executed in sequence should be passed as one string.

Options:

  • -A Process all steps

  • -R <Option> Resume processing all steps, starting with the step associated with the provided option (see below options) for order

  • -a Activities

  • -d Return Data Preparation

  • -c Return Calculation

  • -h Holiday load

  • -o Options Activities

  • -? Display this usage information

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Options -A and -R will enable processing of appropriate steps. Any switch provided more than once, or after a -A or -R will toggle the switch On/Off. This will enable excluding a small number of steps from processing, without requiring specifying all other switches.

The activities load ( -a ) supports date parameters when you are reloading data for a specific historical period. Both parameters should be provided when used.

  • --from Start date of the data processing timeframe. Must be provided in YYYYMMDD format with no spaces. For example --from:20170101 . Must be accompanied by the end date and optionally by the extfrom flag

  • --to End date of the data processing timeframe. Must be provided in YYYYMMDD format with no spaces. For example, --to:20170201 . Must be accompanied by the end date and optionally by the extto flag

Examples
  • -Adh will result in running all steps except -d and -h

-a --from:20210502 --to:20210807 will process the historical activities data between 2021-05-02 and 2021-08-07

Master Data Load - IO

Module Name

Description

IO_MASTER_ADHOC_PROCESS

Run the Inventory Planning Optimization-Optimization master script. This is the best option for running all the initial processing steps needed by the Inventory Planning Optimization-Optimization application module.

Dependencies RSE_MASTER_ADHOC_PROCESS Business Activity Initial Data Loads

Design Overview

This process controls the master set of batch programs for loading data into the Inventory Planning Optimization-Inventory Optimization application. It accepts one or more singlecharacter parameters to control which steps in the process are executed. Multiple steps executed in sequence should be passed as one string.

Options:

  • -A Process all steps

  • -R <Option> Resume processing all steps, starting with the step associated with the provided option (see below options) for order

  • -a Replenishment Attributes at Product/Location or Group level

  • -s Seasons

  • -r Strategy Rules

  • -C Supply chain for Distribution Networks

  • -S Review Schedule

  • -L Lead Time of Internal Locations

  • -P Supply chain for Procurement Networks

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

  • -Q Supplier Review Cycles

  • -T Lead Time of Suppliers

  • -M Internal Order Multiples

  • -m Supplier Order Multiples

  • -l Rounding Levels

  • -I Load IO rules data to rules engine

  • -N Load N-tier interface data to rules engine

  • -? Display this usage information

Options -A and -R will enable processing of appropriate steps. Any switch provided more than once, or after a -A or -R will toggle the switch On/Off. This will enable excluding a small number of steps from processing, without requiring specifying all other switches.

Example

-AaP will result in running all steps except -a and -P

Master Data Load - LPO

Module NamePRO_MASTER_ADHOC_PROCESS
DescriptionRun the Lifecycle Pricing Optimization master script. This is the best
option for running all the initial processing steps for the LPO application
module.
DependenciesRSE_MASTER_ADHOC_PROCESS
Business ActivityInitial Data Loads

Design Overview

This process controls the master set of batch programs for loading data into the Lifecycle Pricing Optimization application. It accepts one or more single-character parameters to control which steps in the process are executed. Multiple steps executed in sequence should be passed as one string.

Options:

  • -A Process all steps

  • -R <Option> Resume processing all steps, starting with the step associated with the provided option (see below options) for order

  • -b Baseline

  • -c Customer Segment Lifetime Value

  • -i Inventory Aggregation

  • -f Lifecycle Fatigue

  • -p Promotion

  • -l Promotion Lift

  • -C Price and Cost for Promotion/Markdown Recommendations

  • -e Price Elasticity

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

  • -L Price Ladder

  • -r Sales Return

  • -s Season

  • -P Season Product

  • -d Season Period

  • -E Markdown Day of Week

  • -y Seasonality

  • -D Model Dates

  • -O Country Locale

  • -F Forecast Adjustment

  • -W Days of Week Profile

  • -u Load Optimization rules for Promotion/Markdown Recommendations (using interface)

  • -G Load Optimization rules for Regular Recommendations (using interface)

  • -M Future Markdowns

  • -U Product Location CDA Flex Facts for Promotion/Markdown Recommendations

  • -g Product Location CDA Flex Facts for Regular Recommendations

  • -n Inventory Aggregation for Regular Recommendations

  • -o Price and Cost for Regular Recommendations

  • -q Activities aggregation for Regular Recommendations

  • -S Load Trailing metrics for Promotion/Markdown Recommendations

  • -Q Load Regular Price Product Packs

  • -? Display this usage information

Options -A and -R will enable processing of appropriate steps. Any switch provided more than once, or after a -A or -R will toggle the switch On/Off. This will enable excluding a small number of steps from processing, without requiring specifying all other switches.

Example

-AbP will result in running all steps except -b and -P

Master Data Load - SO

Module Name SO_MASTER_ADHOC_PROCESS Description Run the Space Optimization master script. This is the best way to run all the initial steps for the SO application module. Dependencies RSE_MASTER_ADHOC_PROCESS Business Activity Initial Data Loads

Design Overview

This process controls the master set of batch programs for loading data into the Assortment & Space Optimization application. It accepts one or more single-character parameters to control

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

which steps in the process are executed. Multiple steps executed in sequence should be passed as one string.

Options:

  • -A Process all steps

  • -R <Option> Resume processing all steps, starting with the step associated with the provided option (see below options) for order

  • -F Assortment Finalization

  • -a Assortment

  • -h Placeholder Product Loading

  • -M Product Cluster mapping

  • -C Assortment product location forecast and price/cost

  • -f Assortment Forecast loading

  • -r Replenishment Parameters

  • -S Product Stacking Height Limit

  • -p Pog Loading

  • -b Bay/Fixture Loading

  • -y Display Style Loading

  • -c Product Fixture Configuration Loading

  • -P Perform Product Attribute maintenance

  • -m Assortment Mapping

  • -v Global Validation

  • -s Assortment to POG mapping

  • -g POG Set location creation

  • -? Display this usage information

Options -A and -R will enable processing of appropriate steps. Any switch provided more than once, or after a -A or -R will toggle the switch On/Off. This will enable excluding a small number of steps from processing, without requiring specifying all other switches.

Example
  • -AaP will result in running all steps except -a and -P

Master Data Load - SPO

Module Name SPO_MASTER_ADHOC_PROCESS Description Run the Size Profile Optimization master script. This is the best way to run all the initial processing steps needed by the SPO application module. NOTE: when running through POM, if any — options are required, use : instead of = to separate the option from the value. Dependencies RSE_MASTER_ADHOC_PROCESS Business Activity Initial Data Loads

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Design Overview

This process controls the master set of batch programs for loading data into the Size Profile Optimization application. It accepts one or more single-character parameters to control which steps in the process are executed. Multiple steps executed in sequence should be passed as one string.

Options:

  • -A Process all steps

  • -R <Option> Resume processing all steps, starting with the step associated with the provided option (see below options) for order

  • -S Season Data Load

  • -r Size Range Data Load

  • -s Size Data Load

  • -p Product Size Data Load

  • -l Sub-Size Range Product Location Data Load

  • -? Display this usage information

Options -A and -R will enable processing of appropriate steps. Any switch provided more than once, or after a -A or -R will toggle the switch On/Off. This will enable excluding a small number of steps from processing, without requiring specifying all other switches.

Example

  • -Ar will result in running all steps except -r

  • --from Start date of the data processing timeframe. Must be provided in YYYYMMDD format with no spaces. For example, --from:20170101 . Must be accompanied by the end date and optionally by the extfrom flag

  • --to End date of the data processing timeframe. Must be provided in YYYYMMDD format with no spaces. For example, --to:20170201 . Must be accompanied by the end date and optionally by the extto flag

  • --extfrom Optional flag to indicate if the start date must be extended to the start of the week. Accepts Y or N (default). For example, --extfrom:Y , with no spaces

  • --extto Optional flag to indicate if the end date must be extended to the end of the week. Accepts Y or N (default). For example, --extto:Y , with no spaces

Product Location Ranging

Module Name DT_PROD_LOC_RANGE_ADHOC Description Refresh Product Location Ranging data for Demand Transference. Dependencies W_RTL_IT_LC_D_JOB (in RI) Business Activity Application Setup

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Design Overview

This process extracts the item/location ranging information from Retail Insights table W_RTL_IT_LC_D . This process is also performed in the DT master batch process, but it can be run on its own if you are modifying the data and need to reload it.

Running this routine requires parameters to specify the start and end date range, for which data should be re-processed from the W_RTL_IT_LC_D table or from AI Foundation sales tables. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Key Tables Affected

TableUsage
W_RTL_IT_LC_DInput
DT_PROD_LOC_LAST_SLSInput
DT_PROD_LOC_STATUSOutput

Promotion Hierarchy Load

Module NameRSE_PL_PROMO_HIER_LOAD_ADHOC_PROCESS
DescriptionLoads promotion hierarchy data into the AIF applications table
RSE_PL_PROMO_HIER.
DependenciesRSE_MASTER_ADHOC_PROCESS
Business ActivityInitial Data Loads

Design Overview

This process populates the promotion hierarchy table RSE_PL_PROMO_HIER outside of nightly batch execution. The table contains the product/location/calendar hierarchy data of promotion offers using a combination of the source tables W_RTL_PROMO_IT_LC_D , W_RTL_PROMO_D , PMO_LLC_PL_ACTIVITIES , RSE_SUPPLIER , and RSE_SUPPLIER_ITEM tables.

This routine accepts a parameter for the forecast run ID using the format:

  • -r FCST_RUN_TYPE_ID

Sales Aggregation – Cumulative Sales

Module NamePMO_CUMUL_SLS_ADHOC_PROCESS
DescriptionCreates aggregate cumulative sales data for Lifecycle Pricing
Optimization.
DependenciesRSE_MASTER_ADHOC_PROCESS
Business ActivityInitial Data Loads

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Design Overview

This process allows the user to execute the cumulative sales aggregation for Lifecycle Pricing Optimization application in an ad hoc manner. When the user creates a new forecast run type, this aggregation is automatically called as part of “Start Data Aggregation”. This requires that sales aggregations have already been performed using the RSE_MASTER ad hoc process, and inventory position/receipts data has already been loaded into the data warehouse and AIF (so that first receipt dates can be used).

Running this process requires parameters to specify the start and end date range for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

The process has the following list of supported options. All job parameters are passed into the PMO_CUMUL_SLS_SETUP_ADHOC_JOB process when invoking it from Postman.

  • -n Number of weeks to process

  • -f Force update of existing data - Y / N (Default)

  • -s Start date yyyymmdd

  • -e End date yyyymmdd

  • -S Start calendar day ID

  • -E End calendar day ID

  • -w Calendar Week ID to process

  • -N New Forecast Run Type Aggregation Flag - Y / N

Key Tables Affected

Table Usage RSE_SLS_PR_LC_CS_WK Input RSE_INV_PR_LC_HIST Input RSE_FCST_RUN_TYPE Input RSE_FCST_DFLT_PARAMETER Input PMO_CUM_SLS Output

Sales Aggregation - Customer Segment

Module Name RSE_WKLY_SLS_CUST_SEG_ADHOC Description Aggregates Sales Transaction data to Weekly Customer Segment Sales tables. Dependencies RSE_SLS_TXN_ADHOC Business Activity Initial Data Loads

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Design Overview

This process aggregates sales data by customer segment for use in AI Foundation applications. The RSE_SLS_TXN_ADHOC job is normally a prerequisite for this, as it is used to refresh or load additional sales data.

Running this process requires parameters to specify the start and end date range, for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Key Tables Affected

TableUsage
RSE_SLS_TXNInput
RSE_CUSTSEG_CUST_XREFInput
RSE_CUSTSEG_SRC_XREFInput
RSE_SLS_PR_LC_CS_WKOutput

Sales Aggregation - Product

Module NameRSE_WKLY_SLS_PR_AGGR_ADHOC
DescriptionCalculates Product-based sales aggregate tables.
DependenciesRSE_WKLY_SLS_ADHOC
Business ActivityInitial Data Loads

Design Overview

This process aggregates sales data by product for use in AI Foundation applications. The RSE_WKLY_SLS_ADHOC job is normally a prerequisite for this, as it is used to refresh or load additional sales data.

Running this process requires parameters to specify the start and end date range, for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Key Tables Affected

TableUsage
RSE_SLS_PR_LC_WKInput
RSE_SLS_PR_WK_AOutput

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Sales Aggregation - Product Attribute

Module Name RSE_WKLY_SLS_PH_ATTR_AGGR_ADHOC Description Calculates Product Attribute-based sales aggregate tables. Dependencies RSE_WKLY_SLS_ADHOC Business Activity Initial Data Loads

Design Overview

This process aggregates sales data by product attribute and product hierarchy levels for use in AI Foundation applications. The RSE_WKLY_SLS_ADHOC job is normally a prerequisite for this, as it is used to refresh or load additional sales data.

Running this process requires parameters to specify the start and end date range, for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Key Tables Affected

Table Usage RSE_SLS_PR_LC_WK Input RSE_PROD_ATTR Input RSE_SLS_PH_ATTR_LC_WK_A Output

Sales Aggregation - Product Hierarchy

Module Name RSE_WKLY_SLS_PH_AGGR_ADHOC Description Calculates Product Hierarchy-based sales aggregate tables. Dependencies RSE_WKLY_SLS_ADHOC Business Activity Initial Data Loads

Design Overview

This process aggregates sales data by product hierarchy levels for use in AI Foundation applications. The RSE_WKLY_SLS_ADHOC job is normally a prerequisite for this, as it is used to refresh or load additional sales data.

Running this process requires parameters to specify the start and end date range, for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Key Tables Affected

Table Usage RSE_SLS_PR_LC_WK Input RSE_SLS_PH_LC_WK_A Output

Sales Aggregation - Weekly

Module Name RSE_WKLY_SLS_ADHOC Description Aggregates Sales Transaction data to week level tables. Dependencies RSE_SLS_TXN_ADHOC Business Activity Initial Data Loads

Design Overview

This process aggregates sales data by product hierarchy levels for use in AI Foundation applications. The RSE_SLS_TXN_ADHOC job is normally a prerequisite for this, as it is used to refresh or load additional sales data.

Running this process requires parameters to specify the start and end date range, for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

-s YYYYMMDD -e YYYYMMDD -f Y

Key Tables Affected

Table Usage RSE_SLS_TXN Input RSE_SLS_PR_LC_WK Output

Sales Forecast Aggregation - Product Attribute (Legacy)

Module Name RSE_SLSFC_PH_ATTR_AGGR_ADHOC Description Calculates Product Attribute-based sales forecast aggregate tables. Dependencies RSE_SLSFC_PH_AGGR_ADHOC Business Activity Initial Data Loads

Design Overview

This process aggregates sales forecast data by product attribute and product hierarchy levels for use in AI Foundation applications. The RSE_SLSFC_PH_AGGR_ADHOC job is normally a prerequisite for this, as it is used to refresh or load additional sales forecast data.

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Running this process requires parameters to specify the start and end date range, for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Note

This is a legacy process which uses a forecast interface from the data warehouse that has been deprecated.

Sales Forecast Aggregation - Product Hierarchy (Legacy)

Module Name RSE_SLSFC_PH_AGGR_ADHOC Description Calculates Product Hierarchy-based sales forecast aggregate tables. Dependencies None Business Activity Initial Data Loads

Design Overview

This process aggregates sales forecast data by product hierarchy levels for use in AI Foundation applications.

Running this process requires parameters to specify the start and end date range, for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Note

This is a legacy process which uses a forecast interface from the data warehouse that has been deprecated.

Sales Shares - Product Attribute

Module Name AC_PROD_ATTR_LOC_SHARE_ADHOC Description Calculate product attribute sales shares for use in Advanced Clustering. Dependencies RSE_WKLY_SLS_ADHOC Business Activity Initial Data Loads

Design Overview

This process aggregates sales shares by product attribute for use in the Advanced Clustering application, specifically for use in clustering by product attribute. The RSE_WKLY_SLS_ADHOC job

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

is normally a prerequisite for this, as it is used to refresh or load additional sales data at week level.

You also must choose which attribute mode is applicable for AC. If it is specified as CDT in RSE_CONFIG property PERF_CIS_APPROACH , then this program will expect additional information for CDT-like attribute groups in RSE_PROD_ATTR_GRP and RSE_PROD_ATTR_GRP_VALUE_MAP . It will also use sales data from RSE_SLS_PH_ATTR_LC_WK_A . For any other configuration, these tables are not required and a more generic approach will be taken.

Running this process requires parameters to specify the start and end date range, for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Key Tables Affected

TableUsage
CIS_TCRITERIA_ATTRInput
CIS_BUS_OBJ_TCRITERIA_ATT_XREFInput
RSE_PROD_ATTR_GRPInput
RSE_PROD_ATTR_GRP_VALUE_MAPInput
RSE_SLS_PH_LC_WK_AInput
RSE_SLS_PH_ATTR_LC_WK_AInput
CIS_PROD_ATTR_LOC_SHAREOutput

Sales Transaction Load

Module NameRSE_SLS_TXN_ADHOC
DescriptionPerforms bulk retrieval of Sales Transaction data.
DependenciesW_RTL_SLS_TRX_IT_LC_DY_F_JOB (in RI)
Business ActivityInitial Data Loads

Design Overview

This process extracts sales transactions from Retail Insights for use in all AI Foundation applications. The W_RTL_SLS_TRX_IT_LC_DY_F table in the data warehouse is the source of this data and the data warehouse must be populated with sales before this program runs.

Running this process requires parameters to specify the start and end date range, for which data should be processed. The -s parameter is for the Start Date and the -e parameter provides the End Date. Both are in format YYYYMMDD . For example:

  • -s YYYYMMDD -e YYYYMMDD -f Y

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

Key Tables Affected

TableUsage
W_RTL_SLS_TRX_IT_LC_DY_FInput
RSE_SLS_TXNOutput

Operations Guide G56397-04 Copyright© 2026, Oracle and/or its affiliates.

In this guide

  • 23 Targeted Items Recommendation — AI Foundation Implementation Guide · shares FCST_RUN_TYPE_ID, PMO_ACTIVITIES, PMO_CUM_SLS, RSE_BUSINESS_OBJECT_ATTR_MD
  • 14 Control and Tactical Center — AI Foundation Implementation Guide · shares ADHOC_JOB, PMO_ACTIVITIES, PMO_ACTIVITY_LOAD_ADHOC_JOB, PMO_ACTIVITY_LOAD_ADHOC_PROCESS
  • 17 Configuration — AI Foundation Implementation Guide · shares ADHOC_JOB, CIS_TCRITERIA_ATTR, FAKE_CUST_DAY_TXN_THRESHOLD, PERF_CIS_APPROACH
  • 7 Customer Segmentation — AI Foundation Implementation Guide · shares CIS_BUS_OBJ_TCRITERIA_ATT_XREF, CIS_TCRITERIA_ATTR

Graph View

Backlinks