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 the MSC_MEASURE_DATA table and don't have error information.

• The table filters records by the applicable security privileges of the user. For example, if you have 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
  • Supply Chain Planning Causal Factors
  • Supply Chain Planning Forecast Measures
  • Supply Chain Planning Measures
  • Supply Chain Planning Option Bookings History
  • Supply Chain Planning Option Shipments History
  • Supply Chain Planning Shipments History
• The table doesn’t display measure data that’s imported through the Supply Chain Planning External Forecasts and Supply Chain Planning Price Lists FBDI templates.

  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 Suite or imported from Oracle E-Business Suite.
• To view aggregated non-key customer data in the table for demand, demand and supply, and sales and operations plans, before collecting or importing measure data, select the Aggregate non-key customer data to an All Other level member check box on the Demand tab on the Plan Options page for the plan. Then, enter the required aggregation levels in the Supply Chain Planning Key Customer Options FBDI template, and import customer data with the template. After you collect or import measure data, when you filter your records by the plan name in the table, you can view the aggregated data for non-key customers. For aggregated records, the value displayed in the Customer column is “<zone name>: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.