Posts filed under 'Advanced Pricing'
In my last Qualifier article, I delved into the inner workings of Qualifiers in Advanced Pricing by walking through a quick demo of how to setup a Qualifier to reference Descriptive Flexfield data on a sales order transaction. In this article, I’d like to touch on how some Qualifiers require more advanced PL/SQL techniques to retrieve transactional data. For example, the “Customer Party ID” is tied to QP_SOURCING_API_PUB.GET_PARTY_ID function call because the Party ID isn’t stored directly in the G_HDR record structure. With that said, lets walk-thru the creation of a Qualifier that requires us to create our own PL/SQL function reference…
Continue Reading September 12th, 2008
Oracle Advanced Pricing allows you to create discounts, surcharges, and other promotions (called Modifiers) that can be applied against sales orders both manually and automatically. Often there are requirements for Modifiers to only apply in certain situations. For example, promotions on specific products or product lines, discounts on customer types, additional charges on international shipments, etc. So in addition to creating Modifiers, Qualifiers can be used to reference specific attributes of a sales order, product, customer, etc. to determine if the Modifier qualifies for the sales transaction.
Oracle provides a wide array of Qualifiers to evaluate a sales transaction, but situations often arise where Qualifiers are needed for attributes that aren’t available out of the box. However, with a few configurations and little bit of PL/SQL knowledge, you can create your own Qualifier attributes.
Continue Reading July 21st, 2008
One of the fundamental flaws in Oracle Order Management (OM) is the inability to include tax on freight and special charge modifiers that are setup in Advanced Pricing (QP). There’s just no way to do it out of the box. Even if you use the Oracle suggested work around, which is to add freight as a line item to a sales order, it’s still a manual process and defeats the purpose of being able to include and calculate freight automatically the way you can through a charge modifier.
Continue Reading February 29th, 2008
A recent encounter that my current client experienced exemplifies why any corporation of global stature should implement an organized pricing policy…
Continue Reading December 15th, 2006
So you work for a global corporation. Your company has operations in the US, Canada, Europe, Asia Pacific, Latin America, etc. The marketing division for your company states that they offer products and services at competitive prices – but do they really know? And while offering competitive prices, your company also states that margins are realized to the max at a global scale – but can they prove this? What are they basing their marginal goals on? And are these goals consistent across your organization globally?
These can be tough questions to answer depending on the pricing policies your company enforces. Surprisingly, many of today’s global corporations still manage pricing of their products and services independently at a regional level. Even companies that are running a global ERP system have implemented their pricing strategy in this fashion…
Continue Reading July 28th, 2006
