'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:

Symptoms

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);
  l_msg_rec.ORIG_SYS_QUALIFIER_REF := NULL;
  l_msg_rec.ORIG_SYS_PRICING_ATTR_REF := NULL;
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 $ */

Changes

Cause

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