My Oracle Support Banner

Advanced Pricing Recommended Patch List (RPL) Consolidation for Oracle Applications Release 12.2 and 12.1 (Doc ID 1626542.1)

Last updated on JULY 14, 2021

Applies to:

Oracle Advanced Pricing - Version 12.1 and later
Information in this document applies to any platform.
Advanced Pricing Recommended Patch List (RPL) Consolidation for Oracle Applications 12.2 and 12.1

Details

This note lists the details for Advanced Pricing RPL consolidation patches for Oracle Applications Release 12.2 and 12.1
which include recommended Advanced Pricing patches.

Actions

Note: The Patch Wizard Utility helps keep your system up to date with the latest Development recommendations for security,
performance, stability, legislative updates and the overall E-Business experience.
Reference: <Note 1388190.1> - How to GET PROACTIVE with Oracle E-Business Suite

 

Release 12.2 - RPL Patch(s) for Advanced Pricing 12.2

 

Patch and Status  Fixes Provided with Patch
<Patch 29583022> :R12.QP.C - Advanced Pricing Recommended Patch Collection Apr, 2019

The following bugs are fixed by this patch:

<Bug 16179517> - PRICING MAINTENANCE>  - INTERNAL SERVER ERROR
<Bug 17347084>  - DEFINE MODIFIER FORM GIVES ERROR WHEN CREATING NEW PRICE BREAK LINE USING COPY F
<Bug 17438551>  - CREATING PRICE BOOK FOR SALES AGREEEMENT MISMATCH
<Bug 17759450>  - ORACLE STANDARD PRICE LIST REPORT MISSING FIELD AND DISPLAYS ID'S NOT THE VALUE
<Bug 17774383>  - MANUAL MODIFIER WITH FORMULA IS NOT PASSING VALUE
<Bug 17857932>  - PRICE LIST FORM GIVES ERROR WHEN CREATING NEW PRICE BREAK LINE USING SHIFT F6
<Bug 17943603>  - MODIFIER QUALIFIER: LINE TYPE IN RED
<Bug 17947726>  - MULTI-CURRENCY CONVERSION ISSUE>  - WRONG CURRENCY CONVERSION RATE IS USED
<Bug 17988381>  - FRM-40405: 'NO CHANGES TO APPLY' MESSAGE RECEIVED ON PRICING ORGANIZER
<Bug 18126335>  - DECIMAL PRECISION DIFFERENT ON P&A VS SALES ORDER
<Bug 18235252>  - CRREATE MODIFIER GET  ERROR PRODUCT ATTRIBUTE VALUE IS INVALID
<Bug 18287889>  - UNABLE TO MODIFY/UPDATE FIELDS IN THE HEADER LEVEL IN PRICE LIST
<Bug 18391008>  - ACCUMULATED RANGE BREAK CALCULATIONS USING RUNTIME SOURCED VALUE NOT AVAILBLE FO
<Bug 18401920>  - ERROR WHEN ADDING QUALIFIER AS A LIST / LINE LIMITS CONDITION
<Bug 18424132>  - ARCHIVE PRICING ENTITY CONCURRENT PROGRAM DISABLED AFTER UPGRADE
<Bug 18425959>  - PRICING ATTRIBUTE MANAGEMENT SETUP WINDOW DOES NOT AUTO-QUERY
<Bug 18451612>  - ORA-06502 WHEN CALLING QP_PRICE_BOOK_PUB.GET_PRICE_BOOK API
<Bug 18454567>  - R12.2.3 CANNOT GET LIST PRICE WHEN ORDER IS BOOKED
<Bug 18483269>  - PRODUCT VALUE LOV IS NOT WORKING USING FIND SEARCH AKA TORCH ICON FUNCTIONALITY
<Bug 18508650>  - ADD ITEMS TO PRICE LIST FAILS WITH ORA-06502
<Bug 18552704>  - UNEXPECTED ERROR IN AUTOCREATE RAISED FROM ADVANCE PRICING
<Bug 18614841>  - ERROR DISPLAYS WHEN DELETE SECONDARY PRICE LIST
<Bug 18641502>  - FINISH CONFIGURATION IN ISTORE TAKES MORE THAN 1 MINUTE EXPECTING UNDER 20 SEC
<Bug 18661338>  - PRICE LIST CREATED WITH OVERLAPPING DATES BY BULK IMPORT PROCESS
<Bug 18696348>  - PL>  - PRICING ATTRIBUTE>  - LOV NULL WHEN NAVIGATING AWAY FROM THE VALUE FROM FIELD
<Bug 18800485>  - R12 PBH NOT APPLIED WITH FREIGHT CHARGE ON FIRST LINER MODIFIER
<Bug 18960371>  - QPXSSDAF: CAN SAVE AGREEMENT WITHOUT POPULATING REQUIRED FIELDS
<Bug 18968303>  - NO LOV IN PRICING ATTRIBUTE FOR CUSTOMER ITEMS  IN 12.1.3
<Bug 19032170>  - QPXPRFOR: QUERY ONLY AND CAN STILL CHANGE FORMULA AND SAVE
<Bug 19144544>  - PRICING MODIFIER FORM PERFORMANCE ISSUE PRODUCT ATTRIBUTE VALUE  - ITEM CATEGORY
<Bug 19191555>  - NOTE:551721 CUSTOM PL/SQL ATTRIBUTE CANCEL ISSUE FOR PROMOTIONAL GOODS
<Bug 19323551>  - ERROR WHILE USING NVL2 SQL FUNCTION IN ORACLE PRICING FORMULA
<Bug 19404639>  - FACTOR LIST RETURNED NULL VALUE WHEN FACTOR OPERATOR BETWEEN AND VALUE TO NULL
<Bug 19452284>  - RMA APPLIES DISCOUNT TWICE WHEN USING OE_ORDER_PUB.PROCESS_ORDER API OR REPRICE
<Bug 19491198>  - QPXPRLST: CANNOT QUERY PRICE LIST LINES BY DYNAMIC FORMULA NAME
<Bug 19518944>  - UNABLE TO CAPTURE FACTOR LIST HEADER_ID LINE_ID IN QP_NFORMULA_STEP_VALUES_TMP
<Bug 19555418>  - CREATE INTERCOMPANY  IS HAVING PERFORMANCE ISSUE
<Bug 19691135>  - PRICING PERFORMANCE ISSUE USING OE_ORDER_PUB.PROCESS_ORDER API
<Bug 19716853>  - MODIFIER DETAILS REPORT STANDARD REPORT FOR MODIFIER CANNOT BE PRINTED
<Bug 19724468>  - NOT ABLE TO UPDATE PRICING SECURITY USING ORACLE PRICING ADMINISTRATOR
<Bug 19770132>  - API PRICING>  - UNABLE TO CREATE PRICE AGREEMENT USING KOREAN CHARACTERS
<Bug 19790706>  - PRICING MODIFIER ON INVENTORY CATEGORY NOT WORKING
<Bug 19795605>  - PERFORMANCE ISSUE WITH PRICE LIST REPORT
<Bug 19881017>  - COULD NOT ENTER & BOOK SO FOR THE ITEM DEFINED WITH LINE TYPE 'PRICE BREAK HEADE
<Bug 19953132>  - PERFORMANCE ISSUE IN PRICE LIST UPLOAD
<Bug 20054252>  - PRICING PERFORMANCE API  CALLS QP_PREQ_PUB.PRICE_REQUEST FOR  PRICE BOOKS.
<Bug 20512653>  - CANNOT SAVE ORDER LINES FOR SOME ITEMS
<Bug 20555822>  - QPXLPLHS: CLOSE CURSOR C_LINES_SDATES_CUR
<Bug 20612360>  - 12.2.4: UNABLE TO CREATE PRICE BOOK
<Bug 20639914>  - COPY MODIFIER(SHIFT+F6) OPEN
<Bug 21423613>  - PRICE BOOK ANOTHER PRICE LIST NOT JUST THE ONE IN PRICING BASIS
<Bug 21481284>  - REDEEM ACCRUAL EXPIRATION DATE: ONLY PROVIDE EXPIRATION PERIOD AND PERIOD TYPE
<Bug 21848532>  - QPXPACRL INCREASE CUSTOMER NAME TO 360
<Bug 21876475>  - PRG AND RELATED DETAILS BUTTON IN VIEW ADJUSTMENST WINDOW
<Bug 22079596>  - UNABLE COPY/PASTE MODIFIER NUMBER SIZE IS MORE THAN FIELD IN PRICING ORGANIZER
<Bug 22124877>  - COPY MODIFIER(SHIFT+F6) SHOWS INCORRECT BEHAVIOR IN DEFINE DETAIL WINDOW
<Bug 22474702>  - MODIFIERS WITH LINE LEVEL QUALIFIERS NOT APPLY
<Bug 22984342>  - PERFORMANCE ISSUES WITH SALES ORDER FORM DURING PRICING CALL
<Bug 23272198>  - DISCOUNT MODIFIER NOT WORKING AS EXPECTED FOR ORDER AMOUNT ATTRIBUTE
<Bug 23293526>  - FORMS SERVER ERROR/PRICE LIST FORM AND QUALIFIER FORM CHOOSING SEEDED QUALIERS
<Bug 23322366>  - BUILD ATTRIBUTE MAPPING RULES PERFORMANC AFTER ADVANCED PRICING RUP PATCH
<Bug 24533187>  - PRODUCT CRITERIA ¿ALL ITEMS¿ WORKING FOR SELECTED INVENTORY
<Bug 24559222>  - PRICEBOOK: PRICING BASIS = SALES AGREEMENT
<Bug 25253768>  - PRICING ENGINE PERFORMANCE ISSUE
<Bug 25381653>  - PRICE NOT BEING PICKED FROM CORRECT SECONDARY PRICE LIST ATTACHED TO PRIMARY
<Bug 25551904>  - PRICING PERF>  - PATCH 25393108 QP_QUALIFIERS_N13 INDEX
<Bug 25942264>  - ORDER IMPORT PROGRAM WHICH INVOLVES OE_ORDER_PUB IS TAKING LONG TIME THE BELOW Q
<Bug 26006800>  - PRICING ENGINE PERFORMANCE CUSTOM WRAPPER CALLING JTF TABLES.
<Bug 26030081>  - PERFORMANCE FOR CUSTOM PRICE BOOK USING API QP_PREQ_PUB.PRICE_REQUEST
<Bug 26180309>  - QP: MAINTAINS THE DENORMALIZED DATA IN QP QUALIFIERS COMPLETED WITH ERROR
<Bug 26315004>  - QPXPRLST: PERFORMANCE ISSUE QUERYING PL
<Bug 26432262>  - ORDER IMPORT PERFORMANCE
<Bug 27255068>  - OE_ORDER_PUB.G_LINE.FOB_POINT_CODE NOT POPULATED USING PATTERN SEARCH
<Bug 28359291>  - <SHIFT><TAB> DOES NOT WORK CORRECTLY ON THE MODIFIER SETUP FORM

<Patch 27330796>:R12.QP.C - Advanced Pricing Recommended Patch Collection Jan , 2018
Afterwards, please see <Document 2316643.1> solution action plan in case of invalid QP_PREQ_GRP.




The following bugs are fixed by this patch:

<Bug 16179517> - PRICING MAINTENANCE> - INTERNAL SERVER ERROR
<Bug 17347084> - DEFINE MODIFIER FORM GIVES ERROR WHEN CREATING NEW PRICE BREAK LINE USING COPY F
<Bug 17438551> - CREATING PRICE BOOK FOR SALES AGREEMENT MISMATCH
<Bug 17759450> - ORACLE STANDARD PRICE LIST REPORT MISSING FIELD AND DISPLAYS ID'S NOT THE VALUE
<Bug 17774383> - MANUAL MODIFIER WITH FORMULA IS NOT PASSING VALUE
<Bug 17857932> - PRICE LIST FORM GIVES ERROR WHEN CREATING NEW PRICE BREAK LINE USING SHIFT F6
<Bug 17943603> - MODIFIER QUALIFIER: LINE TYPE IN RED
<Bug 17947726> - MULTI-CURRENCY CONVERSION ISSUE> - WRONG CURRENCY CONVERSION RATE IS USED
<Bug 17988381> - FRM-40405: 'NO CHANGES TO APPLY' MESSAGE RECEIVED ON PRICING ORGANIZER
<Bug 18126335> - DECIMAL PRECISION DIFFERENT ON P&A VS SALES ORDER
<Bug 18235252> - CREATE MODIFIER GET ERROR PRODUCT ATTRIBUTE VALUE IS INVALID
<Bug 18287889> - UNABLE TO MODIFY/UPDATE FIELDS IN THE HEADER LEVEL IN PRICE LIST
<Bug 18391008> - ACCUMULATED RANGE BREAK CALCULATIONS USING RUNTIME SOURCED VALUE NOT AVAILABLE
<Bug 18401920> - ERROR WHEN ADDING QUALIFIER AS A LIST / LINE LIMITS CONDITION
<Bug 18424132> - ARCHIVE PRICING ENTITY CONCURRENT PROGRAM DISABLED AFTER UPGRADE
<Bug 18425959> - PRICING ATTRIBUTE MANAGEMENT SETUP WINDOW DOES NOT AUTO-QUERY
<Bug 18451612> - ORA-06502 WHEN CALLING QP_PRICE_BOOK_PUB.GET_PRICE_BOOK API
<Bug 18454567> - R12.2.3 CANNOT GET LIST PRICE WHEN ORDER IS BOOKED
<Bug 18483269> - PRODUCT VALUE LOV IS NOT WORKING USING FIND SEARCH AKA TORCH ICON FUNCTIONALITY
<Bug 18508650> - ADD ITEMS TO PRICE LIST FAILS WITH ORA-06502
<Bug 18552704> - UNEXPECTED ERROR IN AUTOCREATE RAISED FROM ADVANCE PRICING
<Bug 18614841> - ERROR DISPLAYS WHEN DELETE SECONDARY PRICE LIST
<Bug 18641502> - FINISH CONFIGURATION IN ISTORE TAKES MORE THAN 1 MINUTE EXPECTING UNDER 20 SEC
<Bug 18661338> - PRICE LIST CREATED WITH OVERLAPPING DATES BY BULK IMPORT PROCESS
<Bug 18696348> - PL> - PRICING ATTRIBUTE> - LOV NULL WHEN NAVIGATING AWAY FROM THE VALUE FROM FIELD
<Bug 18800485> - R12 PBH NOT APPLIED WITH FREIGHT CHARGE ON FIRST LINER MODIFIER
<Bug 18960371> - QPXSSDAF: CAN SAVE AGREEMENT WITHOUT POPULATING REQUIRED FIELDS
<Bug 18968303> - NO LOV IN PRICING ATTRIBUTE FOR CUSTOMER ITEMS IN 12.1.3
<Bug 19032170> - QPXPRFOR: QUERY ONLY AND CAN STILL CHANGE FORMULA AND SAVE
<Bug 19144544> - PRICING MODIFIER FORM PERFORMANCE ISSUE PRODUCT ATTRIBUTE VALUE> - ITEM CATEGORY
<Bug 19191555> - NOTE:551721 CUSTOM PL/SQL ATTRIBUTE CANCEL ISSUE FOR PROMOTIONAL GOODS
<Bug 19323551> - ERROR WHILE USING NVL2 SQL FUNCTION IN ORACLE PRICING FORMULA
<Bug 19404639> - FACTOR LIST RETURNED NULL VALUE WHEN FACTOR OPERATOR BETWEEN AND VALUE TO NULL
<Bug 19452284> - RMA APPLIES DISCOUNT TWICE WHEN USING OE_ORDER_PUB.PROCESS_ORDER API OR REPRICE
<Bug 19491198> - QPXPRLST: CANNOT QUERY PRICE LIST LINES BY DYNAMIC FORMULA NAME
<Bug 19518944> - UNABLE TO CAPTURE FACTOR LIST HEADER_ID LINE_ID IN QP_NFORMULA_STEP_VALUES_TMP
<Bug 19555418> - CREATE INTERCOMPANY IS HAVING PERFORMANCE ISSUE
<Bug 19691135> - PRICING PERFORMANCE ISSUE USING OE_ORDER_PUB.PROCESS_ORDER API
<Bug 19716853> - MODIFIER DETAILS REPORT STANDARD REPORT FOR MODIFIER CANNOT BE PRINTED
<Bug 19724468> - NOT ABLE TO UPDATE PRICING SECURITY USING ORACLE PRICING ADMINISTRATOR
<Bug 19770132> - API PRICING> - UNABLE TO CREATE PRICE AGREEMENT USING KOREAN CHARACTERS
<Bug 19790706> - PRICING MODIFIER ON INVENTORY CATEGORY NOT WORKING
<Bug 19795605> - PERFORMANCE ISSUE WITH PRICE LIST REPORT
<Bug 19881017> - COULD NOT ENTER & BOOK SO FOR THE ITEM DEFINED WITH LINE TYPE 'PRICE BREAK HEADER'
<Bug 19953132> - PERFORMANCE ISSUE IN PRICE LIST UPLOAD
<Bug 20054252> - PRICING PERFORMANCE API CALLS QP_PREQ_PUB.PRICE_REQUEST FOR PRICE BOOKS.
<Bug 20512653> - CANNOT SAVE ORDER LINES FOR SOME ITEMS
<Bug 20555822> - QPXLPLHS: CLOSE CURSOR C_LINES_SDATES_CUR
<Bug 20612360> - 12.2.4: UNABLE TO CREATE PRICE BOOK
<Bug 20639914> - COPY MODIFIER(SHIFT+F6) OPEN
<Bug 20851362> - MODIFIER NOT APPLIED
<Bug 21423613> - PRICE BOOK ANOTHER PRICE LIST NOT JUST THE ONE IN PRICING BASIS
<Bug 21481284> - REDEEM ACCRUAL EXPIRATION DATE: ONLY PROVIDE EXPIRATION PERIOD AND PERIOD TYPE
<Bug 21848532> - QPXPACRL INCREASE CUSTOMER NAME TO 360
<Bug 21876475> - PRG AND RELATED DETAILS BUTTON IN VIEW ADJUSTMENTS WINDOW
<Bug 22079596> - UNABLE COPY/PASTE MODIFIER NUMBER SIZE IS MORE THAN FIELD IN PRICING ORGANIZER
<Bug 22124877> - COPY MODIFIER(SHIFT+F6) SHOWS INCORRECT BEHAVIOR IN DEFINE DETAIL WINDOW
<Bug 22474702> - MODIFIERS WITH LINE LEVEL QUALIFIERS NOT APPLY
<Bug 22984342> - PERFORMANCE ISSUES WITH SALES ORDER FORM DURING PRICING CALL
<Bug 23272198> - DISCOUNT MODIFIER NOT WORKING AS EXPECTED FOR ORDER AMOUNT ATTRIBUTE
<Bug 23293526> - FORMS SERVER ERROR/PRICE LIST FORM AND QUALIFIER FORM CHOOSING SEEDED QUALIFIERS
<Bug 23322366> - BUILD ATTRIBUTE MAPPING RULES PERFORMANCE AFTER ADVANCED PRICING RUP PATCH
<Bug 24533187> - PRODUCT CRITERIA ¿ALL ITEMS¿ WORKING FOR SELECTED INVENTORY
<Bug 24559222> - PRICE BOOK: PRICING BASIS = SALES AGREEMENT
<Bug 25253768> - PRICING ENGINE PERFORMANCE ISSUE
<Bug 25381653> - PRICE NOT BEING PICKED FROM CORRECT SECONDARY PRICE LIST ATTACHED TO PRIMARY
<Bug 25551904> - PRICING PERF> - PATCH 25393108 QP_QUALIFIERS_N13 INDEX
<Bug 25942264> - ORDER IMPORT PROGRAM WHICH INVOLVES OE_ORDER_PUB IS TAKING LONG TIME THE BELOW Q
<Bug 26006800> - PRICING ENGINE PERFORMANCE CUSTOM WRAPPER CALLING JTF TABLES.
<Bug 26030081> - PERFORMANCE FOR CUSTOM PRICE BOOK USING API QP_PREQ_PUB.PRICE_REQUEST
<Bug 26180309> - QP: MAINTAINS THE DENORMALIZED DATA IN QP QUALIFIERS COMPLETED WITH ERROR
<Bug 26315004> - QPXPRLST: PERFORMANCE ISSUE QUERYING PL
<Bug 26432262> - ORDER IMPORT PERFORMANCE

