QP_MODIFIERS_PUB.Process_Modifiers API Is Not Creating A Modifier or Is Not Processing Update Or Is Not Creating Qualifiers Yet Completes Successfully (Doc ID 1192904.1)

Last updated on NOVEMBER 10, 2016

Applies to:

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

Symptoms

Created package and concurrent program to call the Modifier API QP_Modifiers_PUB.Process_Modifiers.  The program returns the status 'S' but it does not create a modifier.


STEPS:
1. Run wrapper (in this case in a concurrent program) to call the Modifier API QP_Modifiers_PUB.Process_Modifiers.
2. Program ends in success but modifier cannot be found through the application.

Changes

Prior to Oracle Applications Release 12.1.1 (or higher) upgrade, one used sample script(s) as outlined in <Note 1078960.1>
How to Create Modifiers Using the API QP_MODIFIERS_PUB.PROCESS_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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms