You need to populate the planned interface table CMI_PLANNED_INTERFACE to load the profitability data for planned orders, The concurrent program Incremental Margin Load (In-Memory Cost Management) launches the concurrent program Incremental Margin Load for Planned Orders. The entries in the table CMI_PLANNED_INTERFACE are picked up for processing. The columns in this interface to be populated are described in the following table:
| Name | Type | Required? | Description |
|---|---|---|---|
| PLAN_ID | NUMBER | Yes | Identifier for plans. |
| PROCESS_PHASE | NUMBER | Yes | Needs to be set to 1 in order for it to be picked up by the concurrent program Incremental Margin Load (In-Memory Cost Management). |
| ORGANIZATION_ID | NUMBER | Yes | Sales organization identifier. |
| INVENTORY_ITEM_ID | NUMBER | Yes | Inventory item identifier. |
| UOM | VARCHAR2(3) | Yes | Unit of measure of the quantity. |
| GL_DATE | DATE | Yes | Required. The date the order is expected to be shipped. |
| SOLD_TO_CUST_ACCT_ID | NUMBER | No | Sold to customer account identifier, must be a valid customer account in table HZ_CUST_ACCOUNTS. |
| SHIP_TO_CUST_SITE_USE_ID | NUMBER | No | Ship to customer site use identifier, must be a valid site_use_id in the table HZ_CUST_SITE_USES_ALL. |
| BILL_TO_CUST_SITE_USE_ID | NUMBER | No | Bill to customer site use identifier, must be a validsite_use_id in the table HZ_CUST_SITE_USES_ALL. |
| PRIMARY_SALESREP_ID | NUMBER | No | Primary sales representative identifier |
| SALES_CHANNEL_CODE | VARCHAR2(30) | No | Sales channel code. |
| ORDER_NUMBER | NUMBER | No | Order number. |
| ORDER_LINE_NUMBER | NUMBER | No | Order line number |
| HEADER_ID | NUMBER | No | Identifier for the order header from the planning system. |
| LINE_ID | NUMBER | No | Identifier for the order line from the planning system. |
| QUANTITY | NUMBER | Yes | Order quantity in the unit of measure specified. |
| UNIT_PRICE | NUMBER | Yes | Unit price in the currency specified. |
| CURRENCY_CODE | VARCHAR2(15) | No | Currency code of the price. If not populated, the system uses the price of the functional currency of the organization. |
| CONVERSION_TYPE | VARCHAR2(30) | No | Currency conversion type. If not populated, the system uses the currency conversion type specified in profile option CMI: Default Currency Conversion Type. |