<Patch 25981859>:R12.QP.C - Released
Advanced Pricing Recommended Patch Collection May , 2017
The following bugs are fixed by this patch:

<Bug 16179517> - PRICING MAINTENANCE> - INTERNAL SERVER ERROR
<Bug 17347084> - DEFINE MODIFIER FORM GIVES ERROR WHEN CREATING NEW PRICE BREAK LINE USING COPY F
<Bug 17438551> - CREATING PRICE BOOK FOR SALES AGREEMENT MISMATCH
<Bug 17759450> - ORACLE STANDARD PRICE LIST REPORT MISSING FIELD AND DISPLAYS ID'S NOT THE VALUE
<Bug 17774383> - MANUAL MODIFIER WITH FORMULA IS NOT PASSING VALUE
<Bug 17857932> - PRICE LIST FORM GIVES ERROR WHEN CREATING NEW PRICE BREAK LINE USING SHIFT F6
<Bug 17943603> - MODIFIER QUALIFIER: LINE TYPE IN RED
<Bug 17947726> - MULTI-CURRENCY CONVERSION ISSUE> - WRONG CURRENCY CONVERSION RATE IS USED
<Bug 17988381> - FRM-40405: 'NO CHANGES TO APPLY' MESSAGE RECEIVED ON PRICING ORGANIZER
<Bug 18126335> - DECIMAL PRECISION DIFFERENT ON P&A VS SALES ORDER
<Bug 18235252> - CREATE MODIFIER GET ERROR PRODUCT ATTRIBUTE VALUE IS INVALID
<Bug 18287889> - UNABLE TO MODIFY/UPDATE FIELDS IN THE HEADER LEVEL IN PRICE LIST
<Bug 18391008> - ACCUMULATED RANGE BREAK CALCULATIONS USING RUNTIME SOURCED VALUE NOT AVAILABLE FO
<Bug 18401920> - ERROR WHEN ADDING QUALIFIER AS A LIST / LINE LIMITS CONDITION
<Bug 18424132> - ARCHIVE PRICING ENTITY CONCURRENT PROGRAM DISABLED AFTER UPGRADE
<Bug 18425959> - PRICING ATTRIBUTE MANAGEMENT SETUP WINDOW DOES NOT AUTO-QUERY
<Bug 18451612> - ORA-06502 WHEN CALLING QP_PRICE_BOOK_PUB.GET_PRICE_BOOK API
<Bug 18454567> - R12.2.3 CANNOT GET LIST PRICE WHEN ORDER IS BOOKED
<Bug 18483269> - PRODUCT VALUE LOV IS NOT WORKING USING FIND SEARCH AKA TORCH ICON FUNCTIONALITY
<Bug 18508650> - ADD ITEMS TO PRICE LIST FAILS WITH ORA-06502
<Bug 18552704> - UNEXPECTED ERROR IN AUTOCREATE RAISED FROM ADVANCE PRICING
<Bug 18614841> - ERROR DISPLAYS WHEN DELET SECONDARY PRICE LIST
<Bug 18641502> - FINISH CONFIGURATION IN ISTORE TAKES MORE THAN 1 MINUTE EXPECTING UNDER 20 SEC
<Bug 18661338> - PRICE LIST CREATED WITH OVERLAPPING DATES BY BULK IMPORT PROCESS
<Bug 18696348> - PL> - PRICING ATTRIBUTE> - LOV NULL WHEN NAVIGATING AWAY FROM THE VALUE FROM FIELD
<Bug 18800485> - R12 PBH NOT APPLIED WITH FREIGHT CHARGE ON FIRST LINER MODIFIER
<Bug 18960371> - QPXSSDAF: CAN SAVE AGREEMENT WITHOUT POPULATING REQUIRED FIELDS
<Bug 18968303> - NO LOV IN PRICING ATTRIBUTE FOR CUSTOMER ITEMS IN 12.1.3
<Bug 19032170> - QPXPRFOR: QUERY ONLY AND CAN STILL CHANGE FORMULA AND SAVE
<Bug 19144544> - PRICING MODIFIER FORM PERFORMANCE ISSUE PRODUCT ATTRIBUTE VALUE> - ITEM CATEGORY
<Bug 19191555> - NOTE:551721 CUSTOM PL/SQL ATTRIBUTE CANCEL ISSUE FOR PROMOTIONAL GOODS
<Bug 19323551> - ERROR WHILE USING NVL2 SQL FUNCTION IN ORACLE PRICING FORMULA
<Bug 19404639> - FACTOR LIST RETURNED NULL VALUE WHEN FACTOR OPERATOR BETWEEN AND VALUE TO NULL
<Bug 19452284> - RMA APPLIES DISCOUNT TWICE WHEN USING OE_ORDER_PUB.PROCESS_ORDER API OR REPRICE
<Bug 19491198> - QPXPRLST: CANNOT QUERY PRICE LIST LINES BY DYNAMIC FORMULA NAME
<Bug 19518944> - UNABLE TO CAPTURE FACTOR LIST HEADER_ID LINE_ID IN QP_NFORMULA_STEP_VALUES_TMP
<Bug 19555418> - CREATE INTERCOMPANY IS HAVING PERFORMANCE ISSUE
<Bug 19691135> - PRICING PERFORMANCE ISSUE USING OE_ORDER_PUB.PROCESS_ORDER API
<Bug 19716853> - MODIFIER DETAILS REPORT STANDARD REPORT FOR MODIFIER CANNOT BE PRINTED
<Bug 19724468> - NOT ABLE TO UPDATE PRICING SECURITY USING ORACLE PRICING ADMINISTRATOR
<Bug 19770132> - API PRICING> - UNABLE TO CREATE PRICE AGREEMENT USING KOREAN CHARACTERS
<Bug 19790706> - PRICING MODIFIER ON INVENTORY CATEGORY NOT WORKING
<Bug 19795605> - PERFORMANCE ISSUE WITH PRICE LIST REPORT
<Bug 19881017> - COULD NOT ENTER & BOOK SO FOR THE ITEM DEFINED WITH LINE TYPE 'PRICE BREAK HEADE
<Bug 19953132> - PERFORMANCE ISSUE IN PRICE LIST UPLOAD
<Bug 20054252> - PRICING PERFORMANCE API CALLS QP_PREQ_PUB.PRICE_REQUEST FOR PRICE BOOKS.
<Bug 20512653> - CANNOT SAVE ORDER LINES FOR SOME ITEMS
<Bug 20555822> - QPXLPLHS: CLOSE CURSOR C_LINES_SDATES_CUR
<Bug 20612360> - 12.2.4: UNABLE TO CREATE PRICE BOOK
<Bug 20639914> - COPY MODIFIER(SHIFT+F6) OPEN
<Bug 20851362> - MODIFIER NOT APPLIED
<Bug 21423613> - PRICE BOOK ANOTHER PRICE LIST NOT JUST THE ONE IN PRICING BASIS
<Bug 21481284> - REDEEM ACCRUAL EXPIRATION DATE: ONLY PROVIDE EXPIRATION PERIOD AND PERIOD TYPE
<Bug 21848532> - QPXPACRL INCREASE CUSTOMER NAME TO 360
<Bug 21876475> - PRG AND RELATED DETAILS BUTTON IN VIEW ADJUSTMENST WINDOW
<Bug 22079596> - UNABLE COPY/PASTE MODIFIER NUMBER SIZE IS MORE THAN FIELD IN PRICING ORGANIZER
<Bug 22124877> - COPY MODIFIER(SHIFT+F6) SHOWS INCORRECT BEHAVIOR IN DEFINE DETAIL WINDOW
<Bug 22474702> - MODIFIERS WITH LINE LEVEL QUALIFIERS NOT APPLY
<Bug 22984342> - PERFORMANCE ISSUES WITH SALES ORDER FORM DURING PRICING CALL
<Bug 23293526> - FORMS SERVER ERROR/PRICE LIST FORM AND QUALIFIER FORM CHOOSING SEEDED QUALIERS
<Bug 23322366> - BUILD ATTRIBUTE MAPPING RULES PERFORMANC AFTER ADVANCED PRICING RUP PATCH
<Bug 24533187> - PRODUCT CRITERIA ¿ALL ITEMS¿ WORKING FOR SELECTED INVENTORY
<Bug 24559222> - PRICEBOOK: PRICING BASIS = SALES AGREEMENT
<Bug 25253768> - PRICING ENGINE PERFORMANCE ISSUE
<Bug 25551904> - PRICING PERF> - PATCH 25393108 QP_QUALIFIERS_N13 INDEX


 

<Patch 24583002:R12.QP.C> - Released
Advanced Pricing Recommended Patch Collection Sept, 2016

The following bugs are fixed by this patch:

,,,

<Bug 16179517> - PRICING MAINTENANCE> - INTERNAL SERVER ERROR
<Bug 17347084> - DEFINE MODIFIER FORM GIVES ERROR WHEN CREATING NEW
                                   PRICE BREAK LINE USING COPY
<Bug 17438551> - CREATING PRICE BOOK FOR SALES AGREEEMENT MISMATCH
<Bug 17759450> - ORACLE STANDARD PRICE LIST REPORT MISSING FIELD AND
                                   DISPLAYS ID'S NOT THE VALUE
<Bug 17774383> - MANUAL MODIFIER WITH FORMULA IS NOT PASSING VALUE
<Bug 17857932> - PRICE LIST FORM GIVES ERROR WHEN CREATING NEW PRICE
                                   BREAK LINE USING SHIFT F6
<Bug 17943603> - MODIFIER QUALIFIER: LINE TYPE IN RED
<Bug 17947726> - MULTI-CURRENCY CONVERSION ISSUE> - WRONG CURRENCY
                                   CONVERSION RATE IS USED
<Bug 17988381> - FRM-40405: 'NO CHANGES TO APPLY' MESSAGE RECEIVED ON
                                   PRICING ORGANIZER
<Bug 18126335> - DECIMAL PRECISION DIFFERENT ON P&A VS SALES ORDER
<Bug 18235252> - CRREATE MODIFIER GET ERROR PRODUCT ATTRIBUTE VALUE
                                   IS INVALID
<Bug 18287889> - UNABLE TO MODIFY/UPDATE FIELDS IN THE HEADER LEVEL
                                   IN PRICE LIST
<Bug 18391008> - ACCUMULATED RANGE BREAK CALCULATIONS USING RUN TIME
                                  SOURCED VALUE NOT AVAILABLE FO
<Bug 18401920> - ERROR WHEN ADDING QUALIFIER AS A LIST / LINE LIMITS
                                   CONDITION
<Bug 18424132> - ARCHIVE PRICING ENTITY CONCURRENT PROGRAM DISABLED
                                  AFTER UPGRADE
<Bug 18425959> - PRICING ATTRIBUTE MANAGEMENT SETUP WINDOW DOES NOT
                                  AUTO-QUERY
<Bug 18451612> - ORA-06502 WHEN CALLING
                                   QP_PRICE_BOOK_PUB.GET_PRICE_BOOK API
<Bug 18454567> - R12.2.3 CANNOT GET LIST PRICE WHEN ORDER IS BOOKED
<Bug 18483269> - PRODUCT VALUE LOV IS NOT WORKING USING FIND SEARCH
                                   AKA TORCH ICON FUNCTIONALITY
<Bug 18508650> - ADD ITEMS TO PRICE LIST FAILS WITH ORA-06502
<Bug 18552704> - UNEXPECTED ERROR IN AUTOCREATE RAISED FROM
                                   ADVANCE PRICING
<Bug 18614841> - ERROR DISPLAYS WHEN DELET SECONDARY PRICE LIST
<Bug 18641502> - FINISH CONFIGURATION IN ISTORE TAKES MORE THAN
                                  1 MINUTE EXPECTING UNDER 20 SEC
<Bug 18661338> - PRICE LIST CREATED WITH OVERLAPPING DATES BY BULK
                                   IMPORT PROCESS
<Bug 18696348> - PRICING ATTRIBUTE> - LOV NULL WHEN NAVIGATING
                                   AWAY FROM THE VALUE FROM FIELD
<Bug 18800485> - R12 PBH NOT APPLIED WITH FREIGHT CHARGE ON FIRST LINER
                                  MODIFIER
<Bug 18960371> - QPXSSDAF: CAN SAVE AGREEMENT WITHOUT POPULATING
                                   REQUIRED FIELDS
<Bug 18968303> - NO LOV IN PRICING ATTRIBUTE FOR CUSTOMER ITEMS IN 12.1.3
<Bug 19032170> - QPXPRFOR: QUERY ONLY AND CAN STILL CHANGE FORMULA
                                   AND SAVE
<Bug 19144544> - PRICING MODIFIER FORM PERFORMANCE ISSUE PRODUCT
                                   ATTRIBUTE VALUE> - ITEM CATEGORY
<Bug 19191555> - NOTE:551721 CUSTOM PL/SQL ATTRIBUTE CANCEL ISSUE
                                  FOR PROMOTIONAL GOODS
<Bug 19323551> - ERROR WHILE USING NVL2 SQL FUNCTION IN ORACLE PRICING
                                   FORMULA
<Bug 19404639> - FACTOR LIST RETURNED NULL VALUE WHEN FACTOR OPERATOR
                                  BETWEEN AND VALUE TO NULL
<Bug 19452284> - RMA APPLIES DISCOUNT TWICE WHEN USING
                                   OE_ORDER_PUB.PROCESS_ORDER API OR REPRICE
<Bug 19491198> - QPXPRLST: CANNOT QUERY PRICE LIST LINES BY
                                   DYNAMIC FORMULA NAME
<Bug 19518944> - UNABLE TO CAPTURE FACTOR LIST HEADER_ID LINE_ID IN
                                   QP_NFORMULA_STEP_VALUES_TMP
<Bug 19555418> - CREATE INTERCOMPANY IS HAVING PERFORMANCE ISSUE
<Bug 19691135> - PRICING PERFORMANCE ISSUE USING
                                  OE_ORDER_PUB.PROCESS_ORDER API
<Bug 19716853> - MODIFIER DETAILS REPORT STANDARD REPORT FOR
                                  MODIFIER CANNOT BE PRINTED
<Bug 19724468> - NOT ABLE TO UPDATE PRICING SECURITY USING ORACLE
                                  PRICING ADMINISTRATOR
<Bug 19770132> - API PRICING> - UNABLE TO CREATE PRICE AGREEMENT USING
                                  KOREAN CHARACTERS
<Bug 19790706> - PRICING MODIFIER ON INVENTORY CATEGORY NOT WORKING
<Bug 19795605> - PERFORMANCE ISSUE WITH PRICE LIST REPORT
<Bug 19881017> - COULD NOT ENTER & BOOK SO FOR THE ITEM DEFINED WITH
                                   LINE TYPE 'PRICE BREAK HEADE
<Bug 19953132> - PERFORMANCE ISSUE IN PRICE LIST UPLOAD
<Bug 20054252> - PRICING PERFORMANCE API CALLS
                                   QP_PREQ_PUB.PRICE_REQUEST FOR PRICE BOOKS.
<Bug 20512653> - CANNOT SAVE ORDER LINES FOR SOME ITEMS
<Bug 20555822> - QPXLPLHS: CLOSE CURSOR C_LINES_SDATES_CUR
<Bug 20612360> - 12.2.4: UNABLE TO CREATE PRICE BOOK
<Bug 20639914> - COPY MODIFIER(SHIFT+F6) OPEN
<Bug 20851362> - MODIFIER NOT APPLIED
<Bug 21423613> - PRICE BOOK ANOTHER PRICE LIST NOT JUST THE ONE IN
                                   PRICING BASIS
<Bug 21848532> - QPXPACRL INCREASE CUSTOMER NAME TO 360
<Bug 21876475> - PRG AND RELATED DETAILS BUTTON IN VIEW ADJUSTMENT
                                   WINDOW
<Bug 22079596> - UNABLE COPY/PASTE MODIFIER NUMBER SIZE IS MORE THAN
                                   FIELD IN PRICING ORGANIZER
<Bug 22474702> - MODIFIERS WITH LINE LEVEL QUALIFIERS NOT APPLY
<Bug 23293526> - FORMS SERVER ERROR/PRICE LIST FORM AND QUALIFIER FORM
                                   CHOOSING SEEDED QUALIERS

<Patch 23210222:R12.QP.C> - Released
Advanced Pricing Recommended Patch Collection May, 2016

The following bugs are fixed by this patch:

<Bug 16179517> -PRICING MAINTENANCE> - INTERNAL SERVER ERROR
<Bug 17347084> -DEFINE MODIFIER FORM GIVES ERROR WHEN CREATING
                           NEW PRICE BREAK LINE USING COPY F
<Bug 17438551> -   CREATING PRICE BOOK FOR SALES AGREEEMENT MISMATCH
<Bug 17759450> -  ORACLE STANDARD PRICE LIST REPORT MISSING FIELD AND
                                   DISPLAYS ID'S NOT THE VALUE
<Bug 17774383> -  MANUAL MODIFIER WITH FORMULA IS NOT PASSING VALUE
<Bug 17857932> -  PRICE LIST FORM GIVES ERROR WHEN CREATING
                                   NEW PRICE BREAK LINE
                                   USING SHIFT F6
<Bug 17943603> - MODIFIER QUALIFIER: LINE TYPE IN RED
<Bug 17947726> - MULTI-CURRENCY CONVERSION ISSUE - WRONG CURRENCY
                                   CONVERSION RATE IS USED
<Bug 17988381> - FRM-40405: 'NO CHANGES TO APPLY' MESSAGE RECEIVED ON
                                  PRICING ORGANIZER
<Bug 18126335> - DECIMAL PRECISION DIFFERENT ON P&A VS SALES ORDER
<Bug 18235252> - CREATE MODIFIER GET ERROR PRODUCT ATTRIBUTE VALUE IS
                                   INVALID
<Bug 18287889> - UNABLE TO MODIFY/UPDATE FIELDS IN THE HEADER LEVEL IN
                                   PRICE LIST
<Bug 18391008> - ACCUMULATED RANGE BREAK CALCULATIONS USING RUNTIME
                                     SOURCED VALUE NOT AVAILBLE FO
<Bug 18401920> - ERROR WHEN ADDING QUALIFIER AS A LIST / LINE LIMITS
                                   CONDITION
<Bug 18424132> -   ARCHIVE PRICING ENTITY CONCURRENT PROGRAM DISABLED
                                    AFTER  UPGRADE
<Bug 18425959> - PRICING ATTRIBUTE MANAGEMENT SETUP WINDOW DOES NOT
                                   AUTO-QUERY
<Bug 18451612> - ORA-06502 WHEN CALLING
                                   QP_PRICE_BOOK_PUB.GET_PRICE_BOOK API
<Bug 18454567> - R12.2.3 CANNOT GET LIST PRICE WHEN ORDER IS BOOKED
<Bug 18483269> - PRODUCT VALUE LOV IS NOT WORKING USING FIND SEARCH
                                   AKA TORCH ICON FUNCTIONALITY
<Bug 18508650> - ADD ITEMS TO PRICE LIST FAILS WITH ORA-06502
<Bug 18552704> - UNEXPECTED ERROR IN AUTOCREATE RAISED FROM ADVANCED
                                  PRICING
<Bug 18614841> - ERROR DISPLAYS WHEN DELET SECONDARY PRICE LIST
<Bug 18641502> - FINISH CONFIGURATION IN ISTORE TAKES MORE THAN 1 MINUTE
                                   EXPECTING UNDER 20 SEC
<Bug 18661338> - PRICE LIST CREATED WITH OVERLAPPING DATES BY BULK
                                   IMPORT PROCESS
<Bug 18696348> - PL> - PRICING ATTRIBUTE> - LOV NULL WHEN NAVIGATING
                                  AWAY FROM THE VALUE FROM FIELD
<Bug 18800485> - R12 PBH NOT APPLIED WITH FREIGHT CHARGE ON FIRST LINER
                                  MODIFIER
<Bug 18960371> - QPXSSDAF: CAN SAVE AGREEMENT WITHOUT POPULATING 
                                   REQUIRED FIELDS
<Bug 18968303> - NO LOV IN PRICING ATTRIBUTE FOR CUSTOMER ITEMS IN 12.1.3
<Bug 19032170> - QPXPRFOR: QUERY ONLY AND CAN STILL CHANGE FORMULA
                                  AND SAVE
<Bug 19144544> - PRICING MODIFIER FORM PERFORMANCE ISSUE
                                   PRODUCT ATTRIBUTE VALUE - ITEM CATEGORY
<Bug 19191555> - NOTE:551721 CUSTOM PL/SQL ATTRIBUTE CANCEL ISSUE FOR
                                   PROMOTIONAL GOODS
<Bug 19323551> - ERROR WHILE USING NVL2 SQL FUNCTION IN ORACLE
                                  PRICING FORMULA
<Bug 19404639> - FACTOR LIST RETURNED NULL VALUE WHEN FACTOR
                                   OPERATOR BETWEEN AND VALUE TO NULL
<Bug 19452284> - RMA APPLIES DISCOUNT TWICE WHEN USING    
                                  OE_ORDER_PUB.PROCESS_ORDER API OR REPRICE
<Bug 19491198> - QPXPRLST: CANNOT QUERY PRICE LIST LINES BY DYNAMIC
                                  FORMULA NAME
<Bug 19518944> - UNABLE TO CAPTURE FACTOR LIST HEADER_ID LINE_ID IN
                                  QP_NFORMULA_STEP_VALUES_TMP
<Bug 19555418> - CREATE INTERCOMPANY IS HAVING PERFORMANCE ISSUE
<Bug 19691135> - PRICING PERFORMANCE ISSUE USING
                                   OE_ORDER_PUB.PROCESS_ORDER API
<Bug 19716853> - MODIFIER DETAILS REPORT STANDARD REPORT FOR MODIFIER
                                   CANNOT BE PRINTED
<Bug 19724468> - NOT ABLE TO UPDATE PRICING SECURITY USING ORACLE
                                   PRICING ADMINISTRATOR
<Bug 19770132> - API PRICING - UNABLE TO CREATE PRICE AGREEMENT
                                   USING KOREAN CHARACTERS
<Bug 19790706> - PRICING MODIFIER ON INVENTORY CATEGORY NOT WORKING
<Bug 19795605> - PERFORMANCE ISSUE WITH PRICE LIST REPORT
<Bug 19881017> - COULD NOT ENTER & BOOK SO FOR THE ITEM DEFINED WITH
                                   LINE TYPE 'PRICE BREAK HEADER
<Bug 19953132> - PERFORMANCE ISSUE IN PRICE LIST UPLOAD
<Bug 20054252> - PRICING PERFORMANCE API CALLS
                                   QP_PREQ_PUB.PRICE_REQUEST  FOR PRICE BOOKS.
<Bug 20512653> - CANNOT SAVE ORDER LINES FOR SOME ITEMS
<Bug 20555822> - QPXLPLHS: CLOSE CURSOR C_LINES_SDATES_CUR
<Bug 20612360> - 12.2.4: UNABLE TO CREATE PRICE BOOK
<Bug 20639914> - COPY MODIFIER(SHIFT+F6) OPEN
<Bug 20851362> - MODIFIER NOT APPLIED
<Bug 21848532> - QPXPACRL INCREASE CUSTOMER NAME TO 360
<Bug 21876475> - PRG AND RELATED DETAILS BUTTON IN VIEW
                                  ADJUSTMENT WINDOW
<Bug 22079596> - UNABLE COPY/PASTE MODIFIER NUMBER SIZE IS MORE THAN
                                   FIELD IN PRICING ORGANIZER
<Bug 22474702> - MODIFIERS WITH LINE LEVEL QUALIFIERS NOT APPLY

<Patch 20816691:R12.QP.C> - Superceded
 Advanced Pricing Recommended Patch Collection May, 2015

The following bugs are fixed by this patch:


<Bug 14226015> - REVALUE IS NOT WORKING WHEN THE CURRENCY IS BACK
                                   TO ORIGINAL CURRENCY
<Bug 16214663> - ALLOW SERVICE ITEM AS GET ITEM IN PROMOTIONAL MODIFIER PROJECT
<Bug 16300774> - QRE1222.0:QPX.GENF.2:FORMS GEN FAILURE FOR QPX - AUTOBUILD
<Bug 16342095> - QRE1222.0:QP.INV.24:INVALID OBJECTS FOUND BY AUTOBUILD
<Bug 16386601> - OKS:VRM:UPTAKE FOR CREATE BILLING DATA FILE
<Bug 17347084> - DEFINE MODIFIER FORM GIVES ERROR WHEN CREATING NEW
                                  PRICE BREAK LINE USING COPY
<Bug 17857932> - PRICE LIST FORM GIVES ERROR WHEN CREATING NEW PRICE BREAK
                                   LINE USING SHIFT F6
<Bug 17958189> - CONSOLIDATED PATCH FOR 12.2.3 WITH DEPENDENCY RULES
<Bug 18483269> - PRODUCT VALUE LOV IS NOT WORKING USING FIND SEARCH
                                   AKA TORCH ICON FUNCTIONALITY
<Bug 19724468> - NOT ABLE TO UPDATE PRICING SECURITY USING
                                  ORACLE PRICING ADMINISTRATOR
<Bug 19953132> - PERFORMANCE ISSUE IN PRICE LIST UPLOAD
<Bug 20267912> - NO DATA INOZF_ORDER_GROUP_PROD WHEN QP:ACCUMULATION
                                   ATTRIBUTES ENABLED SET TO Y
<Bug 20503385> - SUPPORT FOR SUBSCRIPTIONS AS PROMOTIONAL ITEMS IN SALES ORDER
<Bug 20547267> - 1OFF:17857932:PRICE LIST FORM GIVES ERROR WHEN CREATING
                                  NEW PRICE BREAK LINE
<Bug 20555822> - QPXLPLHS: CLOSE CURSOR C_LINES_SDATES_CUR
<Bug 20607476> - QP 12.2.5 PROJECT "ALLOW SUBSCRIPTION ITEM AS GET ITEM
                                   IN PROMOTIONAL MODIFIER"
<Bug 20612360> - 12.2.4: UNABLE TO CREATE PRICE BOOK
<Bug 20639914> - COPY MODIFIER(SHIFT+F6) OPEN
<Bug 20695264> - QRE1225.4:QP.INV.23:INVALID OBJECTS FOUND BY AUTOBUILD

<Patch 18912074:R12.QP.C> - Superceded
Advanced Pricing Recommended Patch Collection Sept 2014

The following bugs are fixed by this patch:

<Bug 18454567> - R12.2.3 Cannot Get List Price When Order Is Booked
<Bug 17984822> - Interface Trip Stop Log Split Issue Due to Pricing Engine Call

 

 

 

 

  

 

 

 

 

 

Release 12.1 - RPL Patch(s) for Advanced Pricing 12.1

 

Patch and Status  Fixes Provided with Patch
<Patch 27330740>:R12.QP.B - Advanced Pricing Recommended Patch Collection Jan,2018

The following bugs are fixed by this patch:

