Attention: To align with new corporate security policies, and to match policies adopted by other communities within Oracle, the My Oracle Support Community access requirements will change beginning September 18, 2025. MOSC will now require that member accounts in our community be associated to a *corporate* email address. This means that users with generic domains (such as gmail.com, yahoo.com, and others) will no longer be granted access to the discussion forums and ideas labs. If this policy affects you, act now to change the email address that is associated with your Oracle (and community) account. Alternatively, you can opt to create a new Oracle account that uses your corporate email domain.

Advanced Pricing - EBS (MOSC)

ER : GET CUSTOM PRICE in formula doesn't evaluate Simulation_flag from qp_preq_lines_tmp

Sep 11, 2017 5:10AM edited Jun 15, 2018 5:01AM in Advanced Pricing - EBS (MOSC) 1 commentAnswered

We use QP for OM module (and its Off-Invoice Offers) and for OZF module (and its Rebates Offers).

For one "Off-Invoice" offer, we use a formula that call the function GET CUSTOM PRICE with 2 objectives

to determine a rate for the offer
to write a record in a custom table (depending the rate determined in 1)).

When we launch the QP engine during the OM order life cycle (simulation flag = No), the 2 objectives are satisfied.

When we launch the QP engine during the OZF offer life cycle(simulation flag = Yes),

the formula is called,
the objective 1 (rate for the offer) is not applied due to the simulation flag = Yes

0

Howdy, Stranger!

To view full details, sign in to My Oracle Support Community.

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month