COLLECT PRICE LIST ISSUES (Doc ID 1512870.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 7.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 7.3.0 version, LoadData

When attempting to collect price list
the following error occurs.


ERROR
-----------------------
Collecting Price Lists from source
In procedure: msd_dem_query_utilities.get_query2
The instance dblink for this query will be: @APS_TO_EBS
key=C_INSTANCE value=4021 i = 1
ORA-06502: PL/SQL: numeric or value error: character string buffer too small


select instance
,sr_item_pk
,price_list_name
,start_date
,end_date
,price
,priority
,primary_uom_flag
,product_uom_code
,item_pc_flag
,item_name
,uom
from C_SOURCE_VIEW_NAMEC_DBLINK

Start Time: 24-SEP-2012 15:18:51
ORA-00942: table or view does not exist

Issue#1 - COLLECT PRICE LIST ERRORED WHEN COLLECTING MORE THAN 8 PRICE LISTS
 

 
Issue#2 - Price list is having different attribute settings.
  Due to this one price list is not collected into demantra with a message of
  "Price list does not exist in source"
  Reason: It is assumed in the integration code that the price list attributes
 
  in the table qp_pricing_attributes.
  We have conditions filtering
  -----------------------------------------
  AND pricing_attribute_context IS NULL
  AND product_attribute_context = ''ITEM''
  AND product_attribute = ''PRICING_ATTRIBUTE1'' -- cust val = attr3
  AND product_attr_value = inventory_item_id     -- cust val = ALL

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. set up price list
2. Collect Price Lists



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