<Bug 10023220> - PROMOTIONAL LIMIT VIOLATION ERROR COMES UP AT ORDER ENTRY PROCESS
<Bug 10042660> - FRM-40212 IN QPXPRMLS FOR PROD ATTR VALUE
<Bug 10051804> - INTERFACE TRIP STOP ENDS IN WARNING WITH CST_XFER_PRICE_ERROR ERROR
<Bug 10056032> - OPEN PRICE LIST ERRORS: ORA-01722: INVALID NUMBER FRM-40505: ORACLE ERROR UNAB
<Bug 10093463> - LIST PRICE IS NOT ROUNDED TO CONVERSION ROUDING FACTOR AFTER APPLYING MULTI-CURR
<Bug 10120724> - ACP> - UNABLE TO LOAD PRICE LISTS
<Bug 10130826> - MODIFIER APPLIED IN ISTORE GETS DROPPED IN OM WHEN ORDER IS REPRICED
<Bug 10154917> - POOR PERFORMANCE FOR CREATE INTERCOMPANY AR INVOICES PROGRAM WITH QP SQL.
<Bug 10171380> - QPXVBLK: PERFORMANCE ISSUE QP BULK LOAD TOO SLOW
<Bug 10255367> - PRICE LIST SETUP FORM NOT VALIDATING/DISPLAYING DECIMAL ACCORDING TO PROFILE SY
<Bug 10269226> - PRICE BOOK IS NOT BEING GENERATED
<Bug 10273166> - PRICING FORMULAS NOT RECOGISING PRICING ATTRIBUTES IN FACTOR LIST
<Bug 10377566> - R12.1 PROMO HAS SPECIAL CHAR(CHR (0)) QP_LIST_LINES INCLUDE_ON_RETURNS_FLAG
<Bug 10394643> - AFTER APPLYING THE PATCH 10136863 SOME PROBLEM IS OCCURRING IN PROMOTION ITEM CA
<Bug 10625896> - PERF ISSUE WITH OE_AGREEMENTS_B MERGE AFFECTING CUSTOMER MERGE AND FIELD
<Bug 11718911> - ADJUST PRICE LIST GIVES FRM-40831: TRUNCATION OCCURRED: VALUE TOO LONG FOR FIELD
<Bug 11719249> - MODIFIER APPLYING: IGNORING CATEGORY SET ASSIGNMENT IN MASTER ITEMS FORM
<Bug 11734858> - ADD ITEMS TO PRICE LIST PROGRAM UPDATES RECORD HISTORY OF ALL PRICE LIST LINES
<Bug 11828647> - ER: SUPPRESS THE PRINT ON INVOICE FLAG FROM THE MODIFIER UI.
<Bug 11898355> - UNABLE TO PRICE USING ADVANCED PRICING WHEN MIGRATING TO R12.1.1
<Bug 12433027> - RANGE BREAK MODIFIER DOES NOT APPLY IF LIST PRICE IS NEGATIVE
<Bug 12539111> - RECEIVING ERROR MESSAGES WHEN OPENING MULTI-CURRENCY CONVERSION FORM
<Bug 12661047> - R12-NOA-OLTP-DEV-OM ERROR MESSAGE FOR> - QP: MAINTAINS THE DENORMALIZED DATA IN Q
<Bug 12670913> - RETURN FREIGHT CHARGE ROUNDING INCORRECTLY
<Bug 12677276> - INTERFACE TRIP STOP RUNNING LONG CAUSING PEFORMANCE ISSUES
<Bug 12710486> - ATTRIBUTE QUALIFIER ATTRIBUTE IS INVALID.
<Bug 12766733> - DROP SHIP RECEIPTS ERRORS RVTII-060: SUBROUTINE INV_TXN_MANAGER_PUB
<Bug 12778935> - QP: BULK IMPORT OF PRICE LIST> - BAD PERFORMANCE
<Bug 12784810> - R12 DIFFERENT ERROR MESSAGE WHEN CREATING PRICING AGREEMENT REVISION THAN R11
<Bug 12875196> - YOU HAVE ENCOUNTERED AN UNEXPECTED ERROR. PLEASE CONTACT THE SYSTEM ADMINSTRATOR
<Bug 12916970> - :HARD> - ADJUST BENEFIT AMOUNT NOT WORKING AS EXPECTED R12 12352707
<Bug 12951945> - RELEASE 12: PRICE LISTS REPORT FETCHING DETAILS OF END DATED LIST LINES
<Bug 13045009> - PERFORMANCE ISSUE WITH ARCHIVING OF A PRICELIST
<Bug 13110812> - OKL HEADER MULTI-CURRENCY CONVERION CHANGED BY QP_PRICE_LIST_PUB
<Bug 13250347> - ERROR MESSAGE IN GERMAN LANGUAGE INSTEAD ENGLISH
<Bug 13371371> - MODIFIER LIMIT GETTING CONSUMED BY 0 PRICE LINE
<Bug 13395264> - QP: UPGRADE PRICING DATA FOR BULK LOADER DIDN'T UPDATE ALL ORIG_SYS_HEADER_
<Bug 13487501> - BAD PERFORMANCE IN PRICE LISTS QPXPRLST
<Bug 13507103> - NOT ALL ITEM CATEGORY LOV WORK IN THE ADD ITEMS TO PRICE LIST
<Bug 13508707> - RMA RECEIVED BUT THE LIMIT MODIFIER AVAILABLE DIDN'T ADD
<Bug 13521835> - PARTIAL UNITS SEEN IN AVAILABLE & CONSUMED QUANTITY IN PRICING MODIFIER SCREEN
<Bug 13532774> - QPXPRFOR.FMB FACTOR LIST FIND ERRORS WITH FRM-40350
<Bug 13585536> - ADD QULAIFIER TO PRICE LIST -ATTRIBUTE VALUE FROM INVALID PLEASE RE-ENTER
<Bug 13655307> - PRICING ERRORS WHILE COPYING AN EXISTING RETURN TYPE ORDER
<Bug 13703332> - R12-ATTRIBUTE VALUE FROM SHOWS RED/AFTER PATCH 13585536 FOR INVALID ERROR
<Bug 13776174> - PBH MODIFR LINES W/CUSTOM VOLUME ATTR NOT APPLY CORRECTLY AFTER PATCH 12916970
<Bug 13818038> - GSA PRICE LIST HAVE DUPLICATES FOR ONE ITEM¿BUT CANNOT DELETE THIS RECORD
<Bug 13820039> - ISSUE WITH LOV FOR ITEM CATEGORY AFTER APPLYING PATCH 13507103
<Bug 13860628> - PRICE BREAK LINES ISSUES IN PRICELIST BULK IMPORT
<Bug 13877124> - IN BLOCK PRICING, CAN'T ENTER .25 IN THE RECURRING VALUE.
<Bug 13881910> - DFF FIELD FOR ADDITIONAL INFO FOR LIST LINES WILL NOT STAY POPULATED
<Bug 13959133> - MODIFIER DETAILS REPORT SHOWING WRONG FORMAT AFTER PAGE BREAKS
<Bug 13977250> - ICX: NUMERIC CHARACTERS AND GENERAL PREFERENCES NUMBER FORMAT
<Bug 13996811> - QUALIFIER GROUPING REPORT: QUALIFIER ATTRIBUTE VALUE TO PARAMETER
<Bug 14054072> - BEST PRICE SUPPLIER SHIP AND DEBIT MODIFIER DOES NOT APPLY TO SALES ORDER LINE.
<Bug 14065769> - QP: MAINTAINS THE DENORMALIZED DATA NOT WORKING FOR MULTI ORG SECURITY RULES
<Bug 14102682> - PROMOTIONAL LIMITS ARE NOT BEING APPLIED CORRECTLY
<Bug 14103598> - ADV. PRICING PRICE BREAKS FIRST BREAK HAS TO START WITH ZERO/NO GAPS ALLOWED I
<Bug 14169474> - APP-QP-225737 NO ATTRIBUTES ARE DEFINED FOR THIS CONTEXT INSERT PRICE BREAK
<Bug 14367359> - APPLICATION LOCKS WHILE CREATING BPAS QP_DELAYED_REQUESTS_UTIL.UPDATE_MANUAL_MOD
<Bug 14393164> - LONG COMPLETION TIMES FOR INTERFACE TRIP STOP WHEN DEBUGS ARE ON
<Bug 14396941> - TPA FOR RESALE TABLE> - PERF ISSUE IN QP ENGINE CALL
<Bug 14464004> - PRICE BOOK GENERATION NOT TAKING PLACE
<Bug 14611180> - QP_LIST_LINES_V GIVES ERROR ORA-01427: SINGLE-ROW SUBQUERY RETURN MORE THAN ONE
<Bug 14623252> - USE API IN R12 TO ADD PRICE LINES TO MIGRATED 11I PRICE LISTS
<Bug 14686371> - FOLDER CONDITION NOT WORKING IN PRICE LIST FORM
<Bug 14763873> - QPXUPQUL.SQL :12.1.3 UPGRADE QUAL_ATTR_VALUE_FROM_NUMBER IS NULL IN QP_QUALIFIER
<Bug 14783146> - FORM LOCKING IN ORDER MANAGEMENT DUE TO TABLE UPDATE OZF_ORDER_GROUP_PROD
<Bug 14842950> - ORDER IMPORT PERFORMANCE ISSUE DURING PRICING ENGINE CODE
<Bug 15895472> - OM LINES NOT PROPERLY QUALIFIED
<Bug 15918451> - MODIFIER DETAIL REPORT ERROR REP-0091: WHEN MODIFER NAME > 40 CHARACTERS
<Bug 15993256> - POOR PERFORMANCE AS 50 FACTOR LIST LINES USING API, IT TOOK ALMOST 1 HOUR TO COM
<Bug 16022996> - PERFORMANCE ISSUE WITH PROCESS_MODIFIERS PUBLIC API
<Bug 16047733> - PO LINE COMES OUT AS INCORRECT WHEN MULTIPLE PO'S ARE CREATED AND WHEN QP_RUNTIM
<Bug 16051721> - MODIFIER WITH ACCUMULATION ATTRIBUTE SAVES ACCUM_ATTR_RUN_SRC_FLAG SET TO 'N'
<Bug 16179517> - PRICING MAINTENANCE> - INTERNAL SERVER ERROR
<Bug 16246361> - PERFORMANCE ISSUE IN THE ITEM PRICE LIST API.
<Bug 16462621> - API PASSES THE VALUE 'Y' TO CONTINUOUS_PRICE_BREAK_FLAG FOR PBH AN
<Bug 16570491> - QP: BULK IMPORT OF PRICE LIST DELETE PRICE LINE BUT LEFT PRICE ATTRIBUTE LINE
<Bug 16590557> - FAILED TO RESOLVE INCOMPATIBILITY BETWEEN PRICE LISTS( ) DUPLICATE PRICE LIST LI
<Bug 16590629> - FP :11683415 : PROMOTIONAL ITEMS ARE GETTING DUPLICATED AND ADDED
<Bug 16657649> - PRICE BOOK SEARCH RETURNING INCORRECT RESULTS BASED ON EFFECTIVITY END DATE
<Bug 16658815> - AFTER PATCH 15993256 APPLIED, FACTORS ARE NOT APPLYING AS EXPECTED
<Bug 16803836> - STANDARD CP 'QP: BULK IMPORT OF PRICE LIST' THROWING ERROR
<Bug 16815807> - AD ADMINISTRATION UTILITY TO MAINTAIN MULTI-LINGUAL TABLES PERFORMANCE QPNLINS
<Bug 16863566> - ISSUE WITH QP: MAINTAINS THE DENORMALIZED DATA IN QP QUALIFIERS POST UPGRADE
<Bug 17065533> - CHANGING THE SHIP-TO ADDRESS RE-PRICE THE SO LINE UNIT SELLING PRICE
<Bug 17222241> - QUOTING- PRICE IS NOT FOUND ON PRICE LIST WHEN PRICE BREAK STARTS WITH '0'.
<Bug 17347084> - DEFINE MODIFIER FORM GIVES ERROR WHEN CREATING NEW PRICE BREAK LINE USING COPY F
<Bug 17586726> - ADD ITEMS TO PRICE LIST CAN BE RUN WITHOUT INPUT PARAMETERS
<Bug 17852131> - ITEM CATEGORY SEARCH ON PRICE LISTS, SHOWS PREVIOUS RESULTS
<Bug 17880179> - R12: PRICE LIST ISSUE WITH FAILED TO RESOLVE INCOMPATIBILITY BETWEEN PRICELISTS
<Bug 17947726> - MULTI-CURRENCY CONVERSION ISSUE> - WRONG CURRENCY CONVERSION RATE IS USED
<Bug 18056482> - COPY PRICE LIST FORM QPXPRCPL: ITEM CATEGORY LOV SHOWS NO VALUES
<Bug 18235252> - CRREATE MODIFIER GET ERROR PRODUCT ATTRIBUTE VALUE IS INVALID
<Bug 18287889> - UNABLE TO MODIFY/UPDATE FIELDS IN THE HEADER LEVEL IN PRICE LIST
<Bug 18391008> - ACCUMULATED RANGE BREAK CALCULATIONS USING RUNTIME SOURCED VALUE NOT AVAILBLE FO
<Bug 18508650> - ADD ITEMS TO PRICE LIST FAILS WITH ORA-06502
<Bug 18641502> - FINISH CONFIGURATION IN ISTORE TAKES MORE THAN 1 MINUTE EXPECTING UNDER 20 SEC
<Bug 18661338> - PRICE LIST CREATED WITH OVERLAPPING DATES BY BULK IMPORT PROCESS
<Bug 18800485> - R12 PBH NOT APPLIED WITH FREIGHT CHARGE ON FIRST LINER MODIFIER
<Bug 19032170> - QPXPRFOR: QUERY ONLY AND CAN STILL CHANGE FORMULA AND SAVE
<Bug 19323551> - ERROR WHILE USING NVL2 SQL FUNCTION IN ORACLE PRICING FORMULA
<Bug 19555418> - CREATE INTERCOMPANY IS HAVING PERFORMANCE ISSUE
<Bug 20512653> - CANNOT SAVE ORDER LINES FOR SOME ITEMS
<Bug 20561454> - PUBLISH PRICE BOOK ERROR ORA-29532> - JAVA.LANG.OUTOFMEMORYERROR
<Bug 21481284> - REDEEM ACCRUAL EXPIRATION DATE: ONLY PROVIDE EXPIRATION PERIOD AND PERIOD TYPE
<Bug 21848532> - QPXPACRL INCREASE CUSTOMER NAME TO 360
<Bug 22256913> - MORE RECORDS ARCHIVED THAN EXPECTED
<Bug 22474702> - MODIFIERS WITH LINE LEVEL QUALIFIERS NOT APPLY
<Bug 22732532> - PROMO MODIFIER> - CHANGE QTY ADDS LINE
<Bug 22984342> - PERFORMANCE ISSUES WITH SALES ORDER FORM DURING PRICING CALL
<Bug 23153621> - POOR PERFORMANCE UPDATING LINE LIST PRICE ON PRICE LISTS HTML USER INTERFACE
<Bug 23253599> - SHIFT F6 NOT RESTRICTING DUPLICATE PRICE LIST LINE> - DELETE DUPLIATE STILL THERE
<Bug 23272198> - DISCOUNT MODIFIER NOT WORKING AS EXPECTED FOR ORDER AMOUNT ATTRIBUTE
<Bug 23322366> - BUILD ATTRIBUTE MAPPING RULES PERFORMANC AFTER ADVANCED PRICING RUP PATCH
<Bug 24393978> - LINE LEVEL QUALIFIERS NOT WORKING FOR EXISTING MODIFIERS
<Bug 24399500> - PERFORMANCE ISSUE : LARGE ORDER CUSTOMER REQUEST DATE UPDATE
<Bug 24825939> - QP: BULK LOADER NOT LOADING PRIMARY_UOM_FLAG WHEN PRICING IS SHARED INSTALL
<Bug 25023643> - QP : BULK IMPORT PERFORMANCE
<Bug 25441962> - REDEEM ACCRUAL EXPIRATION DATE: ONLY PROVIDE EXPIRATION PERIOD AND PERIOD TYPE
<Bug 25806980> - PRICEBOOK ERROR:PUBLISH_AND_DELIVER RETURN STATUS E
<Bug 26030081> - PERFORMANCE FOR CUSTOM PRICE BOOK USING API QP_PREQ_PUB.PRICE_REQUEST
<Bug 26099068> - PUBLISH PRICE BOOK 48K LINES ERROR ORA-29532> - JAVA.LANG.OUTOFMEMORYERROR
<Bug 26180309> - QP: MAINTAINS THE DENORMALIZED DATA IN QP QUALIFIERS COMPLETED WITH ERROR
<Bug 26533427> - POOR PERFORMANCE DURING ORDER IMPORT
<Bug 8645132> - 12.1.1:OF:FORMULA FACTOR LISTS NOT WORKING AS EXPECTED-GIVES ERRORS ON ORDER
<Bug 8688432> - QPXVAPLB MODULE: ADJUST PRICE LIST COMPLETES WITH ERROR
<Bug 9316468> - RE-PRICING LINES ON LARGE SALES ORDERS SLOW AFTER UPGRADE FROM 11.5.9 TO 12.0.6
<Bug 9475080> - OEXOEORD GET ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR WHEN PRICE DECIMAL QTY
<Bug 9645844> - ADVANCED PRICING MODIFIER LIMITS CONSUMED AMOUNT IS INCORRECT
<Bug 9660503> - PROMOTION MODIFIER -> DEFINE DETAILS FORM DOES NOT SHOW RECORDS UNTIL QUERIED.
<Bug 9679930> - LAUNCH OF CONFIGURATOR THROUGH SALES ORDER TAKES MORE THAN 15MINUTES
<Bug 9680271> - ARCHIVE AND PURGE ENTITTY ISSUES
<Bug 9694761> - PRICE LISTS (XML) RUNNING INTO ERROR FOR ANY PARAMETER
<Bug 9729769> - UPGRADE DRIVER U6678700 FAILING AT QPXDUPLA ORA-00001
<Bug 9732576> - NEED TO ADD WHERE CONDITION IN QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS
<Bug 9832529> - AFTER PATCH 9694761:R12.QP.B START DATE AND END DATE XML VERSION IS 1 DAY PRIO
<Bug 9848873> - R12 MODIFIER PRODUCT ATTRIBUTE VALUE CANNOT BE UPDATED ONCE WARNING MESSAGE IS G
<Bug 9938422> - SYSTEM IS NOT PROVIDING FULL LUMPSUM DISCOUNT ON A SINGLE SALES ORDER
<Bug 9970746> - LOW PERFORMANCE ON SAVING OM ORDER LINES
<Bug 9977712> - OEXOEORD: PRICING QUANTITY DOES NOT ROUND TO WHOLE NUMBERS

 

<Patch 23733826>:R12.QP.B - Advanced Pricing Recommended Patch Collection July, 2016


The following bugs are fixed by this patch:

