How to Create Modifiers Using the API QP_MODIFIERS_PUB.PROCESS_MODIFIERS
来源:互联网 发布:java reflectionutil 编辑:程序博客网 时间:2024/05/16 04:34
In this Document
APPLIES TO:
Oracle Advanced Pricing - Version 11.5.10 and laterInformation 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
File Path : $QP_TOP/patch/115/sql/QPXEXDS1.sql
File Path : $QP_TOP/patch/115/sql/QPXEXDS2.sql
Get 10% discount
File Path : $QP_TOP/patch/115/sql/QPXEXDS3.sql
File Path : /nfs/group/qpdev/qp/11.5/patch/115/sql/QPXEXSUR.sql
Get a Payment Term 2/10 NET 30
Terms Substitution Creation.
File Path : $QP_TOP/patch/115/sql/QPXEXTSN.sql
File Path: $QP_TOP/patch/115/sql/QPXEXOID.sql
Get 1 item 62081 at a 20% discount
File Path : $QP_TOP/patch/115/sql/QPXEXPRG.sql
File Path : $QP_TOP/patch/115/sql/QPXEXCIE.sql
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:
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.
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 SuccessfullyNOTE: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