Import Interface Throws An Error Saying Mdp_matrix.location_id Is Missing (Doc ID 2288021.1)

Last updated on JULY 19, 2017

Applies to:

Oracle Demantra Predictive Trade Planning - Version 12.2.6.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.6.1 version, LoadData

Import interface throws an error saying mdp_matrix.location_id is missing
Customer has upgraded from 731 to 12.2.6.1. They did a Application and Platform upgrade
Post the upgrade when they import using this integration interface the same fails with the error


ERROR
-----------------------

MERGE INTO PROMOTION_DATA TRG
USING (SELECT
PROMOTION_DATA.ITEM_ID AS ITEM_ID
,PROMOTION_DATA.LOCATION_ID AS LOCATION_ID
,PROMOTION_DATA.SALES_DATE AS SALES_DATE
,PROMOTION_DATA.PROMOTION_ID AS PROMOTION_ID
,INT_TABLE.ea_fund_fix_amt AS INT_VAL_0
,INT_TABLE.ea_cp_trans AS INT_VAL_1
FROM T_IMP_986_389_2101700831 INT_TABLE
,PROMOTION_MATRIX
,PROMOTION_DATA
WHERE PROMOTION_MATRIX.ITEM_ID = PROMOTION_DATA.ITEM_ID
AND PROMOTION_MATRIX.LOCATION_ID = PROMOTION_DATA.LOCATION_ID
AND PROMOTION_MATRIX.PROMOTION_ID = PROMOTION_DATA.PROMOTION_ID
AND MDP_MATRIX.ITEM_ID = PROMOTION_MATRIX.ITEM_ID
AND MDP_MATRIX.LOCATION_ID = PROMOTION_MATRIX.LOCATION_ID
AND PROMOTION_MATRIX.PROMOTION_ID = INT_TABLE.LEVEL1
AND PROMOTION_DATA.SALES_DATE = INT_TABLE.SDATE
AND INT_TABLE.CHUNK_ID = ?
)SRC
ON (SRC.ITEM_ID = TRG.ITEM_ID
AND SRC.LOCATION_ID = TRG.LOCATION_ID
AND SRC.SALES_DATE = TRG.SALES_DATE
AND SRC.PROMOTION_ID = TRG.PROMOTION_ID)
WHEN MATCHED THEN UPDATE SET TRG.LAST_UPDATE_DATE = SYSTIMESTAMP
,TRG.EA_FUND_FIX_AMT = (CASE WHEN TRG.EA_FUND_FIX_AMT IS NULL
AND SRC.INT_VAL_0 IS NULL THEN NULL ELSE NVL(TRG.EA_FUND_FIX_AMT, 0)+NVL(SRC.INT_VAL_0, 0) END)
,TRG.EA_CP_TRANS_AMT = (CASE WHEN TRG.EA_CP_TRANS_AMT IS NULL
AND SRC.INT_VAL_1 IS NULL THEN NULL ELSE NVL(TRG.EA_CP_TRANS_AMT, 0)+NVL(SRC.INT_VAL_1, 0) END)
2017-06-13 07:40:09,308 PDT [Level_Method_0] ERROR integration.sql: --Import Data SetBase merge LUD into MATRIX SQL:
MERGE INTO PROMOTION_MATRIX TRG
USING (SELECT DISTINCT
PROMOTION_MATRIX.ITEM_ID AS ITEM_ID
,PROMOTION_MATRIX.LOCATION_ID AS LOCATION_ID
,PROMOTION_MATRIX.PROMOTION_ID AS PROMOTION_ID
FROM T_IMP_986_389_2101700831 INT_TABLE
,PROMOTION_MATRIX
WHERE MDP_MATRIX.ITEM_ID = PROMOTION_MATRIX.ITEM_ID
AND MDP_MATRIX.LOCATION_ID = PROMOTION_MATRIX.LOCATION_ID
AND PROMOTION_MATRIX.PROMOTION_ID = INT_TABLE.LEVEL1
AND INT_TABLE.CHUNK_ID = ?
)SRC
ON (SRC.ITEM_ID = TRG.ITEM_ID
AND SRC.LOCATION_ID = TRG.LOCATION_ID
AND SRC.PROMOTION_ID = TRG.PROMOTION_ID)
WHEN MATCHED THEN UPDATE SET TRG.PROMOTION_DATA_LUD = SYSTIMESTAMP
2017-06-13 07:40:09,343 PDT [Level_Method_0] ERROR integration.process:
com.demantra.applicationServer.appServerExceptions.ApplicationServerException: java.sql.SQLSyntaxErrorException: ORA-00904: "MDP_MATRIX"."LOCATION_ID": invalid identifier



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade Demantra to 12.2.6.1
2. Run the integration interface to upload data


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