My Oracle Support Banner

Fusion Applications - OTBI - "Workforce Profiles - Person Profile Real Time" Does Not Reflect Changes (Delete Record) In Fusion Applications UI (Manage Talent Profile) And Show Stale Data In Report (Doc ID 2116658.1)

Last updated on MARCH 15, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.10.0.0 and later
Oracle Fusion Application Toolkit Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Technology Management - Reports/Analytics

ACTUAL BEHAVIOR
---------------
Delete Profile Detail for the "Profile Content Type" (Screen-shot below)

 


Check the data in "Workforce Profiles - Person Profile Real Time" Subject Area (Screen-shot below):

 

The data in the Report shows the deleted record as well and does not reflect the changes from Fusion Applications UI


EXPECTED BEHAVIOR
-----------------------
This is an expected behavior, as the data is not deleted, but end dated.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Delete the record from "Manage Talent Profile" > "Profile Details" > Delete a record
2. Check the report. Below are the fields from Logical SQL of OTBI

 

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users can see the deleted record in the report output

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!


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