Search from 700 + Posts

Feb 3, 2018

Calculate Price Flag in Oracle Order Management

 Calculate Price in Oracle Order Management

The Calculate Price flag allows the calling application to fully or partially freeze the price on a pricing request line. Price may be completely frozen with no additional modifiers applied, or additional modifiers may be applied in certain phases, depending on the value of the flag. Possible values are as follows:



Flag Value
Action
Y (calculate price)
Applies all prices and modifiers to the request line.
N (freeze price)
Does not apply any prices or modifiers to the request line.
P (partial price)
Only applies prices or modifiers in certain phases.


When the calculate price flag is set to partial price, the search engine observes the freeze override flag on the phase

When the calculate price flag is set to yes the search engine applies eligible modifiers in the phase to the request line. 

When the calculate price flag is set to no the modifiers in the phase are not considered for application to the request line. 

Additional Details : 

Calculate Price Flag: Calculate Price: Use the pricing engine to determine price. Calculate price and freight charges at the time of pricing. 

Freeze Price: Never use the pricing engine to determine price. Do not calculate price or freight charges. 

Partial Price: Use the pricing engine to determine price. Calculates only freight charges at the time of pricing.

If you split an order line into multiple lines and want to retain the original price on both the original line and new lines, change your Calculate Price Flag to either Freeze Price or Partial Price before initiating a user split.



The following table shows the value of the Calculate Price Flag before and after a user or system initiated split.

Calculate Price Flag before and after a User or System-initiated Split
Calculate Price FlagOriginal Line before split: Calculate PriceOriginal line before split: Partial PriceOriginal line before split: Freeze Price
Original line after user initiated splitCalculate PricePartial PriceFreeze Price
New line after user initiated splitCalculate PricePartial PriceFreeze Price
Original line after system initiated splitPartial PricePartial PriceFreeze Price
New line after system initiated splitFreeze PriceFreeze PriceFreeze Price


 This query will provide the name of pricing phases that have freeze_override enabled.

select pricing_phase_id, name, 
        freeze_override_flag, user_freeze_override_flag
from qp_pricing_phases
where (freeze_override_flag = 'Y' and user_freeze_override_flag is null)

or user_freeze_override_flag = 'Y';



7 comments:

  1. Hi,
    I was very encouraged to find this site. I wanted to thank you for this special read.

    Thanks
    Prices freezers

    ReplyDelete
  2. Your blog is so nice, and the article is very good it helps to so many people.
    Oracle Financials Training in Ameerpet, Hyderabad

    ReplyDelete
  3. Nice blog sir, thanks for sharing. For more information please visit our website.
    Oracle Fusion Financials Training in Hyderabad

    ReplyDelete
  4. Thanks for sharing this Informative content. Well explained. Got to learn new things from your Blog. Oracle R12 Financials Training in Hyderabad

    ReplyDelete
  5. Hi,

    We are trying to update Qty and Price using the ASO_QUOTE_PUB.Update_Quote API. When we have the CALCULATE_PRICE_FLAG = Y and updating the QTY, the price is auto adjusted to 100% discount.

    Pls suggest if there is a solution to this with profile option or code changes.

    Regards,
    Sridhar

    ReplyDelete
  6. Impartial and fair blog, making it pleasurable for the gathering of people to peruse.
    warranty tracking database

    ReplyDelete