1. Implementing Procurement
  2. Attributes to Create Reports and Analytics on External Cost Factors Using OTBI

Attributes to Create Reports and Analytics on External Cost Factors Using OTBI

You can create reports for external cost factors in the Oracle Transactional Business Intelligence (OTBI) application. The external cost factors attributes are available within these subject areas:

  • Supplier Negotiations Real Time: Navigate to the folder Negotiation Line, then Negotiation Line Detail, and then Negotiation Line Cost Factors.

  • Supplier Responses Real Time: Navigate to the folder Response Line, then Response Line Detail, and then Response Line Cost Factors.

  • Supplier Awards Real Time: Navigate to the folder Award Details, then Award Line Detail, and then Award Line Cost Factors.

The Response and Award subject areas include:

  • Target Value (Negotiation Currency) - Value the category manager expects for a cost factor from the supplier's response. If the pricing basis is fixed amount or per unit, then the value uses the negotiation currency.

  • Response Value (Response Currency) - Value for the cost factor provided by the supplier. If the pricing basis is fixed amount or per unit, then the value uses the supplier's response currency.

  • Response Value (Negotiation Currency) - Value for the cost factor provided by the supplier. If the pricing basis is fixed amount or per unit, then the value uses the negotiation currency.

The metric available are as follows:

  • Target Cost Factor Amount - The amount expected in the supplier's response for the external cost factor. It is calculated based on a cost factor's pricing basis. You can roll up this amount for the line, the negotiation, or aggregate across procurement BUs for each cost factor.

    Target Cost Factor Amount (Line) = Target Value (per unit) X Line Quantity + Target Value (% of line price) X Line Target Price X Line Quantity + Target Value Fixed Amount

  • Response Cost Factor Amount - The amount provided by the supplier in their response for the cost factor. It's calculated based on a cost factor's pricing basis. You can roll up this amount for the line, or the response and compare it across supplier responses during award analysis. You can also aggregate the cost factor amount for the awarded supplier responses to determine negotiated external costs.

    Response Cost Factor Amount (Response Line) = Response Value (per unit) X Line Response Quantity + Response Value (% of line price) X Line Response Price X Line Response Quantity + Fixed Amount Response Value