My Oracle Support Banner

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 AUGUST 12, 2020

Applies to:

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


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.

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.


Prior to Oracle Applications Release 12.1.1 (or higher) upgrade, one used sample script(s) as outlined in <Note 1078960.1>

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.