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