13/15
Interfaces for In-Memory Cost Management
Incremental Margin Load for Planned Orders Interface
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:
| 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. |
Supply/Demand Interface for Cost Planning
Populate the interface table CMI_CP_SUPPLY_DEMAND_IFACE to upload cost planning information to the production or demand plan. Use the concurrent program Import Supply/Demand for Cost Planning (Discrete) to populate this table. The entries in the table CMI_CP_SUPPLY_DEMAND_IFACE are picked up for processing. Any errors during processing are stored in the table CMI_CP_SUPPLY_DEMAND_ERRORS. The columns in this interface to be populated are described in the following table:
CMI_CP_SUPPLY_DEMAND_IFACE Table Columns
| PLAN_NAME |
VARCHAR2(30) |
Yes |
Name of the cost plan. |
| PROCESS_PHASE |
NUMBER |
Yes |
Needs to be set to 1 in order for it to be picked up by the concurrent program Import Supply/Demand for Cost Planning (Discrete). |
| PLAN_TYPE |
VARCHAR2(30) |
Yes |
Type of plan. Enter either a production or demand type plan. |
| ORGANIZATION_ID |
NUMBER |
Yes |
Sales organization identifier. |
| ITEM_ID |
NUMBER |
Yes |
Inventory item identifier. |
| PLANNED_QTY |
VARCHAR2(3) |
Yes |
Planned quantity |
| PLANNED_DATE |
DATE |
Yes |
Required. The date the order is planned. |
| UNIT_OF_MEASURE_CODE |
VARCHAR2(30) |
No |
Unit of measure of the planned quantity. |
| PLANNED_QTY |
NUMBER |
Yes |
Planned 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. |
| CURRENCY_CONVERSION_DATE |
DATE |
No |
Currency conversion date. If not populated, the system uses the system date. |
CMI_CP_SUPPLY_DEMAND_ERRORS Table Columns
| PLAN_NAME |
VARCHAR2(30) |
Yes |
Name of the cost plan. |
| PROCESS_PHASE |
NUMBER |
Yes |
Needs to be set to 1 in order for it to be picked up by the concurrent program Import Supply/Demand for Cost Planning (Discrete). |
| PLAN_TYPE |
VARCHAR2(30) |
Yes |
Type of plan. Enter either a production or demand type plan. |
| ORGANIZATION_ID |
NUMBER |
Yes |
Sales organization identifier. |
| ITEM_ID |
NUMBER |
Yes |
Inventory item identifier. |
| PLANNED_QTY |
VARCHAR2(3) |
Yes |
Planned quantity |
| PLANNED_DATE |
DATE |
Yes |
Required. The date the order is planned. |
| UNIT_OF_MEASURE_CODE |
VARCHAR2(30) |
No |
Unit of measure of the planned quantity. |
| PLANNED_QTY |
NUMBER |
Yes |
Planned 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. |
| CURRENCY_CONVERSION_DATE |
DATE |
No |
Currency conversion date. If not populated, the system uses the system date. |