Rolling Profile Execution Is Not Giving The Required Output - ORA-00904: ""LOCATION"".""LOCATION_ID"": invalid identifier (Doc ID 2098357.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Rolling Profile Data

ACTUAL BEHAVIOR
---------------
Data is not copied from one series to another using rolling data profile functionality.

EXPECTED BEHAVIOR
-----------------------
Data to be copied from one series to another .

 

ERROR
--------

In db_exception_log table, the bellow error was noticed:

"BACKGROUND","-6550 ORA-06550: line 1, column 909:
 PL/SQL: ORA-00904: ""LOCATION"".""LOCATION_ID"": invalid identifier

 



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Business Modeler.
2. Navigate to Configuration -> Rolling Profiles -> Click on Execute button.
3. Log into Collaborator Workbench.
4. Data was not copied from Demand Plan series to Demand Plan 1M LAG series.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use rolling data profile functionality to archive data. This is happening in CRP Instance.

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