How to print HTML Tags in comments columns (Doc ID 2024007.1)

Last updated on JULY 08, 2015

Applies to:

Oracle Fusion Goal Management Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

On :  11.1.8.0.0 version, Technology Management - BI & Reporting
 
ACTUAL BEHAVIOR  
---------------
Subject Areas Workforce Goals - Goal Status Overview Real Time - Printing XML tags in comments colum  

Subject Areas
Workforce Goals -  Goal Status Overview Real Time

The report is showing html tags in the Goals Comments  (  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Comments") instead of printing them in HTML format.

Here is the full sql:


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Update the Employee Goals Comment using Rich Text in the Manage Employee Goals
2. Run a BI Analysis like the following sql:
SELECT 0 s_0,
  "Workforce Goals - Goal Status Overview Real Time"."Department"."Department Name" s_1,
  "Workforce Goals - Goal Status Overview Real Time"."Job"."Job Name" s_2,
  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals - Additional Attributes"."Status" s_3,
  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals - Additional Attributes"."Target Completion Date" s_4,
  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Actual Completion Date" s_5,
  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Actual Value" s_6,
  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Approval Status" s_7,
  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Category" s_8,
  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Comments" s_9,
  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Description" s_10,
  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Goal Source" s_11,
  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Performance Goal Name" s_12,
  "Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Start Date" s_13,
  "Workforce Goals - Goal Status Overview Real Time"."Worker"."Employee List Name" s_14,
  "Workforce Goals - Goal Status Overview Real Time"."Worker"."Manager Name" s_15,
  "Workforce Goals - Goal Status Overview Real Time"."Worker"."Person Number" s_16,
  "Workforce Goals - Goal Status Overview Real Time"."Worker"."Termination Date" s_17,
  DESCRIPTOR_IDOF("Workforce Goals - Goal Status Overview Real Time"."Performance Goals - Additional Attributes"."Status") s_18,
  DESCRIPTOR_IDOF("Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Approval Status") s_19,
  DESCRIPTOR_IDOF("Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Category") s_20,
  DESCRIPTOR_IDOF("Workforce Goals - Goal Status Overview Real Time"."Performance Goals"."Goal Source") s_21
FROM "Workforce Goals - Goal Status Overview Real Time"

 
 

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