My Oracle Support Banner

How Does Transaction Historical Summary Determine The Unit Cost for Target Date Value? (Doc ID 2815690.1)

Last updated on JULY 15, 2023

Applies to:

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

Goal

How does Transaction Historical Summary determine the unit cost for Target Date value?

Example:

a.Target Date:07-Feb-2020 Quantity:213 Value:1311.02 Value/Quantity:6.1550

b.Target Date:08-Feb-2020 Quantity:215 Value:993.41 Value/Quantity:4.6205

mtl_material_transactions
Transaction_date Transaction_id Prior_cost Creation_date
18-DEC-19 7225802 5.3983 18-Dec-19 08:03:17
02-FEB-20 7330600 6.1550 14-Feb-20 11:26:46
08-FEB-20 7321649 6.1550 10-Feb-20 13:33:18
21-MAY-21 7451195 4.6205 25-May-21 09:17:55

It seems it use prior_cost of the transaction

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!

In this Document
Goal
Solution
References


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