Wednesday 29 July 2015

Item Code as Qualifier and Percentage Discounts based on Item Code


Item Code as Qualifier in Advanced Pricing

Business Case:  

A World leading soft drinks manufacturer in Vietnam likes to implement Advance Pricing to incorporate promotion, Deal and Discount for their customers.  The customer would like to offer a discount based on an item procured by the customer.  
Ex:   Provide 7% Discount if the Customer buys Product X.

Issue:

A line level qualifier based on item code is required to identify the eligible line to provide required discount. However, Standard Oracle does not have Item as a Qualifier.  

Resolution:

To achieve the solution perform below setups in Oracle Advanced Pricing
  1. Define “Item Code” in Qualifier Context
  2. Map the Qualifier Context and Qualifier Attribute
  3. Link Attribute with  Advance Pricing Application
  4. Run Build Attribute Mapping Concurrent Program
  5. Create the Qualifier using Item Code
  6. Define Modifier and Map  Item  Qualifier
  7. Run “QP: Maintains the denormalized data in QP Qualifiers” Concurrent Program
This document clearly explains the required setup in screen shots to achieve desired solution along with example.
Define “Item Code” in Qualifier Context
To define the Item Code Navigate to setup→Attribute Management→Context and Attributes
Enter Context and Attributes as below

Select next available Qualifier_attribute and Value Set “ONT: Internal_Item”


Map the Qualifier Context and Qualifier Attribute
To define the Item Code Navigate to setup→Attribute Management→ Attribute Linking and Mapping
Select “Order Fulfillment” in Pricing Transaction Entity and “Qualifier Context” in Context Type
Click on “Item_Code” Context and click on “Link Attributes “
Select Level as Line and Attribute Mapping Method as “Attribute Mapping”.

Enable “LOV Enabled, Use in limits, Attribute Mapping Enabled options.

Link Attribute with Advance Pricing Application

Click on Attribute Mapping button

Attribute Mapping Page opens.  Select “Advanced Pricing” against Request Type “ONT” and enter “PL/SQL API" as User Source Type and “OE_ORDER_PUB.G_LINE.inventory_item_id” as user value string. Save the Record and close the Page.


Run Build Attribute Mapping Concurrent Program

Run Build attribute mapping Program to build newly created mapping Rules and ensure that the Program completes in normal.

Create the Qualifier using Item Code

After successful completion of above program, navigate to Qualifier Setup and Create a Qualifier using Item Code Attribute as below.


Define Modifier and Map the Item Qualifier

Create new modifier or update existing modifier with newly created Qualifier based on Item Code.



Run “QP: Maintains the denormalized data in QP Qualifiers” Concurrent Program
After the completion of modifier setup, Launch Run “QP: Maintains the denormalized data in QP Qualifiers” Concurrent Program for the modifier which was created or updated with Item Qualifier.
Ensure that the Program completed in Normal.  
The required Qualifier and modifier setup to apply discount based on Item Code is completed.


Example:

After successful completion of setup, create a Sales order with the required item to test the setup.
  1. Create Sales Order
  1. Enter Item and the actual Price of the Item is defaulted based on the Price list

  1. Save/Book  the Order to view the discounted Price in Order line. Click on “Additional Line Information” and Select “View Adjustment” to see the applied modifer.
  1. Add another line with different Item (Which is not enabled as Qualifier) to check the Qualifer.

  1. Save or Book the Order to view the Modifer applied on new line.
  1. Click on “Additional Line Information” and Select “View Adjustment” to see the applied modifer.   View adjustment screen does not  show any record as the line is not elgible to apply mofier.


                                                                                                                   --- Suresh Kumar Mani






8 comments:

  1. we can create a modifier and mention the discount and item code in modifier lines and attach customer in line level qualifier.

    ReplyDelete
  2. Hello Sridevi,

    I have been seeing your post regarding training in every blog.
    All these blog are minting for knowledge sharing purpose only not for your money earning purpose.

    Its sooo irritating for every who are reviewing these blogs only because of your business promotion.

    Please stop this.



    ReplyDelete
  3. Magnificent blog I visit this blog it's extremely wonderful. Interestingly, in this blog content composed plainly and reasonable. The substance of data is useful.
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. Hi Suresh Kumar Mani, do you have the same example but to fusion 19D version? Best regards and excellent post.

    ReplyDelete
  7. "Item Code as Qualifier and Percentage" is readable topic. Your explanation of using item codes to categorize and assess percentages offers a streamlined. Security Tips Cybersecurity Resource allocation for businesses. A well-considered strategy with tangible benefits. This blog is useful.

    ReplyDelete