You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Unable to Extract External Cost Factor (ECF) Values for Supplier Responses Using SQL

Summary:
We need Oracle to confirm the official and supported method to extract External Cost Factor (ECF) values for supplier responses, specifically the REST API endpoint that returns the same ECF values shown in the Negotiation Response UI.

We are trying to retrieve External Cost Factor (ECF) values entered by suppliers during a Negotiation. These values appear correctly in the Negotiation Response UI, but we cannot extract them through SQL or BI Publisher.

We initially queried the standard sourcing tables such as:

  • PON_PRICE_ELEMENTS
  • PON_BID_ITEM_PRICES
  • PON_PRICE_ELEMENT_TYPES_B/TL
  • PON_AUCTION_ITEM_PRICES_ALL

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!