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:
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:
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.
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';
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 | Original Line before split: Calculate Price | Original line before split: Partial Price | Original line before split: Freeze Price |
|---|---|---|---|
| Original line after user initiated split | Calculate Price | Partial Price | Freeze Price |
| New line after user initiated split | Calculate Price | Partial Price | Freeze Price |
| Original line after system initiated split | Partial Price | Partial Price | Freeze Price |
| New line after system initiated split | Freeze Price | Freeze Price | Freeze 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';
Need help with EBS Forms/Reports/Workflow/Interface? Contact Bizinsight at
inquiry@bizinsightinc.com
https://www.bizinsightinc.com/