<Bug 10023220> - PROMOTIONAL LIMIT VIOLATION ERROR COMES UP AT ORDER ENTRY PROCESS
<Bug 10042660> - FRM-40212 IN QPXPRMLS FOR PROD ATTR VALUE
<Bug 10051804> - INTERFACE TRIP STOP ENDS IN WARNING WITH CST_XFER_PRICE_ERROR ERROR
<Bug 10056032> - OPEN PRICE LIST ERRORS: ORA-01722: INVALID NUMBER FRM-40505: ORACLE ERROR UNAB
<Bug 10093463> - LIST PRICE IS NOT ROUNDED TO CONVERSION ROUDING FACTOR AFTER APPLYING MULTI-CURR
<Bug 10120724> - ACP> - UNABLE TO LOAD PRICE LISTS
<Bug 10130826> - MODIFIER APPLIED IN ISTORE GETS DROPPED IN OM WHEN ORDER IS REPRICED
<Bug 10154917> - POOR PERFORMANCE FOR CREATE INTERCOMPANY AR INVOICES PROGRAM WITH QP SQL.
<Bug 10171380> - QPXVBLK: PERFORMANCE ISSUE QP BULK LOAD TOO SLOW
<Bug 10255367> - PRICE LIST SETUP FORM NOT VALIDATING/DISPLAYING DECIMAL ACCORDING TO PROFILE SY
<Bug 10269226> - PRICE BOOK IS NOT BEING GENERATED
<Bug 10273166> - PRICING FORMULAS NOT RECOGISING PRICING ATTRIBUTES IN FACTOR LIST
<Bug 10377566> - R12.1 PROMO HAS SPECIAL CHAR(CHR (0)) QP_LIST_LINES INCLUDE_ON_RETURNS_FLAG
<Bug 10394643> - AFTER APPLYING THE PATCH 10136863 SOME PROBLEM IS OCCURRING IN PROMOTION ITEM CA
<Bug 10625896> - PERF ISSUE WITH OE_AGREEMENTS_B MERGE AFFECTING CUSTOMER MERGE AND FIELD
<Bug 11718911> - ADJUST PRICE LIST GIVES FRM-40831: TRUNCATION OCCURRED: VALUE TOO LONG FOR FIELD
<Bug 11719249> - MODIFIER APPLYING: IGNORING CATEGORY SET ASSIGNMENT IN MASTER ITEMS FORM
<Bug 11734858> - ADD ITEMS TO PRICE LIST PROGRAM UPDATES RECORD HISTORY OF ALL PRICE LIST LINES
<Bug 11828647> - ER: SUPPRESS THE PRINT ON INVOICE FLAG FROM THE MODIFIER UI.
<Bug 11898355> - UNABLE TO PRICE USING ADVANCED PRICING WHEN MIGRATING TO R12.1.1
<Bug 12433027> - RANGE BREAK MODIFIER DOES NOT APPLY IF LIST PRICE IS NEGATIVE
<Bug 12539111> - RECEIVING ERROR MESSAGES WHEN OPENING MULTI-CURRENCY CONVERSION FORM
<Bug 12661047> - R12-NOA-OLTP-DEV-OM ERROR MESSAGE FOR> - QP: MAINTAINS THE DENORMALIZED DATA IN Q
<Bug 12670913> - RETURN FREIGHT CHARGE ROUNDING INCORRECTLY
<Bug 12677276> - INTERFACE TRIP STOP RUNNING LONG CAUSING PEFORMANCE ISSUES
<Bug 12710486> - ATTRIBUTE QUALIFIER ATTRIBUTE IS INVALID.
<Bug 12766733> - DROP SHIP RECEIPTS ERRORS RVTII-060: SUBROUTINE INV_TXN_MANAGER_PUB
<Bug 12778935> - QP: BULK IMPORT OF PRICE LIST> - BAD PERFORMANCE
<Bug 12784810> - R12 DIFFERENT ERROR MESSAGE WHEN CREATING PRICING AGREEMENT REVISION THAN R11
<Bug 12875196> - YOU HAVE ENCOUNTERED AN UNEXPECTED ERROR. PLEASE CONTACT THE SYSTEM ADMINSTRATOR
<Bug 12916970> - :HARD> - ADJUST BENEFIT AMOUNT NOT WORKING AS EXPECTED R12 12352707
<Bug 12951945> - RELEASE 12: PRICE LISTS REPORT FETCHING DETAILS OF END DATED LIST LINES
<Bug 13045009> - PERFORMANCE ISSUE WITH ARCHIVING OF A PRICELIST
<Bug 13110812> - OKL HEADER MULTI-CURRENCY CONVERION CHANGED BY QP_PRICE_LIST_PUB
<Bug 13250347> - ERROR MESSAGE IN GERMAN LANGUAGE INSTEAD ENGLISH
<Bug 13371371> - MODIFIER LIMIT GETTING CONSUMED BY 0 PRICE LINE
<Bug 13395264> - QP: UPGRADE PRICING DATA FOR BULK LOADER DIDN'T UPDATE ALL ORIG_SYS_HEADER_
<Bug 13487501> - BAD PERFORMANCE IN PRICE LISTS QPXPRLST
<Bug 13507103> - NOT ALL ITEM CATEGORY LOV WORK IN THE ADD ITEMS TO PRICE LIST
<Bug 13508707> - RMA RECEIVED BUT THE LIMIT MODIFIER AVAILABLE DIDN'T ADD
<Bug 13521835> - PARTIAL UNITS SEEN IN AVAILABLE & CONSUMED QUANTITY IN PRICING MODIFIER SCREEN
<Bug 13532774> - QPXPRFOR.FMB FACTOR LIST FIND ERRORS WITH FRM-40350
<Bug 13585536> - ADD QULAIFIER TO PRICE LIST -ATTRIBUTE VALUE FROM INVALID PLEASE RE-ENTER
<Bug 13655307> - PRICING ERRORS WHILE COPYING AN EXISTING RETURN TYPE ORDER
<Bug 13703332> - R12-ATTRIBUTE VALUE FROM SHOWS RED/AFTER PATCH 13585536 FOR INVALID ERROR
<Bug 13776174> - PBH MODIFR LINES W/CUSTOM VOLUME ATTR NOT APPLY CORRECTLY AFTER PATCH 12916970
<Bug 13818038> - GSA PRICE LIST HAVE DUPLICATES FOR ONE ITEM¿BUT CANNOT DELETE THIS RECORD
<Bug 13820039> - ISSUE WITH LOV FOR ITEM CATEGORY AFTER APPLYING PATCH 13507103
<Bug 13860628> - PRICE BREAK LINES ISSUES IN PRICELIST BULK IMPORT
<Bug 13877124> - IN BLOCK PRICING, CAN'T ENTER .25 IN THE RECURRING VALUE.
<Bug 13881910> - DFF FIELD FOR ADDITIONAL INFO FOR LIST LINES WILL NOT STAY POPULATED
<Bug 13959133> - MODIFIER DETAILS REPORT SHOWING WRONG FORMAT AFTER PAGE BREAKS
<Bug 13977250> - ICX: NUMERIC CHARACTERS AND GENERAL PREFERENCES NUMBER FORMAT
<Bug 13996811> - QUALIFIER GROUPING REPORT: QUALIFIER ATTRIBUTE VALUE TO PARAMETER
<Bug 14054072> - BEST PRICE SUPPLIER SHIP AND DEBIT MODIFIER DOES NOT APPLY TO SALES ORDER LINE.
<Bug 14065769> - QP: MAINTAINS THE DENORMALIZED DATA NOT WORKING FOR MULTI ORG SECURITY RULES
<Bug 14102682> - PROMOTIONAL LIMITS ARE NOT BEING APPLIED CORRECTLY
<Bug 14103598> - ADV. PRICING PRICE BREAKS FIRST BREAK HAS TO START WITH ZERO/NO GAPS ALLOWED I
<Bug 14169474> - APP-QP-225737 NO ATTRIBUTES ARE DEFINED FOR THIS CONTEXT INSERT PRICE BREAK
<Bug 14367359> - APPLICATION LOCKS WHILE CREATING BPAS QP_DELAYED_REQUESTS_UTIL.UPDATE_MANUAL_MOD
<Bug 14393164> - LONG COMPLETION TIMES FOR INTERFACE TRIP STOP WHEN DEBUGS ARE ON
<Bug 14396941> - TPA FOR RESALE TABLE> - PERF ISSUE IN QP ENGINE CALL
<Bug 14464004> - PRICE BOOK GENERATION NOT TAKING PLACE
<Bug 14611180> - QP_LIST_LINES_V GIVES ERROR ORA-01427: SINGLE-ROW SUBQUERY RETURN MORE THAN ONE
<Bug 14623252> - USE API IN R12 TO ADD PRICE LINES TO MIGRATED 11I PRICE LISTS
<Bug 14686371> - FOLDER CONDITION NOT WORKING IN PRICE LIST FORM
<Bug 14763873> - QPXUPQUL.SQL :12.1.3 UPGRADE QUAL_ATTR_VALUE_FROM_NUMBER IS NULL IN QP_QUALIFIER
<Bug 14783146> - FORM LOCKING IN ORDER MANAGEMENT DUE TO TABLE UPDATE OZF_ORDER_GROUP_PROD
<Bug 14842950> - ORDER IMPORT PERFORMANCE ISSUE DURING PRICING ENGINE CODE
<Bug 15895472> - OM LINES NOT PROPERLY QUALIFIED
<Bug 15918451> - MODIFIER DETAIL REPORT ERROR REP-0091: WHEN MODIFER NAME > 40 CHARACTERS
<Bug 15993256> - POOR PERFORMANCE AS 50 FACTOR LIST LINES USING API, IT TOOK ALMOST 1 HOUR TO COM
<Bug 16022996> - PERFORMANCE ISSUE WITH PROCESS_MODIFIERS PUBLIC API
<Bug 16047733> - PO LINE COMES OUT AS INCORRECT WHEN MULTIPLE PO'S ARE CREATED AND WHEN QP_RUNTIM
<Bug 16051721> - MODIFIER WITH ACCUMULATION ATTRIBUTE SAVES ACCUM_ATTR_RUN_SRC_FLAG SET TO 'N'
<Bug 16179517> - PRICING MAINTENANCE> - INTERNAL SERVER ERROR
<Bug 16246361> - PERFORMANCE ISSUE IN THE ITEM PRICE LIST API.
<Bug 16462621> - API PASSES THE VALUE 'Y' TO CONTINUOUS_PRICE_BREAK_FLAG FOR PBH AN
<Bug 16570491> - QP: BULK IMPORT OF PRICE LIST DELETE PRICE LINE BUT LEFT PRICE ATTRIBUTE LINE
<Bug 16590557> - FAILED TO RESOLVE INCOMPATIBILITY BETWEEN PRICE LISTS( ) DUPLICATE PRICE LIST LI
<Bug 16590629> - FP :11683415 : PROMOTIONAL ITEMS ARE GETTING DUPLICATED AND ADDED
<Bug 16657649> - PRICE BOOK SEARCH RETURNING INCORRECT RESULTS BASED ON EFFECTIVITY END DATE
<Bug 16658815> - AFTER PATCH 15993256 APPLIED, FACTORS ARE NOT APPLYING AS EXPECTED
<Bug 16803836> - STANDARD CP 'QP: BULK IMPORT OF PRICE LIST' THROWING ERROR
<Bug 16815807> - AD ADMINISTRATION UTILITY TO MAINTAIN MULTI-LINGUAL TABLES PERFORMANCE QPNLINS
<Bug 16863566> - ISSUE WITH QP: MAINTAINS THE DENORMALIZED DATA IN QP QUALIFIERS POST UPGRADE
<Bug 17065533> - CHANGING THE SHIP-TO ADDRESS RE-PRICE THE SO LINE UNIT SELLING PRICE
<Bug 17222241> - QUOTING- PRICE IS NOT FOUND ON PRICE LIST WHEN PRICE BREAK STARTS WITH '0'.
<Bug 17347084> - DEFINE MODIFIER FORM GIVES ERROR WHEN CREATING NEW PRICE BREAK LINE USING COPY F
<Bug 17586726> - ADD ITEMS TO PRICE LIST CAN BE RUN WITHOUT INPUT PARAMETERS
<Bug 17852131> - ITEM CATEGORY SEARCH ON PRICE LISTS, SHOWS PREVIOUS RESULTS
<Bug 17880179> - R12: PRICE LIST ISSUE WITH FAILED TO RESOLVE INCOMPATIBILITY BETWEEN PRICELISTS
<Bug 17947726> - MULTI-CURRENCY CONVERSION ISSUE> - WRONG CURRENCY CONVERSION RATE IS USED
<Bug 18056482> - COPY PRICE LIST FORM QPXPRCPL: ITEM CATEGORY LOV SHOWS NO VALUES
<Bug 18235252> - CRREATE MODIFIER GET ERROR PRODUCT ATTRIBUTE VALUE IS INVALID
<Bug 18287889> - UNABLE TO MODIFY/UPDATE FIELDS IN THE HEADER LEVEL IN PRICE LIST
<Bug 18391008> - ACCUMULATED RANGE BREAK CALCULATIONS USING RUNTIME SOURCED VALUE NOT AVAILBLE FO
<Bug 18508650> - ADD ITEMS TO PRICE LIST FAILS WITH ORA-06502
<Bug 18641502> - FINISH CONFIGURATION IN ISTORE TAKES MORE THAN 1 MINUTE EXPECTING UNDER 20 SEC
<Bug 18661338> - PRICE LIST CREATED WITH OVERLAPPING DATES BY BULK IMPORT PROCESS
<Bug 18800485> - R12 PBH NOT APPLIED WITH FREIGHT CHARGE ON FIRST LINER MODIFIER
<Bug 19032170> - QPXPRFOR: QUERY ONLY AND CAN STILL CHANGE FORMULA AND SAVE
<Bug 19323551> - ERROR WHILE USING NVL2 SQL FUNCTION IN ORACLE PRICING FORMULA
<Bug 19555418> - CREATE INTERCOMPANY IS HAVING PERFORMANCE ISSUE
<Bug 20512653> - CANNOT SAVE ORDER LINES FOR SOME ITEMS
<Bug 20561454> - PUBLISH PRICE BOOK ERROR ORA-29532> - JAVA.LANG.OUTOFMEMORYERROR
<Bug 21848532> - QPXPACRL INCREASE CUSTOMER NAME TO 360
<Bug 22256913> - MORE RECORDS ARCHIVED THAN EXPECTED
<Bug 22474702> - MODIFIERS WITH LINE LEVEL QUALIFIERS NOT APPLY
<Bug 22732532> - PROMO MODIFIER> - CHANGE QTY ADDS LINE
<Bug 22984342> - PERFORMANCE ISSUES WITH SALES ORDER FORM DURING PRICING CALL
<Bug 23153621> - POOR PERFORMANCE UPDATING LINE LIST PRICE ON PRICE LISTS HTML USER INTERFACE
<Bug 23253599> - SHIFT F6 NOT RESTRICTING DUPLICATE PRICE LIST LINE> - DELETE DUPLIATE STILL THERE
<Bug 23272198> - DISCOUNT MODIFIER NOT WORKING AS EXPECTED FOR ORDER AMOUNT ATTRIBUTE
<Bug 23322366> - BUILD ATTRIBUTE MAPPING RULES PERFORMANC AFTER ADVANCED PRICING RUP PATCH
<Bug 8645132> - 12.1.1:OF:FORMULA FACTOR LISTS NOT WORKING AS EXPECTED-GIVES ERRORS ON ORDER
<Bug 8688432> - QPXVAPLB MODULE: ADJUST PRICE LIST COMPLETES WITH ERROR
<Bug 9316468> - RE-PRICING LINES ON LARGE SALES ORDERS SLOW AFTER UPGRADE FROM 11.5.9 TO 12.0.6
<Bug 9475080> - OEXOEORD GET ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR WHEN PRICE DECIMAL QTY
<Bug 9645844> - ADVANCED PRICING MODIFIER LIMITS CONSUMED AMOUNT IS INCORRECT
<Bug 9660503> - PROMOTION MODIFIER -> DEFINE DETAILS FORM DOES NOT SHOW RECORDS UNTIL QUERIED.
<Bug 9679930> - LAUNCH OF CONFIGURATOR THROUGH SALES ORDER TAKES MORE THAN 15MINUTES
<Bug 9680271> - ARCHIVE AND PURGE ENTITTY ISSUES
<Bug 9694761> - PRICE LISTS (XML) RUNNING INTO ERROR FOR ANY PARAMETER
<Bug 9729769> - UPGRADE DRIVER U6678700 FAILING AT QPXDUPLA ORA-00001
<Bug 9732576> - NEED TO ADD WHERE CONDITION IN QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS
<Bug 9832529> - AFTER PATCH 9694761:R12.QP.B START DATE AND END DATE XML VERSION IS 1 DAY PRIO
<Bug 9848873> - R12 MODIFIER PRODUCT ATTRIBUTE VALUE CANNOT BE UPDATED ONCE WARNING MESSAGE IS G
<Bug 9938422> - SYSTEM IS NOT PROVIDING FULL LUMPSUM DISCOUNT ON A SINGLE SALES ORDER
<Bug 9970746> - LOW PERFORMANCE ON SAVING OM ORDER LINES
<Bug 9977712> - OEXOEORD: PRICING QUANTITY DOES NOT ROUND TO WHOLE NUMBERS

 

<Patch 22854862:R12.QP.B> - Advanced Pricing Recommended Patch Collection March 2016

