My Oracle Support Banner

'QP: Bulk Import Of Price List' Is Taking A Long Time To Complete in Update Mode. (Doc ID 2379813.1)

Last updated on SEPTEMBER 22, 2018

Applies to:

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

Symptoms

On : 12.2.7 version, Price List

ACTUAL BEHAVIOR
---------------
The program 'QP: Bulk Import of Price List' is taking a very long time to complete.
On further investigation we found the standard program gets stuck at an update statement for a long time.


UPDATE QP_INTERFACE_LIST_LINES QPIL SET ( ACCRUAL_CONVERSION_RATE,
ACCRUAL_FLAG, ACCRUAL_QTY, ACCRUAL_UOM_CODE, ARITHMETIC_OPERATOR,
ATTRIBUTE1, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14,
ATTRIBUTE15, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6,
ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, AUTOMATIC_FLAG, BASE_QTY, BASE_UOM_CODE,
BENEFIT_LIMIT, BENEFIT_PRICE_LIST_LINE_ID, BENEFIT_QTY, BENEFIT_UOM_CODE,
CHARGE_SUBTYPE_CODE, CHARGE_TYPE_CODE, COMMENTS, CONTEXT,
....
FROM QP_LIST_LINES PLL, QP_RLTD_MODIFIERS RM
WHERE
RM.TO_RLTD_MODIFIER_ID = QPLL.LIST_LINE_ID AND RM.FROM_RLTD_MODIFIER_ID =
PLL.LIST_LINE_ID AND RM.RLTD_MODIFIER_GRP_TYPE='PRICE BREAK' ),
DECODE(QPIL.PRICE_BREAK_HEADER_REF, :B2 , NULL, QPIL.PRICE_BREAK_HEADER_R
...
QPLL.LIST_HEADER_ID = QPLH.LIST_HEADER_ID AND QPLH.ORIG_SYSTEM_HEADER_REF=
QPIL.ORIG_SYS_HEADER_REF ) WHERE QPIL.REQUEST_ID = :B1 AND
QPIL.PROCESS_STATUS_FLAG = 'P' AND QPIL.INTERFACE_ACTION_CODE IN ('UPDATE',
'DELETE')

EXPECTED BEHAVIOR
-----------------------
Expect QP: Bulk Import to have better performance.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Oracle Pricing Manager
2. Reports
3. Load interface data
4. Run QP: Bulk Import for Price Lists.


Cause

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
Symptoms
Cause
Solution
References


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