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  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 : 

 

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

File Path : 

 

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

           Get 10% discount

File Path :

Example 4: Create 2% surcharge on all products

File Path : 

 

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 :

 

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

File Path: 

 

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

           Get 1 item 62081 at a 20% discount

File Path : 

 

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

File Path :

 

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

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

File Path: 

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

 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

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

 - 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 

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

 - How Does One Create Modifier With Qualifier Using API?

 - 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:

 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 .

REFERENCES

 - QP_MODIFIERS_PUB.Process_Modifiers API Is Not Creating A Modifier or Is Not Processing Update Or Is Not Creating Qualifiers Yet Completes Successfully

 - Is There a Direct Route Using an API for Loading Qualifiers for the Modifier Header?

 - Oracle Logistics and Order Management Release 11i Documentation

 - How Does One Create Modifier With Qualifier Using API?

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

 - 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

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

 - QP_MODIFIERS_PUB: Not Create Promotional Good Modifier with Break Type = RECURRING

文档详细信息

	类型:
	状态:
	上次主更新:
	上次更新:

	HOWTO
	PUBLISHED
	2014-5-5
	2014-5-5

相关产品

Oracle Advanced Pricing

信息中心

文档引用

最近查看