The following bugs are fixed by this patch:
<Bug 10023220> - PROMOTIONAL LIMIT VIOLATION ERROR COMES UP AT ORDER ENTRY PROCESS
<Bug 10042660> - FRM-40212 IN QPXPRMLS FOR PROD ATTR VALUE
<Bug 10051804> - INTERFACE TRIP STOP ENDS IN WARNING WITH CST_XFER_PRICE_ERROR ERROR
<Bug 10056032> - OPEN PRICE LIST ERRORS: ORA-01722: INVALID NUMBER FRM-40505: ORACLE ERROR UNAB
<Bug 10093463> - LIST PRICE IS NOT ROUNDED TO CONVERSION ROUDING FACTOR AFTER APPLYING MULTI-CURR
<Bug 10120724> - ACP> - UNABLE TO LOAD PRICE LISTS
<Bug 10130826> - MODIFIER APPLIED IN ISTORE GETS DROPPED IN OM WHEN ORDER IS REPRICED
<Bug 10154917> - POOR PERFORMANCE FOR CREATE INTERCOMPANY AR INVOICES PROGRAM WITH QP SQL.
<Bug 10171380> - QPXVBLK: PERFORMANCE ISSUE QP BULK LOAD TOO SLOW
<Bug 10255367> - PRICE LIST SETUP FORM NOT VALIDATING/DISPLAYING DECIMAL ACCORDING TO PROFILE SY
<Bug 10269226> - PRICE BOOK IS NOT BEING GENERATED
<Bug 10273166> - PRICING FORMULAS NOT RECOGISING PRICING ATTRIBUTES IN FACTOR LIST
<Bug 10377566> - R12.1 PROMO HAS SPECIAL CHAR(CHR (0)) QP_LIST_LINES INCLUDE_ON_RETURNS_FLAG
<Bug 10394643> - AFTER APPLYING THE PATCH 10136863 SOME PROBLEM IS OCCURRING IN PROMOTION ITEM CA
<Bug 10625896> - PERF ISSUE WITH OE_AGREEMENTS_B MERGE AFFECTING CUSTOMER MERGE AND FIELD
<Bug 11718911> - ADJUST PRICE LIST GIVES FRM-40831: TRUNCATION OCCURRED: VALUE TOO LONG FOR FIELD
<Bug 11719249> - MODIFIER APPLYING: IGNORING CATEGORY SET ASSIGNMENT IN MASTER ITEMS FORM
<Bug 11734858> - ADD ITEMS TO PRICE LIST PROGRAM UPDATES RECORD HISTORY OF ALL PRICE LIST LINES
<Bug 11828647> - ER: SUPPRESS THE PRINT ON INVOICE FLAG FROM THE MODIFIER UI.
<Bug 11898355> - UNABLE TO PRICE USING ADVANCED PRICING WHEN MIGRATING TO R12.1.1
<Bug 12433027> - RANGE BREAK MODIFIER DOES NOT APPLY IF LIST PRICE IS NEGATIVE
<Bug 12539111> - RECEIVING ERROR MESSAGES WHEN OPENING MULTI-CURRENCY CONVERSION FORM
<Bug 12661047> - R12-NOA-OLTP-DEV-OM ERROR MESSAGE FOR> - QP: MAINTAINS THE DENORMALIZED DATA IN Q
<Bug 12670913> - RETURN FREIGHT CHARGE ROUNDING INCORRECTLY
<Bug 12677276> - INTERFACE TRIP STOP RUNNING LONG CAUSING PEFORMANCE ISSUES
<Bug 12710486> - ATTRIBUTE QUALIFIER ATTRIBUTE IS INVALID.
<Bug 12766733> - DROP SHIP RECEIPTS ERRORS RVTII-060: SUBROUTINE INV_TXN_MANAGER_PUB
<Bug 12778935> - QP: BULK IMPORT OF PRICE LIST> - BAD PERFORMANCE
<Bug 12784810> - R12 DIFFERENT ERROR MESSAGE WHEN CREATING PRICING AGREEMENT REVISION THAN R11
<Bug 12875196> - YOU HAVE ENCOUNTERED AN UNEXPECTED ERROR. PLEASE CONTACT THE SYSTEM ADMINSTRATOR
<Bug 12916970> - :HARD> - ADJUST BENEFIT AMOUNT NOT WORKING AS EXPECTED R12 12352707
<Bug 12951945> - RELEASE 12: PRICE LISTS REPORT FETCHING DETAILS OF END DATED LIST LINES
<Bug 13045009> - PERFORMANCE ISSUE WITH ARCHIVING OF A PRICELIST
<Bug 13110812> - OKL HEADER MULTI-CURRENCY CONVERION CHANGED BY QP_PRICE_LIST_PUB
<Bug 13250347> - ERROR MESSAGE IN GERMAN LANGUAGE INSTEAD ENGLISH
<Bug 13371371> - MODIFIER LIMIT GETTING CONSUMED BY 0 PRICE LINE
<Bug 13395264> - QP: UPGRADE PRICING DATA FOR BULK LOADER DIDN'T UPDATE ALL ORIG_SYS_HEADER_
<Bug 13487501> - BAD PERFORMANCE IN PRICE LISTS QPXPRLST
<Bug 13507103> - NOT ALL ITEM CATEGORY LOV WORK IN THE ADD ITEMS TO PRICE LIST
<Bug 13508707> - RMA RECEIVED BUT THE LIMIT MODIFIER AVAILABLE DIDN'T ADD
<Bug 13521835> - PARTIAL UNITS SEEN IN AVAILABLE & CONSUMED QUANTITY IN PRICING MODIFIER SCREEN
<Bug 13532774> - QPXPRFOR.FMB FACTOR LIST FIND ERRORS WITH FRM-40350
<Bug 13585536> - ADD QULAIFIER TO PRICE LIST -ATTRIBUTE VALUE FROM INVALID PLEASE RE-ENTER
<Bug 13655307> - PRICING ERRORS WHILE COPYING AN EXISTING RETURN TYPE ORDER
<Bug 13703332> - R12-ATTRIBUTE VALUE FROM SHOWS RED/AFTER PATCH 13585536 FOR INVALID ERROR
<Bug 13776174> - PBH MODIFR LINES W/CUSTOM VOLUME ATTR NOT APPLY CORRECTLY AFTER PATCH 12916970
<Bug 13818038> - GSA PRICE LIST HAVE DUPLICATES FOR ONE ITEM¿BUT CANNOT DELETE THIS RECORD
<Bug 13820039> - ISSUE WITH LOV FOR ITEM CATEGORY AFTER APPLYING PATCH 13507103
<Bug 13860628> - PRICE BREAK LINES ISSUES IN PRICELIST BULK IMPORT
<Bug 13877124> - IN BLOCK PRICING, CAN'T ENTER .25 IN THE RECURRING VALUE.
<Bug 13881910> - DFF FIELD FOR ADDITIONAL INFO FOR LIST LINES WILL NOT STAY POPULATED
<Bug 13959133> - MODIFIER DETAILS REPORT SHOWING WRONG FORMAT AFTER PAGE BREAKS
<Bug 13977250> - ICX: NUMERIC CHARACTERS AND GENERAL PREFERENCES NUMBER FORMAT
<Bug 13996811> - QUALIFIER GROUPING REPORT: QUALIFIER ATTRIBUTE VALUE TO PARAMETER
<Bug 14054072> - BEST PRICE SUPPLIER SHIP AND DEBIT MODIFIER DOES NOT APPLY TO SALES ORDER LINE.
<Bug 14065769> - QP: MAINTAINS THE DENORMALIZED DATA NOT WORKING FOR MULTI ORG SECURITY RULES
<Bug 14102682> - PROMOTIONAL LIMITS ARE NOT BEING APPLIED CORRECTLY
<Bug 14103598> - ADV. PRICING PRICE BREAKS FIRST BREAK HAS TO START WITH ZERO/NO GAPS ALLOWED I
<Bug 14169474> - APP-QP-225737 NO ATTRIBUTES ARE DEFINED FOR THIS CONTEXT INSERT PRICE BREAK
<Bug 14367359> - APPLICATION LOCKS WHILE CREATING BPAS QP_DELAYED_REQUESTS_UTIL.UPDATE_MANUAL_MOD
<Bug 14393164> - LONG COMPLETION TIMES FOR INTERFACE TRIP STOP WHEN DEBUGS ARE ON
<Bug 14396941> - TPA FOR RESALE TABLE> - PERF ISSUE IN QP ENGINE CALL
<Bug 14464004> - PRICE BOOK GENERATION NOT TAKING PLACE
<Bug 14611180> - QP_LIST_LINES_V GIVES ERROR ORA-01427: SINGLE-ROW SUBQUERY RETURN MORE THAN ONE
<Bug 14623252> - USE API IN R12 TO ADD PRICE LINES TO MIGRATED 11I PRICE LISTS
<Bug 14686371> - FOLDER CONDITION NOT WORKING IN PRICE LIST FORM
<Bug 14763873> - QPXUPQUL.SQL :12.1.3 UPGRADE QUAL_ATTR_VALUE_FROM_NUMBER IS NULL IN QP_QUALIFIER
<Bug 14783146> - FORM LOCKING IN ORDER MANAGEMENT DUE TO TABLE UPDATE OZF_ORDER_GROUP_PROD
<Bug 14842950> - ORDER IMPORT PERFORMANCE ISSUE DURING PRICING ENGINE CODE
<Bug 15895472> - OM LINES NOT PROPERLY QUALIFIED
<Bug 15918451> - MODIFIER DETAIL REPORT ERROR REP-0091: WHEN MODIFER NAME > 40 CHARACTERS
<Bug 15993256> - POOR PERFORMANCE AS 50 FACTOR LIST LINES USING API, IT TOOK ALMOST 1 HOUR TO COM
<Bug 16022996> - PERFORMANCE ISSUE WITH PROCESS_MODIFIERS PUBLIC API
<Bug 16047733> - PO LINE COMES OUT AS INCORRECT WHEN MULTIPLE PO'S ARE CREATED AND WHEN QP_RUNTIM
<Bug 16051721> - MODIFIER WITH ACCUMULATION ATTRIBUTE SAVES ACCUM_ATTR_RUN_SRC_FLAG SET TO 'N'
<Bug 16179517> - PRICING MAINTENANCE> - INTERNAL SERVER ERROR
<Bug 16246361> - PERFORMANCE ISSUE IN THE ITEM PRICE LIST API.
<Bug 16462621> - API PASSES THE VALUE 'Y' TO CONTINUOUS_PRICE_BREAK_FLAG FOR PBH AN
<Bug 16570491> - QP: BULK IMPORT OF PRICE LIST DELETE PRICE LINE BUT LEFT PRICE ATTRIBUTE LINE
<Bug 16590557> - FAILED TO RESOLVE INCOMPATIBILITY BETWEEN PRICE LISTS( ) DUPLICATE PRICE LIST LI
<Bug 16590629> - FP :11683415 : PROMOTIONAL ITEMS ARE GETTING DUPLICATED AND ADDED
<Bug 16657649> - PRICE BOOK SEARCH RETURNING INCORRECT RESULTS BASED ON EFFECTIVITY END DATE
<Bug 16658815> - AFTER PATCH 15993256 APPLIED, FACTORS ARE NOT APPLYING AS EXPECTED
<Bug 16803836> - STANDARD CP 'QP: BULK IMPORT OF PRICE LIST' THROWING ERROR
<Bug 16815807> - AD ADMINISTRATION UTILITY TO MAINTAIN MULTI-LINGUAL TABLES PERFORMANCE QPNLINS
<Bug 16863566> - ISSUE WITH QP: MAINTAINS THE DENORMALIZED DATA IN QP QUALIFIERS POST UPGRADE
<Bug 17065533> - CHANGING THE SHIP-TO ADDRESS RE-PRICE THE SO LINE UNIT SELLING PRICE
<Bug 17222241> - QUOTING- PRICE IS NOT FOUND ON PRICE LIST WHEN PRICE BREAK STARTS WITH '0'.
<Bug 17347084> - DEFINE MODIFIER FORM GIVES ERROR WHEN CREATING NEW PRICE BREAK LINE USING COPY F
<Bug 17586726> - ADD ITEMS TO PRICE LIST CAN BE RUN WITHOUT INPUT PARAMETERS
<Bug 17852131> - ITEM CATEGORY SEARCH ON PRICE LISTS, SHOWS PREVIOUS RESULTS
<Bug 17880179> - R12: PRICE LIST ISSUE WITH FAILED TO RESOLVE INCOMPATIBILITY BETWEEN PRICELISTS
<Bug 17947726> - MULTI-CURRENCY CONVERSION ISSUE> - WRONG CURRENCY CONVERSION RATE IS USED
<Bug 18056482> - COPY PRICE LIST FORM QPXPRCPL: ITEM CATEGORY LOV SHOWS NO VALUES
<Bug 18235252> - CRREATE MODIFIER GET ERROR PRODUCT ATTRIBUTE VALUE IS INVALID
<Bug 18287889> - UNABLE TO MODIFY/UPDATE FIELDS IN THE HEADER LEVEL IN PRICE LIST
<Bug 18391008> - ACCUMULATED RANGE BREAK CALCULATIONS USING RUNTIME SOURCED VALUE NOT AVAILBLE FO
<Bug 18508650> - ADD ITEMS TO PRICE LIST FAILS WITH ORA-06502
<Bug 18641502> - FINISH CONFIGURATION IN ISTORE TAKES MORE THAN 1 MINUTE EXPECTING UNDER 20 SEC
<Bug 18661338> - PRICE LIST CREATED WITH OVERLAPPING DATES BY BULK IMPORT PROCESS
<Bug 18800485> - R12 PBH NOT APPLIED WITH FREIGHT CHARGE ON FIRST LINER MODIFIER
<Bug 19032170> - QPXPRFOR: QUERY ONLY AND CAN STILL CHANGE FORMULA AND SAVE
<Bug 19323551> - ERROR WHILE USING NVL2 SQL FUNCTION IN ORACLE PRICING FORMULA
<Bug 19555418> - CREATE INTERCOMPANY IS HAVING PERFORMANCE ISSUE
<Bug 20512653> - CANNOT SAVE ORDER LINES FOR SOME ITEMS
<Bug 21848532> - QPXPACRL INCREASE CUSTOMER NAME TO 360
<Bug 22256913> - MORE RECORDS ARCHIVED THAN EXPECTED
<Bug 22474702> - MODIFIERS WITH LINE LEVEL QUALIFIERS NOT APPLY
<Bug 8645132> - 12.1.1:OF:FORMULA FACTOR LISTS NOT WORKING AS EXPECTED-GIVES ERRORS ON ORDER
<Bug 8688432> - QPXVAPLB MODULE: ADJUST PRICE LIST COMPLETES WITH ERROR
<Bug 9316468> - RE-PRICING LINES ON LARGE SALES ORDERS SLOW AFTER UPGRADE FROM 11.5.9 TO 12.0.6
<Bug 9475080> - OEXOEORD GET ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR WHEN PRICE DECIMAL QTY
<Bug 9645844> - ADVANCED PRICING MODIFIER LIMITS CONSUMED AMOUNT IS INCORRECT
<Bug 9660503> - PROMOTION MODIFIER -> DEFINE DETAILS FORM DOES NOT SHOW RECORDS UNTIL QUERIED.
<Bug 9679930> - LAUNCH OF CONFIGURATOR THROUGH SALES ORDER TAKES MORE THAN 15MINUTES
<Bug 9680271> - ARCHIVE AND PURGE ENTITTY ISSUES
<Bug 9694761> - PRICE LISTS (XML) RUNNING INTO ERROR FOR ANY PARAMETER
<Bug 9729769> - UPGRADE DRIVER U6678700 FAILING AT QPXDUPLA ORA-00001
<Bug 9732576> - NEED TO ADD WHERE CONDITION IN QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS
<Bug 9832529> - AFTER PATCH 9694761:R12.QP.B START DATE AND END DATE XML VERSION IS 1 DAY PRIO
<Bug 9848873> - R12 MODIFIER PRODUCT ATTRIBUTE VALUE CANNOT BE UPDATED ONCE WARNING MESSAGE IS G
<Bug 9938422> - SYSTEM IS NOT PROVIDING FULL LUMPSUM DISCOUNT ON A SINGLE SALES ORDER
<Bug 9970746> - LOW PERFORMANCE ON SAVING OM ORDER LINES
<Bug 9977712> - OEXOEORD: PRICING QUANTITY DOES NOT ROUND TO WHOLE NUMBERS

<Patch 22295889:R12.QP.B> - Released
Advanced Pricing Recommended Patch Collection Dec, 2015

The following bugs are fixed by this patch:

