My Oracle Support Banner

Error Occurs when Create Combinations From Member Management - ORA-20002-904 ORA-00904: "VI_LOC_ID": invalid identifier Error in PROCEDURE CHAINING_MDP_ADD.CHAINING_MDP_ADD (Doc ID 2803435.1)

Last updated on SEPTEMBER 04, 2021

Applies to:

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

Symptoms

On : 12.2.6.3 version, Member Management, Production Environment


When attempting to create combinations from Member Management,
Insert rows ends in error

the following error occurs.

ERROR
-----------------------
CHAINING_MDP_ADD ORA-20002-904 ORA-00904: "VI_LOC_ID": invalid identifier Error in PROCEDURE CHAINING_MDP_ADD.CHAINING_MDP_ADD line 431
  dynamic_number( 'SELECT COUNT(*)
  FROM sales_data
  WHERE item_id = vi_item_id
  AND location_id = vi_loc_id
  AND TRUNC(sales_date) = TRUNC('05-01-2021 00:00:00')')

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log in to Member Management
2. Try to insert rows
3. Error occurs


Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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