My Oracle Support Banner

'QP: Bulk Import Of Price List' Not Populating Orig_sys_qualifier_ref In Errors Table (Doc ID 2147855.1)

Last updated on JULY 06, 2020

Applies to:

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


On : 12.2.4 version, Pricing Engine
'QP: Bulk Import of Price List' program is not populating orig_sys_qualifier_ref in QP_INTERFACE_ERRORS table. Due to this we are unable to get proper error reporting for the price list interface.

We tried to analyze the issue and found the following details:

1. The Price List Qualifiers are validated using the procedure 'QP_BULK_VALIDATE.ENTITY_QUALIFIER'.
2. In the procedure 'QP_BULK_VALIDATE.ENTITY_QUALIFIER' the message details (for error_log) is set as
  l_msg_rec.ORIG_SYS_HEADER_REF := p_qualifier_rec.orig_sys_header_ref(I);
  l_msg_rec.ORIG_SYS_QUALIFIER_REF := p_qualifier_rec.orig_sys_qualifier_ref(I);
3. As the 'l_msg_rec.ORIG_SYS_QUALIFIER_REF' is set to NULL, we are getting NULL value in the ORIG_SYS_QUALIFIER_REF.
4. Instead of setting the 'l_msg_rec.ORIG_SYS_LINE_REF' to NULL it seems the code sets the 'l_msg_rec.ORIG_SYS_QUALIFIER_REF' value to NULL.

Header details for QP_BULK_VALIDATE package body:
/* $Header: QPXBLVAB.pls 120.71.12020000.2 2013/08/02 05:53:46 kdurgasi ship $ */




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

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

In this Document

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