<Bug 10023220> - PROMOTIONAL LIMIT VIOLATION ERROR COMES UP AT ORDER ENTRY PROCESS
<Bug 10042660> - FRM-40212 IN QPXPRMLS FOR PROD ATTR VALUE
<Bug 10051804> - INTERFACE TRIP STOP ENDS IN WARNING WITH CST_XFER_PRICE_ERROR ERROR
<Bug 10056032> - OPEN PRICE LIST ERRORS: ORA-01722: INVALID NUMBER FRM-40505: ORACLE ERROR UNAB
<Bug 10093463> - LIST PRICE IS NOT ROUNDED TO CONVERSION ROUDING FACTOR AFTER APPLYING MULTI-CURR
<Bug 10120724> - ACP> - UNABLE TO LOAD PRICE LISTS
<Bug 10130826> - MODIFIER APPLIED IN ISTORE GETS DROPPED IN OM WHEN ORDER IS REPRICED
<Bug 10154917> - POOR PERFORMANCE FOR CREATE INTERCOMPANY AR INVOICES PROGRAM WITH QP SQL.
<Bug 10171380> - QPXVBLK: PERFORMANCE ISSUE QP BULK LOAD TOO SLOW
<Bug 10255367> - PRICE LIST SETUP FORM NOT VALIDATING/DISPLAYING DECIMAL ACCORDING TO PROFILE SY
<Bug 10269226> - PRICE BOOK IS NOT BEING GENERATED
<Bug 10273166> - PRICING FORMULAS NOT RECOGISING PRICING ATTRIBUTES IN FACTOR LIST
<Bug 10377566> - R12.1 PROMO HAS SPECIAL CHAR(CHR (0)) QP_LIST_LINES INCLUDE_ON_RETURNS_FLAG
<Bug 10394643> - AFTER APPLYING THE PATCH 10136863 SOME PROBLEM IS OCCURRING IN PROMOTION ITEM CA
<Bug 10625896> - PERF ISSUE WITH OE_AGREEMENTS_B MERGE AFFECTING CUSTOMER MERGE AND FIELD
<Bug 11718911> - ADJUST PRICE LIST GIVES FRM-40831: TRUNCATION OCCURRED: VALUE TOO LONG FOR FIELD
<Bug 11719249> - MODIFIER APPLYING: IGNORING CATEGORY SET ASSIGNMENT IN MASTER ITEMS FORM
<Bug 11734858> - ADD ITEMS TO PRICE LIST PROGRAM UPDATES RECORD HISTORY OF ALL PRICE LIST LINES
<Bug 11828647> - ER: SUPPRESS THE PRINT ON INVOICE FLAG FROM THE MODIFIER UI.
<Bug 11898355> - UNABLE TO PRICE USING ADVANCED PRICING WHEN MIGRATING TO R12.1.1
<Bug 12433027> - RANGE BREAK MODIFIER DOES NOT APPLY IF LIST PRICE IS NEGATIVE
<Bug 12539111> - RECEIVING ERROR MESSAGES WHEN OPENING MULTI-CURRENCY CONVERSION FORM
<Bug 12661047> - R12-NOA-OLTP-DEV-OM ERROR MESSAGE FOR> - QP: MAINTAINS THE DENORMALIZED DATA IN Q
<Bug 12670913> - RETURN FREIGHT CHARGE ROUNDING INCORRECTLY
<Bug 12677276> - INTERFACE TRIP STOP RUNNING LONG CAUSING PEFORMANCE ISSUES
<Bug 12710486> - ATTRIBUTE QUALIFIER ATTRIBUTE IS INVALID.
<Bug 12766733> - DROP SHIP RECEIPTS ERRORS RVTII-060: SUBROUTINE INV_TXN_MANAGER_PUB
<Bug 12778935> - QP: BULK IMPORT OF PRICE LIST> - BAD PERFORMANCE
<Bug 12784810> - R12 DIFFERENT ERROR MESSAGE WHEN CREATING PRICING AGREEMENT REVISION THAN R11
<Bug 12875196> - YOU HAVE ENCOUNTERED AN UNEXPECTED ERROR. PLEASE CONTACT THE SYSTEM ADMINSTRATOR
<Bug 12916970> - :HARD> - ADJUST BENEFIT AMOUNT NOT WORKING AS EXPECTED R12 12352707
<Bug 12951945> - RELEASE 12: PRICE LISTS REPORT FETCHING DETAILS OF END DATED LIST LINES
<Bug 13045009> - PERFORMANCE ISSUE WITH ARCHIVING OF A PRICELIST
<Bug 13110812> - OKL HEADER MULTI-CURRENCY CONVERION CHANGED BY QP_PRICE_LIST_PUB
<Bug 13250347> - ERROR MESSAGE IN GERMAN LANGUAGE INSTEAD ENGLISH
<Bug 13371371> - MODIFIER LIMIT GETTING CONSUMED BY 0 PRICE LINE
<Bug 13395264> - QP: UPGRADE PRICING DATA FOR BULK LOADER DIDN'T UPDATE ALL ORIG_SYS_HEADER_
<Bug 13487501> - BAD PERFORMANCE IN PRICE LISTS QPXPRLST
<Bug 13507103> - NOT ALL ITEM CATEGORY LOV WORK IN THE ADD ITEMS TO PRICE LIST
<Bug 13508707> - RMA RECEIVED BUT THE LIMIT MODIFIER AVAILABLE DIDN'T ADD
<Bug 13521835> - PARTIAL UNITS SEEN IN AVAILABLE & CONSUMED QUANTITY IN PRICING MODIFIER SCREEN
<Bug 13532774> - QPXPRFOR.FMB FACTOR LIST FIND ERRORS WITH FRM-40350
<Bug 13585536> - ADD QULAIFIER TO PRICE LIST> -ATTRIBUTE VALUE FROM INVALID PLEASE RE-ENTER
<Bug 13655307> - PRICING ERRORS WHILE COPYING AN EXISTING RETURN TYPE ORDER
<Bug 13703332> - R12-ATTRIBUTE VALUE FROM SHOWS RED/AFTER PATCH 13585536 FOR INVALID ERROR
<Bug 13776174> - PBH MODIFR LINES W/CUSTOM VOLUME ATTR NOT APPLY CORRECTLY AFTER PATCH 12916970
<Bug 13818038> - GSA PRICE LIST HAVE DUPLICATES FOR ONE ITEM¿BUT CANNOT DELETE THIS RECORD
<Bug 13820039> - ISSUE WITH LOV FOR ITEM CATEGORY AFTER APPLYING PATCH 13507103
<Bug 13860628> - PRICE BREAK LINES ISSUES IN PRICELIST BULK IMPORT
<Bug 13877124> - IN BLOCK PRICING, CAN'T ENTER .25 IN THE RECURRING VALUE.
<Bug 13881910> - DFF FIELD FOR ADDITIONAL INFO FOR LIST LINES WILL NOT STAY POPULATED
<Bug 13959133> - MODIFIER DETAILS REPORT SHOWING WRONG FORMAT AFTER PAGE BREAKS
<Bug 13977250> - ICX: NUMERIC CHARACTERS AND GENERAL PREFERENCES NUMBER FORMAT
<Bug 13996811> - QUALIFIER GROUPING REPORT: QUALIFIER ATTRIBUTE VALUE TO PARAMETER
<Bug 14054072> - BEST PRICE SUPPLIER SHIP AND DEBIT MODIFIER DOES NOT APPLY TO SALES ORDER LINE.
<Bug 14065769> - QP: MAINTAINS THE DENORMALIZED DATA NOT WORKING FOR MULTI ORG SECURITY RULES
<Bug 14102682> - PROMOTIONAL LIMITS ARE NOT BEING APPLIED CORRECTLY
<Bug 14103598> - ADV. PRICING PRICE BREAKS FIRST BREAK HAS TO START WITH ZERO/NO GAPS ALLOWED I
<Bug 14169474> - APP-QP-225737 NO ATTRIBUTES ARE DEFINED FOR THIS CONTEXT INSERT PRICE BREAK
<Bug 14367359> - APPLICATION LOCKS WHILE CREATING BPAS QP_DELAYED_REQUESTS_UTIL.UPDATE_MANUAL_MOD
<Bug 14393164> - LONG COMPLETION TIMES FOR INTERFACE TRIP STOP WHEN DEBUGS ARE ON
<Bug 14396941> - TPA FOR RESALE TABLE> - PERF ISSUE IN QP ENGINE CALL
<Bug 14464004> - PRICE BOOK GENERATION NOT TAKING PLACE
<Bug 14611180> - QP_LIST_LINES_V GIVES ERROR ORA-01427: SINGLE-ROW SUBQUERY RETURN MORE THAN ONE
<Bug 14623252> - USE API IN R12 TO ADD PRICE LINES TO MIGRATED 11I PRICE LISTS
<Bug 14686371> - FOLDER CONDITION NOT WORKING IN PRICE LIST FORM
<Bug 14763873> - QPXUPQUL.SQL :12.1.3 UPGRADE QUAL_ATTR_VALUE_FROM_NUMBER IS NULL IN QP_QUALIFIER
<Bug 14783146> - FORM LOCKING IN ORDER MANAGEMENT DUE TO TABLE UPDATE OZF_ORDER_GROUP_PROD
<Bug 14842950> - ORDER IMPORT PERFORMANCE ISSUE DURING PRICING ENGINE CODE
<Bug 15895472> - OM LINES NOT PROPERLY QUALIFIED
<Bug 15918451> - MODIFIER DETAIL REPORT ERROR REP-0091: WHEN MODIFER NAME > 40 CHARACTERS
<Bug 15993256> - POOR PERFORMANCE AS 50 FACTOR LIST LINES USING API, IT TOOK ALMOST 1 HOUR TO COM
<Bug 16022996> - PERFORMANCE ISSUE WITH PROCESS_MODIFIERS PUBLIC API
<Bug 16047733> - PO LINE COMES OUT AS INCORRECT WHEN MULTIPLE PO'S ARE CREATED AND WHEN QP_RUNTIM
<Bug 16051721> - MODIFIER WITH ACCUMULATION ATTRIBUTE SAVES ACCUM_ATTR_RUN_SRC_FLAG SET TO 'N'
<Bug 16179517> - PRICING MAINTENANCE> - INTERNAL SERVER ERROR
<Bug 16246361> - PERFORMANCE ISSUE IN THE ITEM PRICE LIST API.
<Bug 16462621> - API PASSES THE VALUE 'Y' TO CONTINUOUS_PRICE_BREAK_FLAG FOR PBH AN
<Bug 16570491> - QP: BULK IMPORT OF PRICE LIST DELETE PRICE LINE BUT LEFT PRICE ATTRIBUTE LINE
<Bug 16590557> - FAILED TO RESOLVE INCOMPATIBILITY BETWEEN PRICE LISTS( ) DUPLICATE PRICE LIST LI
<Bug 16590629> - FP :11683415 : PROMOTIONAL ITEMS ARE GETTING DUPLICATED AND ADDED
<Bug 16657649> - PRICE BOOK SEARCH RETURNING INCORRECT RESULTS BASED ON EFFECTIVITY END DATE
<Bug 16658815> - AFTER PATCH 15993256 APPLIED, FACTORS ARE NOT APPLYING AS EXPECTED
<Bug 16803836> - STANDARD CP 'QP: BULK IMPORT OF PRICE LIST' THROWING ERROR
<Bug 16815807> - AD ADMINISTRATION UTILITY TO MAINTAIN MULTI-LINGUAL TABLES PERFORMANCE QPNLINS
<Bug 16863566> - ISSUE WITH QP: MAINTAINS THE DENORMALIZED DATA IN QP QUALIFIERS POST UPGRADE
<Bug 17065533> - CHANGING THE SHIP-TO ADDRESS RE-PRICE THE SO LINE UNIT SELLING PRICE
<Bug 17222241> - QUOTING- PRICE IS NOT FOUND ON PRICE LIST WHEN PRICE BREAK STARTS WITH '0'.
<Bug 17347084> - DEFINE MODIFIER FORM GIVES ERROR WHEN CREATING NEW PRICE BREAK LINE USING COPY F
<Bug 17586726> - ADD ITEMS TO PRICE LIST CAN BE RUN WITHOUT INPUT PARAMETERS
<Bug 17852131> - ITEM CATEGORY SEARCH ON PRICE LISTS, SHOWS PREVIOUS RESULTS
<Bug 17880179> - R12: PRICE LIST ISSUE WITH FAILED TO RESOLVE INCOMPATIBILITY BETWEEN PRICELISTS
<Bug 17947726> - MULTI-CURRENCY CONVERSION ISSUE> - WRONG CURRENCY CONVERSION RATE IS USED
<Bug 18056482> - COPY PRICE LIST FORM QPXPRCPL: ITEM CATEGORY LOV SHOWS NO VALUES
<Bug 18235252> - CRREATE MODIFIER GET ERROR PRODUCT ATTRIBUTE VALUE IS INVALID
<Bug 18287889> - UNABLE TO MODIFY/UPDATE FIELDS IN THE HEADER LEVEL IN PRICE LIST
<Bug 18391008> - ACCUMULATED RANGE BREAK CALCULATIONS USING RUNTIME SOURCED VALUE NOT AVAILBLE FO
<Bug 18508650> - ADD ITEMS TO PRICE LIST FAILS WITH ORA-06502
<Bug 18641502> - FINISH CONFIGURATION IN ISTORE TAKES MORE THAN 1 MINUTE EXPECTING UNDER 20 SEC
<Bug 18661338> - PRICE LIST CREATED WITH OVERLAPPING DATES BY BULK IMPORT PROCESS
<Bug 18800485> - R12 PBH NOT APPLIED WITH FREIGHT CHARGE ON FIRST LINER MODIFIER
<Bug 19032170> - QPXPRFOR: QUERY ONLY AND CAN STILL CHANGE FORMULA AND SAVE
<Bug 19323551> - ERROR WHILE USING NVL2 SQL FUNCTION IN ORACLE PRICING FORMULA
<Bug 19555418> - CREATE INTERCOMPANY IS HAVING PERFORMANCE ISSUE
<Bug 20512653> - CANNOT SAVE ORDER LINES FOR SOME ITEMS
<Bug 21848532> - QPXPACRL INCREASE CUSTOMER NAME TO 360
<Bug 8645132> - 12.1.1:OF:FORMULA FACTOR LISTS NOT WORKING AS EXPECTED-GIVES ERRORS ON ORDER
<Bug 8688432> - QPXVAPLB MODULE: ADJUST PRICE LIST COMPLETES WITH ERROR
<Bug 9316468> - RE-PRICING LINES ON LARGE SALES ORDERS SLOW AFTER UPGRADE FROM 11.5.9 TO 12.0.6
<Bug 9475080> - OEXOEORD GET ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR WHEN PRICE DECIMAL QTY
<Bug 9645844> - ADVANCED PRICING MODIFIER LIMITS CONSUMED AMOUNT IS INCORRECT
<Bug 9660503> - PROMOTION MODIFIER> -> DEFINE DETAILS FORM DOES NOT SHOW RECORDS UNTIL QUERIED.
<Bug 9679930> - LAUNCH OF CONFIGURATOR THROUGH SALES ORDER TAKES MORE THAN 15MINUTES
<Bug 9680271> - ARCHIVE AND PURGE ENTITTY ISSUES
<Bug 9694761> - PRICE LISTS (XML) RUNNING INTO ERROR FOR ANY PARAMETER
<Bug 9729769> - UPGRADE DRIVER U6678700 FAILING AT QPXDUPLA ORA-00001
<Bug 9732576> - NEED TO ADD WHERE CONDITION IN QP_MAINTAIN_DENORMALIZED_DATA.UPDATE_QUALIFIERS
<Bug 9832529> - AFTER PATCH 9694761:R12.QP.B START DATE AND END DATE XML VERSION IS 1 DAY PRIO
<Bug 9848873> - R12 MODIFIER PRODUCT ATTRIBUTE VALUE CANNOT BE UPDATED ONCE WARNING MESSAGE IS G
<Bug 9938422> - SYSTEM IS NOT PROVIDING FULL LUMPSUM DISCOUNT ON A SINGLE SALES ORDER
<Bug 9970746> - LOW PERFORMANCE ON SAVING OM ORDER LINES
<Bug 9977712> - OEXOEORD: PRICING QUANTITY DOES NOT ROUND TO WHOLE NUMBERS

 

<Patch 19572462:R12.QP.B>  - Released
Advanced Pricing Recommended Patch Collection Sept 2014

The following bugs are fixed by this patch:

<Bug 10023220> - Promotional Limit Violation Error Comes Up At Order Entry Process
<Bug 10042660> - Frm-40212 In Qpxprmls For Prod Attr Value
<Bug 10051804> - Interface Trip Stop Ends In Warning With  Cst_Xfer_Price_Error Error
<Bug 10056032> - Open Price List Errors: Ora-01722: Invalid Number Frm-40505: Oracle Error
<Bug 10093463> - List Price Is Not Rounded To Conversion Rouding Factor After Applying
                            Multi-Currency
<Bug 10120724> - Acp> - Unable To Load Price Lists
<Bug 10130826> - Modifier Applied In Istore Gets Dropped In Om When Order Is Repriced
<Bug 10154917> - Poor Performance For Create Intercompany AR Invoices Program
<Bug 10171380> - Qpxvblk: Performance Issue Qp Bulk Load Too Slow
<Bug 10255367> - Price List Setup Form Not Validating/Displaying Decimal  According To Profile
<Bug 10269226> - Price Book Is Not Being Generated
<Bug 10273166> - Pricing Formulas Not Recogising Pricing Attributes In Factor List
<Bug 10377566> - R12.1 Promo Has Special Char in Qp_List_Lines Include_On_Returns_Flag
<Bug 10394643> - Applying The Patch 10136863. Problem Is Occurring In Promotion Item
<Bug 10625896> - Perf Issue With Oe_Agreements_B Merge Affecting Customer Merge
<Bug 11718911> - Adjust Price List Gives Frm-40831: Truncation Occurred: Value Too Long For
<Bug 11719249> - Modifier Applying: Ignoring Category Set Assignment In Master Items Form
<Bug 11734858> - Add Items To Price List Program Updates Record History Of Price List Lines
<Bug 11828647> - Er: Suppress The Print On Invoice Flag From The Modifier Ui.
<Bug 11898355> - Unable To Price Using Advanced Pricing When Migrating To R12.1.1
<Bug 12433027> - Range Break Modifier Does Not Apply If List Price Is Negative
<Bug 12539111> - Receiving Error Messages When Opening Multi-Currency Conversion Form
<Bug 12661047> - R12-Noa-Oltp-Dev-Om Error Message For> -
                            QP: Maintains The Denormalized Data In QP Qualifiers
<Bug 12670913> - Return Freight Charge Rounding Incorrectly
<Bug 12677276> - Interface Trip Stop Running Long Causing Peformance Issues
<Bug 12710486> - Attribute Qualifier Attribute Is Invalid.
<Bug 12766733> - Drop Ship Receipts Errors Rvtii-060: Subroutine Inv_Txn_Manager_Pub
<Bug 12778935> - Qp: Bulk Import Of Price List> - Bad Performance
<Bug 12784810> - R12 Different Error Message When Creating Pricing Agreement Revision
                           Than R11
<Bug 12875196> - You Have Encountered An Unexpected Error.
                            Please Contact The System Adminstrator
<Bug 12916970> - Adjust Benefit Amount Not Working As Expected R12 12352707
<Bug 12951945> - Release 12: Price Lists Report Fetching Details Of End Dated List Lines
<Bug 13045009> - Performance Issue With Archiving Of A Pricelist
<Bug 13110812> - OKL Header Multi-Currency Converion Changed By Qp_Price_List_Pub
<Bug 13250347> - Error Message In German Language Instead English
<Bug 13371371> - Modifier Limit Getting Consumed By 0 Price Line
<Bug 13395264> - Qp: Upgrade Pricing Data For Bulk Loader Did Not Update
                           All Orig_Sys_Header_Ref
<Bug 13487501> - Bad Performance In Price Lists Qpxprlst
<Bug 13507103> - Not All Item Category Lov Work In The Add Items To Price List
<Bug 13508707> - Rma Received  But The Limit Modifier Available  Didn'T Add
<Bug 13521835> - Partial Units Seen In Available & Consumed Quantity In
                            Pricing Modifier Screen
<Bug 13532774> - Qpxprfor.Fmb  Factor List Find Errors With Frm-40350
<Bug 13585536> - Add Qulaifier To Price List> -Attribute Value From Invalid Please Re-Enter
<Bug 13655307> - Pricing Errors While Copying An Existing Return Type Order
<Bug 13703332> - R12-Attribute Value From Shows Red/After Patch 13585536 For Invalid  Error
<Bug 13776174> - PBH Modifr Lines W/Custom Volume Attr Not Apply Correctly After
                            Patch 12916970
<Bug 13818038> - Gsa Price List Have Duplicates For One Item But Cannot Delete
                           This Record
