1. Implementation Guide
  2. Data Loads and Initial Batch Processing
  3. Sending Data to Planning
  4. Usage Examples

Usage Examples

The following examples show how to leverage the PDS extract processes to move data from the data warehouse tables to the PDS staging tables, where the data can be picked up by the Planning applications.

Scenario 1: Initial Dimension Extract

  1. Perform the initial loads into the data warehouse as described in the section Initialize Dimensions.

  2. Enable all jobs in the ad hoc process LOAD_PDS_DIMENSION_PROCESS_ADHOC and execute it.

  3. Verify that data has been moved successfully to the target tables, such as W_PDS_CALENDAR_D, W_PDS_PRODUCT_D, and W_PDS_ORGANIZATION_D.

Scenario 2: Initial Sales Extract

  1. Perform the initial sales loads into the data warehouse as described in the section Sales History Load.

  2. Enable the job W_PDS_SLS_IT_LC_WK_A_JOB in the ad hoc process LOAD_PDS_FACT_PROCESS_ADHOC and execute the process.

  3. Verify that data has been moved successfully to the target tables W_PDS_SLS_IT_LC_WK_A and W_PDS_GRS_SLS_IT_LC_WK_A.

  4. Repeat the same steps for any other transactional history loads, such as adjustments, transfers, and RTVs (using the appropriate PDS job as described in the prior section).

Scenario 3: Initial Inventory Extract

  1. Perform the initial inventory loads into the data warehouse as described in the section Inventory Position History Load.

  2. Open the C_SOURCE_CDC table in Manage System Configurations and locate the row for W_RTL_INV_IT_LC_WK_A. Edit the values in the LAST_MIN_DATE and LAST_MAX_DATE columns to fully encompass your range of historical dates in the inventory history.

  3. Enable the job W_PDS_INV_IT_LC_WK_A_INITIAL_JOB in the ad hoc process LOAD_PDS_FACT_INITIAL_PROCESS_ADHOC and execute the process.

  4. If the job fails with error code “ORA-01403: no data found,” it generally means that the dates in C_SOURCE_CDC are not set or do not align with your historical data. Update the dates and re-run the job.

  5. Verify that data has been moved successfully to the target table W_PDS_INV_IT_LC_WK_A.

Scenario 4: Updated Data Extracts

  1. Load additional history data as required for the project. For example, you may have started with one month of data for testing and are now going to load an additional 2 years of data.

  2. If the C_LOAD_DATES_CLEANUP_ADHOC process was not run at the start of your current data load, run it now to ensure there are no previous run statuses from past PDS export runs that will interfere with new runs.

  3. Run LOAD_PDS_DIMENSION_PROCESS_ADHOC to ensure the dimensions for PDS are in sync with the new history data being loaded.

  4. Review C_SOURCE_CDC and alter the minimum/maximum dates on each table, if required. If you want to re-push your entire history for a fact, including the previously loaded data, then you will need to adjust the dates before running the extracts.

  5. Run LOAD_PDS_FACT_PROCESS_ADHOC for all the facts, such as sales and receipts, that have had new history loaded in the data warehouse.

  6. Run LOAD_PDS_FACT_INITIAL_PROCESS_ADHOC to pull the desired range of inventory periods.

  7. Verify the target tables contain the expected data before starting the import into Planning applications.