1. Implementation Guide
  2. Setup and Configuration
  3. Platform Configurations
  4. C_MODULE_EXACT_TABLE Initialization

C_MODULE_EXACT_TABLE Initialization

The C_MODULE_EXACT_TABLE table is used for defining flexible partitioning strategies on certain tables. Most data in this table can be left as-is, but you must update this table if you plan to load Planning or Budget information into the W_RTL_PLAN1_PROD1_LC1_T1_FS interface. The partition level must align with the data level of your plan (day or week). To configure the plan partitions, you must update the table C_MODULE_EXACT_TABLE where MODULE_CODE = PLAN1. Modify the columns PARTITION_COLUMN_TYPE and PARTITION_INTERVAL to be one of the following values:

  • If your input data will be at Day level, set both columns to DY

  • If your input data will be at Week level, set both columns to WK

You must then enable the partitioning process in C_MODULE_ARTIFACT by locating the row for MODULE_CODE=PLAN1 and setting ACTIVE_FLG=Y and PARTITION_FLG=Y. If your plan data will extend into the future, you must also change PARTITION_FUTURE_PERIOD to the number of future months that need partitions built (for example, use a value of 6M to partition 6 months into the future).