My Oracle Support Banner

Why Account Alias Receipt trans created thru interface tables MTI/MTLI/MTCDI was not generating Average Cost for Elements? (Doc ID 2398441.1)

Last updated on MAY 22, 2018

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

On : 12.1.3 version, Inventory Transactions

Account Alias Receipts inserted into MTI/MTLI/MTCDI interface tables  were not creating average cost for elements

Creating inventory quantities by inserting data into 3 tables:

MTL_TRANSACTIONS_INTERFACE
MTL_TRANSACTION_LOTS_INTERFACE
MTL_TXN_COST_DET_INTERFACE

The goal was to record the average cost by elements.

Using Material, Material Overhead, and Resource  cost elements.


After inserting  the details to the interface tables, the records were processed by the inventory module, but, only the Material cost element contains an average cost. The other elements were null.

The work around is to do an Average Cost Update for the three elements before importing the inventory item for the first time.

 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.