<Bug 13820039> - Issue With Lov For Item Category After Applying Patch 13507103
<Bug 13860628> - Price Break Lines Issues In Pricelist Bulk Import
<Bug 13877124> - In Block Pricing, Can'T Enter .25 In The Recurring Value.
<Bug 13881910> - Dff Field For Additional Info For List Lines Will Not Stay Populated
<Bug 13959133> - Modifier Details Report Showing Wrong Format After Page Breaks
<Bug 13977250> - Icx: Numeric Characters And General Preferences Number Format
<Bug 13996811> - Qualifier Grouping Report: Qualifier Attribute Value To Parameter
<Bug 14054072> - Best Price Supplier Ship And Debit Modifier Does Not Apply To
                            Sales Order Line.
<Bug 14065769> - Qp: Maintains The Denormalized Data Not Working For Multi Org
                           Security Rules
<Bug 14102682> - Promotional Limits Are Not Being Applied Correctly
<Bug 14103598> - Adv. Pricing Price Breaks First Break Has To Start With Zero/No Gaps Allowed
<Bug 14169474> - App-Qp-225737 No Attributes Are Defined For This Context Insert 
                            Price Break
<Bug 14367359> - Application Locks While Creating BPAS
                            Qp_Delayed_Requests_Util.Update_Manual_Mod
<Bug 14393164> -  Long Completion Times For Interface Trip Stop When Debugs Are On
<Bug 14396941> - Tpa For Resale Table> - Perf Issue In Qp Engine Call
<Bug 14464004> - Price Book Generation Not Taking Place
<Bug 14611180> - Qp_List_Lines_V Gives Error Ora-01427: Single-Row Subquery Return More
                            Than One
<Bug 14623252> - Use Api In R12 To Add Price Lines To Migrated 11I Price Lists
<Bug 14686371> - Folder Condition Not Working In Price List Form
<Bug 14763873> - Qpxupqul.Sql :12.1.3 Upgrade Qual_Attr_Value_From_Number Is Null In
                           Qp_Qualifier
<Bug 14783146> - Form Locking In Order Management Due To Table Update
                           Ozf_Order_Group_Prod
<Bug 14842950> - Order Import Performance Issue During Pricing Engine Code
<Bug 15895472> - Om Lines Not Properly Qualified
<Bug 15918451> - Modifier Detail Report Error Rep-0091:  When Modifer Name > 40 Characters
<Bug 15993256> - Poor Performance As 50 Factor List Lines Using Api, It Took
                            Almost 1 Hour To Complete
<Bug 16022996> - Performance Issue With Process_Modifiers Public Api
<Bug 16047733> - PO Line Comes Out As Incorrect When Multiple Po'S Are Created
                            And When Qp_Runtim
<Bug 16051721> - Modifier With Accumulation Attribute Saves Accum_Attr_Run_Src_Flag Set
                           To 'N'
<Bug 16179517> - Pricing Maintenance> - Internal Server Error
<Bug 16246361> - Performance Issue In The Item Price List Api.
<Bug 16462621> - Api Passes The Value 'Y' To Continuous_Price_Break_Flag For Pbh An
<Bug 16570491> - Qp: Bulk Import Of Price List Delete Price Line But Left Price Attribute Line
<Bug 16590557> - Failed To Resolve Incompatibility Between Price Lists( ) Duplicate Price List Li
<Bug 16590629> - Fp :11683415 : Promotional Items Are Getting Duplicated And Added
<Bug 16657649> - Price Book Search Returning Incorrect Results Based On Effectivity End Date
<Bug 16658815> - After Patch 15993256  Applied, Factors Are Not Applying As Expected
<Bug 16803836> - Standard Cp  'Qp: Bulk Import Of Price List' Throwing Error
<Bug 16815807> - Ad Administration Utility To Maintain Multi-Lingual Tables Performance
<Bug 16863566> - Issue With Qp: Maintains The Denormalized Data In Qp Qualifiers
                            Post Upgrade
<Bug 17065533> - Changing The Ship-To Address Re-Price The So Line Unit Selling Price
<Bug 17222241> - Quoting- Price Is Not Found On Price List When Price Break Starts With '0'.
<Bug 17347084> - Define Modifier Form Gives Error When Creating New Price Break Line
                            Using Copy F
<Bug 17586726> - Add Items To Price List Can Be Run Without Input Parameters
<Bug 17852131> - Item Category Search On Price Lists, Shows Previous Results
<Bug 17880179> - R12: Price List Issue With Failed To Resolve Incompatibility
                            Between Pricelists
<Bug 17947726> - Multi-Currency Conversion Issue Wrong Currency Conversion Rate Is Used
<Bug 18056482> - Copy Price List Form Qpxprcpl: Item Category Lov Shows No Values
<Bug 18235252> - Crreate Modifier Get  Error Product Attribute Value Is Invalid
<Bug 18287889> - Unable To Modify/Update Fields In The Header Level In Price List
<Bug 18508650> - Add Items To Price List Fails With Ora-06502
<Bug 18641502> - Finish Configuration In Istore Takes More Than 1 Minute
                            Expecting Under 20 Seconds
<Bug 18661338> - Price List Created With Overlapping Dates By Bulk Import Process
<Bug 18800485> - R12 Pbh Not Applied With Freight Charge On First Liner Modifier
<Bug 19032170> - Qpxprfor: Query Only And Can Still Change Formula And Save
<Bug 19323551> - Error While Using Nvl2 Sql Function In Oracle Pricing Formula
<Bug 19555418> - Create Intercompany  Is Having Performance Issue
<Bug 8645132> -  Formula Factor Lists Not Working As Expected-Gives Errors On Order
<Bug 8688432> - Qpxvaplb Module: Adjust Price List Completes With Error
<Bug 9316468> - Re-Pricing Lines On Large Sales Orders Slow After Upgrade
<Bug 9475080> - Oexoeord Ora-06502: Pl/Sql: Numeric Or Value Error When Price Decimal Qty
<Bug 9645844> - Advanced Pricing Modifier Limits Consumed Amount Is Incorrect
<Bug 9660503> - Promotion Modifier Define Details Form Does Not Show Records Until Queried.
<Bug 9679930> - Launch Of Configurator Through Sales Order Takes More Than 15Minutes
<Bug 9680271> - Archive And Purge Entitty Issues
<Bug 9694761> - Price Lists (Xml) Running Into Error For Any Parameter
<Bug 9729769> - Upgrade Driver U6678700 Failing At Qpxdupla Ora-00001
<Bug 9732576> - Need To Add Where Condition In
                          Qp_Maintain_Denormalized_Data.Update_Qualifiers
<Bug 9832529> - After Patch 9694761 Start Date And End Date  Xml Version Is 1 Day Prior
<Bug 9848873> - R12 Modifier Product Attribute Value Cannot Be Updated Once
                          Warning Message Is Given
<Bug 9938422> - System Is Not Providing Full Lumpsum Discount On A Single Sales Order
<Bug 9970746> - Low Performance On Saving Om Order Lines
<Bug 9977712> - Oexoeord: Pricing Quantity Does Not Round To Whole Numbers

 

*In addition, this patch includes fixes in previous the patches as noted below.

 

<Patch 18249133:R12.QP.B>  - Superseded by <Patch 19572462>.R12.QP.B 
Advanced Pricing Recommended Patch Collection Jan 2014
The following bugs are fixed by this patch:

<Bug 10023220> - Promotional Limit Violation Error Comes Up At Order Entry Process
<Bug 10042660> - Frm-40212 In Qpxprmls For Prod Attr Value
<Bug 10051804> - Interface Trip Stop Ends In Warning With  Cst_Xfer_Price_Error Error
<Bug 10056032> - Open Price List Errors: Ora-01722: Invalid Number Frm-40505: Oracle Error Unab
<Bug 10093463> - List Price Is Not Rounded To Conversion Rouding Factor After Applying Multi-Curr
<Bug 10120724> - Acp> - Unable To Load Price Lists
<Bug 10130826> - Modifier Applied In Istore Gets Dropped In Om When Order Is Repriced
<Bug 10154917> - Poor Performance For Create Intercompany Ar Invoices Program With Qp Sql.
<Bug 10171380> - Qpxvblk: Performance Issue Qp Bulk Load Too Slow
<Bug 10255367> - Price List Setup Form Not Validating/Displaying Decimal  According To Profile Sy
<Bug 10269226> - Price Book Is Not Being Generated
<Bug 10273166> - Pricing Formulas Not Recogising Pricing Attributes In Factor List
<Bug 10377566> - R12.1 Promo Has Special Char(Chr (0))  Qp_List_Lines Include_On_Returns_Flag
<Bug 10394643> - After Applying The Patch 10136863 Some Problem Is Occurring In Promotion Item
<Bug 10625896> - Perf Issue With Oe_Agreements_B Merge Affecting Customer Merge And Field
<Bug 11718911> - Adjust Price List Gives Frm-40831: Truncation Occurred: Value Too Long For Field
<Bug 11719249> - Modifier Applying: Ignoring Category Set Assignment In Master Items Form
<Bug 11734858> - Add Items To Price List Program Updates Record History Of All Price List Lines
<Bug 11828647> - Er: Suppress The Print On Invoice Flag From The Modifier Ui.
<Bug 11898355> - Unable To Price Using Advanced Pricing When Migrating To R12.1.1
<Bug 12433027> - Range Break Modifier Does Not Apply If List Price Is Negative
<Bug 12539111> - Receiving Error Messages When Opening Multi-Currency Conversion Form
<Bug 12661047> - R12-Noa-Oltp-Dev-Om Error Message For> -
                                  Qp: Maintains The Denormalized Data In QP Qualifiers
<Bug 12670913> - Return Freight Charge Rounding Incorrectly
<Bug 12677276> - Interface Trip Stop Running Long Causing Peformance Issues
<Bug 12710486> - Attribute Qualifier Attribute Is Invalid.
<Bug 12766733> - Drop Ship Receipts Errors Rvtii-060: Subroutine Inv_Txn_Manager_Pub
<Bug 12778935> - Qp: Bulk Import Of Price List> - Bad Performance
<Bug 12784810> - R12 Different Error Message When Creating Pricing Agreement Revision Than R11
<Bug 12875196> - You Have Encountered An Unexpected Error. Please Contact The System Adminstrator
<Bug 12916970> - :Hard> - Adjust Benefit Amount Not Working As Expected R12 12352707
<Bug 12951945> - Release 12: Price Lists Report Fetching Details Of End Dated List Lines
<Bug 13045009> - Performance Issue With Archiving Of A Pricelist
<Bug 13110812> - Okl Header Multi-Currency Converion Changed By Qp_Price_List_Pub
<Bug 13250347> - Error Message In German Language Instead English
<Bug 13371371> - Modifier Limit Getting Consumed By 0 Price Line
<Bug 13395264> - Qp: Upgrade Pricing Data For Bulk Loader Didn'T Update All Orig_Sys_Header_
<Bug 13487501> - Bad Performance In Price Lists Qpxprlst
<Bug 13507103> - Not All Item Category Lov Work In The Add Items To Price List
<Bug 13508707> - Rma Received  But The Limit Modifier Available  Didn'T Add
<Bug 13521835> - Partial Units Seen In Available & Consumed Quantity In Pricing Modifier Screen
<Bug 13532774> - Qpxprfor.Fmb  Factor List Find Errors With Frm-40350
<Bug 13585536> - Add Qulaifier To Price List> -Attribute Value From Invalid Please Re-Enter
<Bug 13655307> - Pricing Errors While Copying An Existing Return Type Order
<Bug 13703332> - R12-Attribute Value From Shows Red/After Patch 13585536 For Invalid  Error
<Bug 13776174> - Pbh Modifr Lines W/Custom Volume Attr Not Apply Correctly After Patch 12916970
<Bug 13818038> - Gsa Price List Have Duplicates For One Itemã‚¿But Cannot Delete This Record
<Bug 13820039> - Issue With Lov For Item Category After Applying Patch 13507103
<Bug 13860628> - Price Break Lines Issues In Pricelist Bulk Import
<Bug 13877124> - In Block Pricing, Can'T Enter .25 In The Recurring Value.
<Bug 13881910> - Dff Field For Additional Info For List Lines Will Not Stay Populated
<Bug 13859133> - Modifier Details Report Showing Wrong Format After Page Breaks
<Bug 13877250> - Icx: Numeric Characters And General Preferences Number Format
<Bug 13896811> - Qualifier Grouping Report: Qualifier Attribute Value To Parameter
<Bug 14054072> - Best Price Supplier Ship And Debit Modifier Does Not Apply To Sales Order Line.
<Bug 14065769> - Qp: Maintains The Denormalized Data Not Working For Multi Org Security Rules
<Bug 14102682> - Promotional Limits Are Not Being Applied Correctly
<Bug 14103598> - Adv. Pricing Price Breaks First Break Has To Start With Zero/No Gaps Allowed I
<Bug 14169474> - App-Qp-225737 No Attributes Are Defined For This Context Insert  Price Break
<Bug 14367359> - Application Locks While Creating Bpas
                                  Qp_Delayed_Requests_Util.Update_Manual_Mod
<Bug 14393164> -  Long Completion Times For Interface Trip Stop When Debugs Are On
<Bug 14396941> - Tpa For Resale Table> - Perf Issue In Qp Engine Call
<Bug 14464004> - Price Book Generation Not Taking Place
<Bug 14611180> - Qp_List_Lines_V Gives Error Ora-01427: Single-Row Subquery Return More Than One
<Bug 14623252> - Use Api In R12 To Add Price Lines To Migrated 11I Price Lists
<Bug 14686371> - Folder Condition Not Working In Price List Form
<Bug 14763873> - Qpxupqul.Sql :12.1.3 Upgrade Qual_Attr_Value_From_Number Is Null In Qp_Qualifier
<Bug 14783146> - Form Locking In Order Management Due To Table Update Ozf_Order_Group_Prod
<Bug 14842950> - Order Import Performance Issue During Pricing Engine Code
<Bug 15895472> - Om Lines Not Properly Qualified
<Bug 15918451> - Modifier Detail Report Error Rep-0091:  When Modifer Name > 40 Characters
<Bug 15993256> - Poor Performance As 50 Factor List Lines Using Api, It Took Almost 1 Hour To Com
<Bug 16022996> - Performance Issue With Process_Modifiers Public Api
<Bug 16047733> - Po Line Comes Out As Incorrect When Multiple Po'S Are Created
                                  And When Qp_Runtime
<Bug 16051721> - Modifier With Accumulation Attribute Saves Accum_Attr_Run_Src_Flag Set To 'N'
<Bug 16246361> - Performance Issue In The Item Price List Api.
<Bug 16462621> - Api Passes The Value 'Y' To Continuous_Price_Break_Flag For Pbh An
<Bug 16570491> - Qp: Bulk Import Of Price List Delete Price Line But Left Price Attribute Line
<Bug 16590557> - Failed To Resolve Incompatibility Between Price Lists( ) Duplicate Price List Li
<Bug 16590629> - Fp :11683415 : Promotional Items Are Getting Duplicated And Added
<Bug 16657649> - Price Book Search Returning Incorrect Results Based On Effectivity End Date
<Bug 16658815> - After Patch 15993256  Applied, Factors Are Not Applying As Expected
<Bug 16803836> - Standard Cp  'Qp: Bulk Import Of Price List' Throwing Error
<Bug 16815807> - Ad Administration Utility To Maintain Multi-Lingual Tables Performance Qpnlins
<Bug 16863566> - Issue With Qp: Maintains The Denormalized Data In Qp Qualifiers Post Upgrade
<Bug 8645132> - 12.1.1:Of:Formula Factor Lists Not Working As Expected-Gives Errors On Order
<Bug 8688432> - Qpxvaplb Module: Adjust Price List Completes With Error
<Bug 9316468> - Re-Pricing Lines On Large Sales Orders Slow After Upgrade From 11.5.9 To 12.0.6
<Bug 9475080> - Oexoeord Get Ora-06502: Pl/Sql: Numeric Or Value Error When Price Decimal Qty
<Bug 9645844> - Advanced Pricing Modifier Limits Consumed Amount Is Incorrect
<Bug 9660503> - Promotion Modifier> -> Define Details Form Does Not Show Records Until Queried.
<Bug 9679930> - Launch Of Configurator Through Sales Order Takes More Than 15Minutes
<Bug 9680271> - Archive And Purge Entitty Issues
<Bug 9694761> - Price Lists (Xml) Running Into Error For Any Parameter
<Bug 9729769> - Upgrade Driver U6678700 Failing At Qpxdupla Ora-00001
<Bug 9732576> - Need To Add Where Condition In Qp_Maintain_Denormalized_Data.Update_Qualifiers
<Bug 9832529> - After Patch 9694761:R12.Qp.B  Start Date And End Date  Xml Version Is 1 Day Prio
<Bug 9848873> - R12 Modifier Product Attribute Value Cannot Be Updated Once Warning Message Is G
<Bug 9938422> - System Is Not Providing Full Lumpsum Discount On A Single Sales Order
<Bug 9970746> - Low Performance On Saving Om Order Lines
<Bug 9977712> - Oexoeord: Pricing Quantity Does Not Round To Whole Numbers

 

 

  

 

 

 

 



Contacts

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
Details
Actions
 Release 12.2 - RPL Patch(s) for Advanced Pricing 12.2
 Release 12.1 - RPL Patch(s) for Advanced Pricing 12.1
Contacts
References

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