Oracle Cost Management

Cost Management

Cost Type Comparison Report -  Run to review the differences in your item costs by cost type. You should run this report in preparation for a standard cost update, as a means to find large or erroneous differences.

Parameters:

Cost Type1 -->

Cost Type2 -->

Issue #1: Cost Type fields are disabled / grayed out / LOV not enabled 

Resolution: Functionality is set for program to run from Cost Management-->Report-->Cost-->Item Costs Report

Alternate Navigation --> Cost:Report:Cost:Item

Issue #2: BOM or ECG error

Resolution: Same resolution as for issue #1 above.

Tables Info - Cost Management

CST_ITEM_COSTS

• Inventory_Item_ID
• Cost_Type_ID
• Organization_ID
• Item_Cost

CST_ITEM_COST_DETAILS

• Inventory_Item_ID
• Cost_Type_ID
• Cost_Element_ID
• Organization_ID
• Item_Cost

Interfaces

Inventory

• Item Import
  
  
  
  
  

Legacy System --> Mtl_System_Items_Interface --> Item Import Program --> Mtl_System_Items_B (or Mtl_Interface_Errors)

• Material Transactions

Interface Tables to be used are:
MTL_TRANSACTIONS_INTERFACE
MTL_TRANSACTION_LOTS_INTERFACE
MTL_SERIAL_NUMBERS_INTERFACE

Transaction Type ID should be 2 (for "Subinventory Transfers") and "Material Transactions Manager" will process the records from the Interface tables.

If there are any errors while processing, the details of the errors will be available in MTL_INTERFACE_ERRORS table.

Cost Management

• Item Cost Import

Sample insert statement to populate the Item Cost Interface table

INSERT INTO CST_ITEM_CST_DTLS_INTERFACE
(INVENTORY_ITEM_ID
,ORGANIZATION_ID
,COST_TYPE_ID
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN
,Process_Flag
,Item_Cost
,Cost_Element_ID
,USAGE_RATE_OR_AMOUNT
)
SELECT INVENTORY_ITEM_ID
,ORGANIZATION_ID
,COST_TYPE_ID
,SYSDATE
,1441
,SYSDATE
,1441
,14411441
,1
,5
,1
,5
from cst_item_costs where inventory_item_id = 13433714 --12456335
AND Cost_Type_ID = 3

Payables

• Invoice Import

Interface Tables
AP_INVOICE _INTERFACE is the header info
AP_INVOICES_LINES_INTERFACE is the lines table.

RUN PAYABLES INVOICE IMPORT CONCURRENT PROGRAM

Base Tables
AP_INVOICE_ALL is also the header information is stored.
AP_INVOICES_DISTRIBUTIONS_ALL is the lines information table.
AP_PAYMENTS_SCHEDULES_ALL (AMOUNT_REMAINING stores balance amount to be paid)
AP_INVOICE_PAYMENTS_ALL (INVOICE_ID)
AP_CHECKS_ALL (CHECK_ID)

AP_INTERFACE_REJECTIONS (REJECT_LOOKUP_CODE stores the error occurred during the invoice import ex: account required, invalid supplier site )