1. Using Supply Chain Planning Common Features
  2. Additional Points About the Collected Measure Data Table

Additional Points About the Collected Measure Data Table

These are some additional points about the Collected Measure Data table:

  • The table displays records that are successfully uploaded to the MSC_MEASURE_DATA table.
  • For records with errors, the table displays records from the MSC_ST_MEASURE_DATA staging table that have information in the ERROR_TEXT column.

    The table doesn't display records from the staging table that weren't moved to MSC_MEASURE_DATA and don't have error information.

  • The table filters records by the applicable security privileges of the user. For example, if you've access to only certain organizations, you can view measure values for only those organizations.
  • The table lists both predefined and user-defined measures.
  • The table displays measure data that’s imported through these file-based data import (FBDI) templates:
    • Supply Chain Planning Bookings History (ScpBookingHistoryImportTemplate.xlsm)
    • Supply Chain Planning Causal Factors (ScpCausalFactorsImportTemplate.xlsm)
    • Supply Chain Planning Forecast Measures (ScpForecastMeasureImportTemplate.xlsm)
    • Supply Chain Planning Measures (ScpMeasuresImportTemplate.xlsm)
    • Supply Chain Planning Option Bookings History (ScpOptionBookingHistoryImportTemplate.xlsm)
    • Supply Chain Planning Option Shipments History (ScpOptionShipmentHistoryImportTemplate.xlsm)
    • Supply Chain Planning Shipments History (ScpShipmentHistoryImportTemplate.xlsm)
  • The table doesn’t display measure data that’s imported through the import templates named Supply Chain Planning External Forecasts (ScpExternalForecastImportTemplate.xlsm) and Supply Chain Planning Price Lists (ScpPriceListImportTemplate.xlsm).

    To troubleshoot imported data for external forecasts or price lists, examine the log files or run your plan.

  • The table also displays any measure for which information is collected from Oracle Fusion Cloud Applications or loaded from Oracle E-Business Suite.
  • For demand, demand and supply, and sales and operations plans in which you're using the functionality for aggregating data for non-key customers, for aggregated records, the value displayed in the Customer column is <zone name>:All Other or Default:<All Other>.
  • The table doesn't return aggregated data for a planning level profile.
  • To avoid reduced performance, don’t sort the records if you increase the maximum number of records displayed in the table by creating and using a profile option with the MSC_COLLECTED_MEASURE_DATA_MAX_ROWS code.

Related Topics