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

Last updated on MARCH 08, 2017

Applies to:

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

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 $ */

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms