This article can be downloaded from
http://www.apps2fusion.com/training_demo/ranu/om/advanced_pricing_om.pdf
Topics covered in this article are:-
Overview of Pricing
Pricing flow & Example
Qualifiers and Qualifier Groups
Modifiers
Defining Modifiers
Pricing Organizer
Promotional Limits
Formulas
Price Lists
Archiving and Purging Pricing Entities
Multi-Currency Conversion Lists
Pricing Agreements
Deleting agreements
Comments
Greetings to you from VOLEN SOFTWARE SERVICES. We currently have requirements with KBACE TECHNOLOGIES Leading MNC.
looking for professional on Oracle HRMS Technical consultant .while going through your site i have seen many HRMS professionla who have been placed by us in Kbace .like to know if anyone working on HRMS would be interested
plea se reply if interested
than ks and regards
sadikhavolensoftware.com
As I downloaded the articles, There was some error and I was not able to open. I tried once again but again the same problem. I am dying to get these documents because whatever you provide are the best.
Thanks
There are some foriegn characters in the pdf, which will give some error, but those errors can be ignored.
********* *************** ***********
LE VEL MODIFIER TYPE PRODUCT ATTRIBUTEPRODUC T ATTRIBUTE VALUE
--------- --------------- --------------- --------------- --------------- --------------- -------------
G ROUP OF LINESPROMOTIONA L GOODSALL ITEMS ALL
DEFINE DETAILS->
ADDI TIONAL BUY ITEMS
ITEM-A
IT EM-B
GET ITEM
ITEM-C
== =============== =============== =============== =============== =============== =============== =
SALES ORDER
--------- --------------- --------------- --------------
ITEM-GEN (Which has no modifier)ORDERE D ITEM
ITEM-AORDE RED ITEM
ITEM-BORDE RED ITEM
ITEMC-C ->ITEM ADDED BY PRICING ENGINE AS A FREE ITEM
IF WE SEE THE ADJUSTMENT DETAILS IN OE_PRICE_ADJUST MENTS TABLE
WE CAN SEE THREE RECORDS LIST_LINE_TYPE_ CODE AS 'PRG'
ITEM-GEN -PRG
ITEM-A -PRG
ITEM-B -PRG
ITEM-C -DIS
ACTUALLY ITEM-GEN IS NO WHERE RELATED TO THIS MODIFIER PRG
THIS IS PRG ONLY BECAUSE OF THE SETUP AS GROUP OF LINES ALL ITEMS.
MY REQUIREMENT IS I NEED TO CONSIDER ONLY THE BUY ITEMS i.e ITEM-A,ITEM-B
H ow can I filter out ITEM-GEN from sales order
Actually it has no modifer but has a price adjustment record because of ITEM-A,ITEM-B
However, I need this modifier to work off a price list - ie if you buy 6 of any item on the price list, you get one free.
anyone have any ideas?
Thanks
I have read your document...its really useful.Thank you.
Now,i have one requirement as below.
Client:L ogistics Company
Modules Implemented:OM, AR,AP,Purchasin g,GL...running smoothly.
Scen ario:
A)Busines s Process:
Generally, customer goods will be split and sent in different trains. Then, for same destination & quantity we will get different amount.
Note: Calculation done by Railways based on variable factors (like penalty charges for over weight or under weight).
So everyday, every bill have different amount for same quantity and destination will be computed and given by railways.
B) Current Process in Oracle:
End user will select item and enter manually.
C) Client Requirement:
Needs to create single item with multiple prices
Note: Item code and price list should be constant due to business requirement.
I just wondering,how the financial companies deals with this kind of scenario..when there is fluctuation of prices everyday....
Kindly do the needful.
Thanks for the interesting article.
We are implementing for an agent who sells ORE (Iron, Manganese, Chrome, etc.) on behalf of a mine. The ORE has various size and chemical characteristics which alter the price. These can change during the transportation process, so get measured at the start and end of the process. Would we use "modifiers" to manage this process?
kind regards,
Shaun
can anybody provide me the template to load qualifier and modifier....
Thanks,
Mital i
Tks very much for post:
I like it and hope that you continue posting.
Let me show other source that may be good for community.
Sou rce: Pricing analyst interview questions
Best rgs
David
My ordered item is having an promotional item for 50% off price. If customer does'nt want that item for any cost. how this scenario could be handled.
Note: Order source is not oracle. Its an third party application which wont get any call back from oracle as promotional item exists. More order if its a new customer i cannot exclude this customer in qualifiers in prior.
Please let me know what would be the alternate solution.
We want to configure a promotion in below manner. Pl suggest how we can do this in Oracle Advanced Pricing
Scenario :
Qualifying Items A or B or C
Benefit : If net ordered qty for above qualifying product is between 100 – 199, then get 3 qty of D free.
else If net ordered qty for above qualifying product is between 200 – 299, then get 6 qty of D free.
else If net ordered qty for above qualifying product is between 300 – 399, then get 9 qty of D free.
else If net ordered qty for above qualifying product is between 400 – 499, then get 12 qty of D free.
else If net ordered qty for above qualifying product is between 500 – 999, then get 15 qty of D free.
else If net ordered qty for above qualifying product is between 1000 – 1999, then get 60 qty of D free.
else If net ordered qty for above qualifying product is between 2000 – 2999, then get 130 qty of D free.
We have a modifier with pricing formula for calculating an adjustment for return orders based on prorated % calculation which is working fine now would like to add another additional modifier on top the existing one to calculate some % discount for the calculated amount.. For Example ( Discount calculated for a product as 25% (Unit Price : 50 so, 25% of 50 is 12.5) now have to calculate another 10% for 12.5.. Could you please suggest and advise..
RSS feed for comments to this post