How to Create Modifiers Using the API QP_MODIFIERS_PUB.PROCESS_MODIFIERS

In this Document

APPLIES TO:

Oracle Advanced Pricing - Version 11.5.10 and later
Information in this document applies to any platform.

GOAL

Provide method to use an API to create modifiers in Oracle Applications.

SOLUTION

Review the Oracle® Order Management Open Interfaces, API, & Electronic Messaging Guide
Release 12.1, Part No. E18000-01, Page 2-48 - Business Object for Modifier Setup Application Program Interface
or Review Note 295186.1 Oracle Order Management Open Interfaces, API, & Electronic Messaging Guide, Release 11i, Part No. B14446-01
Page 5-60 - Business Object for Modifier Setup Application Program Interface

This section explains how to use the Business Object for Modifier Setup API and how it functions in Oracle Advanced Pricing. The Business Object for Modifier
Setup package consists of entities to set up modifiers.

Example Scripts

Example 1: Line level discount of 8% discount on all products

File Path : $QP_TOP/patch/115/sql/QPXEXDS1.sql

Example 2: Buy more than 5 quantities of item 62081 , Get 8% discount

File Path : $QP_TOP/patch/115/sql/QPXEXDS2.sql

Example 3: For customer 1000, Buy more than 2 Units of item 62081, 

           Get 10% discount

File Path : $QP_TOP/patch/115/sql/QPXEXDS3.sql

Example 4: Create 2% surcharge on all products

File Path : /nfs/group/qpdev/qp/11.5/patch/115/sql/QPXEXSUR.sql

Example 5: For customer 1000, Buy more than 2 units of item 62081, 

           Get a Payment Term 2/10 NET 30

           Terms Substitution Creation.

File Path : $QP_TOP/patch/115/sql/QPXEXTSN.sql

Example 6: Other Item Discount Creation - Buy 1 of item 62081, Get 1 free

File Path: $QP_TOP/patch/115/sql/QPXEXOID.sql

Example 7: Promotional Goods - Buy 1 of item 45 and 1 item 63, 

           Get 1 item 62081 at a 20% discount

File Path : $QP_TOP/patch/115/sql/QPXEXPRG.sql

Example 8: Coupon Issue - Buy 2 of item 45, Get Coupon for 20% discount

File Path : $QP_TOP/patch/115/sql/QPXEXCIE.sql

Example 9: Price Break - Buy 1-100 of item 45, Get 20% discount

                         Buy 101-200 of item 45, Get 25% discount

File Path: $QP_TOP/patch/115/sql/QPXEXPBH.sql

For Oracle Applications R12, be sure to review the following note before testing:

Note 1192904.1 QP_MODIFIERS_PUB.Process_Modifiers API Is Not Creating A Modifier or Is Not Processing Update Or Is Not Creating Qualifiers Yet Completes Successfully.
This note outlines setup considerations in regards to the parameters being used.

Steps to verify the creation of modifier(s).

1. Log into Oracle Applications
2. Responsibility: Oracle Pricing Manager
3. Navigate to: Modifiers > Modifier Setup
4. Click on the FIND icon (looks like a flashlight or torch icon on the top menu bar)
5. Enter the modifier name in the find window
6. Click the Find button.
7. The modifier details will then be shown.

Additional Resources

Note 948703.1 - Pricing Api Qp_modifier_pub.Process_modifiers Errors To Update Modifier Hdr Dff

Note 844458.1 - Error Shown While Assigning A Negative Adjustment Factor Value(ie: -10) in a Factor List Using API QP_MODIFIERS_PUB.Process_Modifiers When Profile Qp: Negative Pricing = No

Note 791346.1 - QP_MODIFIERS_PUB.PROCESS_MODIFIERS() API Causes Error: This Name Is Currently Being Used As A Modifier Name

Note 404218.1 - How Does One Create Modifier With Qualifier Using API?

Note 956043.1 - QP_MODIFIERS_PUB: Not Create Promotional good Modifier with break type = RECURRING

Troubleshooting Tips

error message: Modifier date range must be within Modifier list date range
solution: Check the values populated for l_MODIFIER_LIST_rec.end_date_active and l_MODIFIERS_tbl(1).end_date_active. If both are the same value, (for instance l_MODIFIER_LIST_rec.end_date_active := sysdate+10;
and l_MODIFIERS_tbl(1).end_date_active := sysdate+10;)
then change the value for l_MODIFIER_LIST_rec.end_date_active := sysdate+11 to account for any timestamp variations.

error message: Phase is invalid and one has assigned l_MODIFIERS_tbl(1).pricing_phase_id := 2;
solution: Ensure that 2 is a valid phase that has not been end dated.

select * from qp_event_phases where pricing_phase_id = 2;

For Oracle Applications R12, be sure to review the following note before testing:
Note 1192904.1 QP_MODIFIERS_PUB.Process_Modifiers API Is Not Creating A Modifier or Is Not Processing Update Or Is Not Creating Qualifiers Yet Completes Successfully.
This note outlines setup considerations in regards to the parameters being used.

Still Have Questions?
To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the My Oracle Advanced Pricing Community.

REFERENCES

NOTE:1192904.1 - QP_MODIFIERS_PUB.Process_Modifiers API Is Not Creating A Modifier or Is Not Processing Update Or Is Not Creating Qualifiers Yet Completes Successfully
NOTE:1301767.1 - Is There a Direct Route Using an API for Loading Qualifiers for the Modifier Header?
NOTE:295186.1 - Oracle Logistics and Order Management Release 11i Documentation
NOTE:404218.1 - How Does One Create Modifier With Qualifier Using API?
NOTE:791346.1 - QP_MODIFIERS_PUB.PROCESS_MODIFIERS() API Causes Error: This Name Is Currently Being Used As A Modifier Name
NOTE:844458.1 - Error Shown While Assigning A Negative Adjustment Factor Value(ie: -10) in a Factor List Using API QP_MODIFIERS_PUB.Process_Modifiers When Profile Qp: Negative Pricing = No
NOTE:948703.1 - Pricing Api Qp_modifier_pub.Process_modifiers Errors To Update Modifier Hdr Dff
NOTE:956043.1 - QP_MODIFIERS_PUB: Not Create Promotional Good Modifier with Break Type = RECURRING