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. |