Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Tuesday, January 22, 2013

Oracle Pricing

Defining Price List
1)      Prerequisites before creating a Price List:
a.       Identify the business unit for which price list will be created
b.      Set the proper values of the profiles:
QP: Item Validation Organization  --à Validation Org specific to business unit
QP: Pricing Transaction Entity --à  Order Fulfillment
QP: Source System Code Oracle --à Pricing

2)      Creating a price list
Navigation:
Oracle Pricing Manager or ERC_OM_Super_User  →    Pricing → Price Lists →         Price List Setups
Price line items are:
Product Value
Product Description
UOM
Line Type
Price Break Type
Value
372352000002
Tinplate_Tins_10 Ltr_Hayat__Square_
Ea
Price List Line

138.6
372352000003
Tinplate_Clips_____
Ea
Price List Line

151.8
372352000004
Tinplate_Tins_5 Kg_Hayat__Ghee_
Ea
Price List Line

158.4
320930000002
Vegetable_Oil_Hayat_1x_18_ltr_Tin
Ea
Price List Line

188.8
372352000001
Tinplate_Tins_18 Ltr_Hayat__Square_
Ea
Price List Line

184.8
320930000004
Palmolein_Deodorised_Loose___IV56_
MT
Price Break Header
Point

320930000006
Palm Oil_Refined_Loose____
MT
Price List Line

100





Copy the Price List
Create two price lists XXIFF_ERC_RMPMFG_01_COPY_01 & XXIFF_ERC_RMPMFG_01_COPY_02
by copying the price list XXIFF_ERC_RMPMFG_01.
Navigation:
Oracle Pricing Manager or ERC_OM_Super_User  →    Pricing → Price Lists →         Copy Price List



Adjust the Price List
Navigation:
Oracle Pricing Manager or ERC_OM_Super_User  →    Pricing → Price Lists →         Adjust Price List
Increase the price of all the items by 10%


Add new item to the Price List
Navigation:
Oracle Pricing Manager or ERC_OM_Super_User  →    Pricing → Price Lists →         Add Item to Price List
Add Item 320930000006 to the price list.

Price List Maintenance
Navigation:
Oracle Pricing Administrator ----à Price List Maintenance
Price list can be modify as Bulk and detail.
Detail maintenance is done at each price line item level where bulk will be done for the entire price list.

Detail price maintenance:

Bulk price maintenance:


Secondary Price list
Secondary price list is used for pricing the items whose price is not defined in primary price list.
A Primary price list can have multiple secondary price list associated with it.

Navigation:
Oracle Pricing Manager or ERC_OM_Super_User ---à Pricing ---à Price Lists ----àPrice List Setups
Attach XXIFF_ERC_RMPMFG_01_COPY_01 and XXIFF_ERC_RMPMFG_01_COPY_02 as secondary price list to the XXIFF_ERC_RMPMFG_01 price list.

Price list Precedence
In case same item is defined in two secondary price list that price list with lower precedence value will be picked for pricing the item. In case the price list precedence value is same that price list item level precedence will be picked for pricing the item. In case Price List precedence and Price list line level precedence is same that least price will be picked for pricing the item at sales order. 
Navigation:
Oracle Pricing Manager or ERC_OM_Super_User ---à Pricing ---à Price Lists ----àPrice List Setups



Price Promotions

Discount Promotion: A order line item level and Order level discount are defined where order level discount will be applied for specific customer but order line level is for specific item.
Navigation:
Oracle Pricing Manager or ERC_OM_Super_User ---à Pricing ---à Modifier
Qualifier is defined for order level discount promotion

Order created for different customer so, order level promotional modifier can’t be applied since, order doesn’t
Qualify the qualifier condition.
Surcharge Promotion:
Surcharge of amount 5 is applied for a particular line item.

Promotional Good:
FOC item will be given for purchase of a particular item
 

1 comment:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect