Endeca - Project Workplan Overview Charts Are Not Loading (Doc ID 1958399.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Management - Version 12.1.3.1 and later
Information in this document applies to any platform.

Symptoms

Issue : 1. Task Due To Start (in Days) is not working
Navigation : Project Super User (R) --> Projects: Delivery -->? Project Search and Overview Page
  Select Project --> Actions --> Workplan
  Published Version - Report --> Workplan
Data Domain : prj-pjt-top
Endeca View : Tasks Starting Soon
Failing Clause : and task_status = 'Not Started'

2. Task Start Delays (in Days) showing wrong result :
Navigation : Project Super User (R) --> Projects: Delivery --> Project Search and Overview Page
  Select Project --> Actions --> Workplan
  Published Version - Report --> Workplan
Data Domain : prj-pjt-top
Endeca View : TaskStartDelay
Failing Clause : and COALESCE(task_status,'Not Started') = 'Not Started'

In this case since the task status name is coming in Arabic and it is coming as null in endeca while loading, so all the tasks are showing in the graph is respective of the status.


Reason for the Issue : 1. Check is the against the Status Name but it should be against the status code.
  2. For the customer Status Name is in Arabic so the status code should be checked.
  3. Status Code is along the status Name should be picked in the Endeca ETL view Query.

Forward the issue to DEV since the status check should be against the status code not the status name.

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