My Oracle Support Banner

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.


On : 12.2.4 version, Rolling Profile Data

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

Data to be copied from one series to another .



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


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.

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.


To view full details, 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 a vibrant support community of peers and Oracle experts.