C_MODULE_ARTIFACT Initialization

The C_MODULE_ARTIFACT table is used by the database to configure table partitioning. Many tables in the platform are partitioned based on the business calendar (usually by calendar date or fiscal week) and this partitioning must be performed immediately after the business calendar is loaded. You should perform this step regardless of which application modules you are implementing, because all foundation data passes through this architecture.

Before running partitioning procedures, you must validate this table has all rows set to ACTIVE_FLG=Y and PARTITION_FLG=Y with the exception of W_RTL_PLANFC* tables (PLANFC module) and SLSPRFC module, which should not be partitioned at this time and must have flag values of N instead.

You also must choose whether you are planning to load the Planning facts (such as W_RTL_PLAN1_PROD1_LC1_T1_FS) for plan/budget data in RI or AI Foundation. If you are not using the table right away, you should also disable the PLAN modules, like PLAN1. You can revisit this setup later to perform additional partitioning as needed.