Fusion Apps OTBI - Payroll - Element Entries Real Time Subject Area Data Security - " Element" Folder Not Returning Data (Doc ID 1608963.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

Fusion HCM custom business intelligence BI analysis - no data returned

Within the "Payroll - Element Entries Real Time" subject area the "Element" Folder is not returning any information.

Including any attribute in the folder into an analysis results in No Results being displayed even though there must be data to display e.g. I can write a report starting with the "Element Entry Value"."Displayed Input Value" and "Input Value"."Input Value Name" which returns hundreds of rows with Salary, pensions and allowance type data however as soon as I add the "Element"."Element Name" field or any other field from the folder it returns no records.

I am using the HCM.USER user and have access to all the data as far as I can tell across all the subject areas so I don't this is a security issue.

 

A fact column is required however, even after testing with a Fact column this was not resolved.

SELECT 0 s_0, "Payroll - Element Entries Real Time"."Element Entry Value"."Displayed Input Value" s_1, "Payroll - Element Entries Real Time"."Input Value"."Input Value Name" s_2 FROM "Payroll - Element Entries Real Time"

ORDER BY 1, 3 ASC NULLS LAST, 2 ASC NULLS LAST FETCH FIRST 65001 ROWS ONLY /* QUERY_SRC_CD='rawSQL' */ ]] [2013-12-13T14:45:53.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-23] [] [ecid: 004vMi4u5ov33F15Rvo2yd0006Ip00029m,0:2:1:1:3] [tid: 46147940] [requestid: e5880019] [sessionid: e5880000] [username: HCM.USER] -------------------- General Query Info: [[ Repository: Star, Subject Area: Core, Presentation: Payroll - Element Entries Real Time ]] [2013-12-13T14:45:53.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-18] [] [ecid: 004vMi4u5ov33F15Rvo2yd0006Ip00029m,0:2:1:1:5] [tid: 46147940] [requestid: e5880019] [sessionid: e5880000] [username: HCM.USER] -------------------- Sending query to database named HCM_OLTP (id: <>), connection pool named Connection Pool, logical request hash 6e7af08e, physical request hash 80c20d49: [[ WITH SAWITH0 AS (select T1503195.C259192899 as c1, T1503195.C364350096 as c2 from (SELECT V152000763.SCREEN_ENTRY_VALUE AS C259192899, InputValueTranslationPEO.NAME AS C364350096, InputValueTranslationPEO.LANGUAGE AS C168602675, V152000763.ELEMENT_ENTRY_VALUE_ID AS PKA_ElementEntryValueId0, V152000763.EFFECTIVE_START_DATE AS PKA_EffectiveStartDate0, V152000763.EFFECTIVE_END_DATE AS PKA_EffectiveEndDate0, InputValueTranslationPEO.INPUT_VALUE_ID AS PKA_InputValueTranslationPEOI0 FROM PAY_ELEMENT_ENTRY_VALUES_F V152000763, PAY_INPUT_VALUES_F V525814381, PAY_INPUT_VALUES_TL InputValueTranslationPEO WHERE V525814381.INPUT_VALUE_ID = InputValueTranslationPEO.INPUT_VALUE_ID AND V152000763.INPUT_VALUE_ID = V525814381.INPUT_VALUE_ID AND ( ( (InputValueTranslationPEO.LANGUAGE = 'US' ) ) ) AND ( DATE'2013-12-13' BETWEEN V152000763.EFFECTIVE_START_DATE AND V152000763.EFFECTIVE_END_DATE)) T1503195) select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3 from ( select distinct 0 as c1, D1.c1 as c2, D1.c2 as c3 from SAWITH0 D1 order by c3, c2 ) D1 where rownum >), connection pool named Connection Pool, logical request hash 6e7af08e, physical request hash 446448e4: [[ BEGIN fnd_session_mgmt.attach_session('ED6C6550D09D82CBE0436710C10A7CE6'); END; ]] [2013-12-13T14:45:53.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-18] [] [ecid: 004vMi4u5ov33F15Rvo2yd0006Ip00029m,0:2:1:1:5:1] [tid: 41554940] [requestid: e5880019] [sessionid: e5880000] [username: HCM.USER] -------------------- Sending query to database named HCM_OLTP (id: <>), connection pool named Connection Pool, logical request hash 6e7af08e, physical request hash d90563e6: [[ BEGIN fnd_session_mgmt.detach_session; END; ]] [2013-12-13T14:45:53.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-34] [] [ecid: 004vMi4u5ov33F15Rvo2yd0006Ip00029m,0:2:1:2] [tid: 46147940] [requestid: e5880019] [sessionid: e5880000] [username: HCM.USER] --------------------
Query Status: Successful Completion [[ ]] [2013-12-13T14:45:53.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-26] [] [ecid: 004vMi4u5ov33F15Rvo2yd0006Ip00029m,0:2:1:2] [tid: 46147940] [requestid: e5880019] [sessionid: e5880000] [username: HCM.USER] --------------------
Rows 432, bytes 255744 retrieved from database query id: <> [[ ]] [2013-12-13T14:45:53.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-28] [] [ecid: 004vMi4u5ov33F15Rvo2yd0006Ip00029m,0:2:1:2] [tid: 46147940] [requestid: e5880019] [sessionid: e5880000] [username: HCM.USER] -------------------- Physical query response time 0 (seconds), id <> [[ ]] [2013-12-13T14:45:53.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-29] [] [ecid: 004vMi4u5ov33F15Rvo2yd0006Ip00029m,0:2:1:2] [tid: 46147940] [requestid: e5880019] [sessionid: e5880000] [username: HCM.USER] -------------------- Physical Query Summary Stats: Number of physical queries 1, Cumulative time 0, DB-connect time 0 (seconds) [[ ]] [2013-12-13T14:45:53.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-24] [] [ecid: 004vMi4u5ov33F15Rvo2yd0006Ip00029m,0:2:1:2] [tid: 46147940] [requestid: e5880019] [sessionid: e5880000] [username: HCM.USER] -------------------- Rows returned to Client 432 [[ ]] [



SELECT
  0 s_0,
  "Payroll - Element Entries Real Time"."Element Entry Value"."Displayed Input Value" s_1,
  "Payroll - Element Entries Real Time"."Element"."Element Name" s_2,
  "Payroll - Element Entries Real Time"."Input Value"."Input Value Name" s_3
FROM "Payroll - Element Entries Real Time"
ORDER BY 1, 2 ASC NULLS LAST, 4 ASC NULLS LAST, 3 ASC NULLS LAST
FETCH FIRST 65001 ROWS ONLY

/* QUERY_SRC_CD='rawSQL' */

]]
[2013-12-13T14:48:16.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-23] [] [ecid: 004vMiDOx0N33F15Rvo2yd0006Ip0002Ul,0:2:1:1:3] [tid: 46046940] [requestid: e5880021] [sessionid: e5880000] [username: HCM.USER] -------------------- General Query Info: [[
Repository: Star, Subject Area: Core, Presentation: Payroll - Element Entries Real Time


]]
[2013-12-13T14:48:16.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-18] [] [ecid: 004vMiDOx0N33F15Rvo2yd0006Ip0002Ul,0:2:1:1:5] [tid: 46046940] [requestid: e5880021] [sessionid: e5880000] [username: HCM.USER] -------------------- Sending query to database named HCM_OLTP (id: <>), connection pool named Connection Pool, logical request hash 8035f1e4, physical request hash eb2f729: [[
WITH
SAWITH0 AS (select T1503195.C259192899 as c1,
  T1503195.C461953723 as c2,
  T1503195.C364350096 as c3
from
  (SELECT V152000763.SCREEN_ENTRY_VALUE AS C259192899, V476371178.ELEMENT_NAME AS C461953723, V525814381.NAME AS C364350096, V476371178.LANGUAGE500 AS C309140230, V476371178.LANGUAGE716 AS C413000491, V525814381.LANGUAGE AS C168602675, V152000763.ELEMENT_ENTRY_VALUE_ID AS PKA_ElementEntryValueId0, V152000763.EFFECTIVE_START_DATE AS PKA_EffectiveStartDate0, V152000763.EFFECTIVE_END_DATE AS PKA_EffectiveEndDate0, V525814381.INPUT_VALUE_ID1 AS PKA_InputValueTranslationPEOI0, V476371178.ELEMENT_TYPE_ID1 AS PKA_ElementTypeTranslationPEO0, V476371178.CLASSIFICATION_ID1 AS PKA_ElementClassificationTran0 FROM (SELECT ElementEntryValueDPEO.CREATED_BY, ElementEntryValueDPEO.CREATION_DATE, ElementEntryValueDPEO.EFFECTIVE_END_DATE, ElementEntryValueDPEO.EFFECTIVE_START_DATE, ElementEntryValueDPEO.ELEMENT_ENTRY_VALUE_ID, ElementEntryValueDPEO.INPUT_VALUE_ID, ElementEntryValueDPEO.LAST_UPDATE_LOGIN, ElementEntryValueDPEO.LAST_UPDATE_DATE, ElementEntryValueDPEO.LAST_UPDATED_BY, ElementEntryValueDPEO.OBJECT_VERSION_NUMBER, ElementEntryValueDPEO.SCREEN_ENTRY_VALUE FROM PAY_ELEMENT_ENTRY_VALUES_F ElementEntryValueDPEO WHERE ( DATE'2013-12-13' BETWEEN ElementEntryValueDPEO.EFFECTIVE_START_DATE AND ElementEntryValueDPEO.EFFECTIVE_END_DATE)) V152000763, (SELECT InputValueDPEO.INPUT_VALUE_ID, InputValueDPEO.EFFECTIVE_END_DATE, InputValueDPEO.EFFECTIVE_START_DATE, InputValueDPEO.ELEMENT_TYPE_ID, InputValueTranslationPEO.INPUT_VALUE_ID AS INPUT_VALUE_ID1, InputValueTranslationPEO.LANGUAGE, InputValueTranslationPEO.NAME FROM PAY_INPUT_VALUES_F InputValueDPEO, PAY_INPUT_VALUES_TL InputValueTranslationPEO WHERE InputValueDPEO.INPUT_VALUE_ID = InputValueTranslationPEO.INPUT_VALUE_ID AND ( DATE'2013-12-13' BETWEEN InputValueDPEO.EFFECTIVE_START_DATE AND InputValueDPEO.EFFECTIVE_END_DATE)) V525814381, (SELECT ElementTypeDPEO.ELEMENT_TYPE_ID, ElementTypeDPEO.EFFECTIVE_END_DATE, ElementTypeDPEO.EFFECTIVE_START_DATE, ElementTypeTranslationPEO.ELEMENT_NAME, ElementTypeTranslationPEO.LANGUAGE AS LANGUAGE500, ElementTypeTranslationPEO.ELEMENT_TYPE_ID AS ELEMENT_TYPE_ID1, ElementClassificationTransPE.CLASSIFICATION_ID AS CLASSIFICATION_ID1, ElementClassificationTransPE.LANGUAGE AS LANGUAGE716 FROM PAY_ELEMENT_TYPES_F ElementTypeDPEO, PAY_ELEMENT_TYPES_TL ElementTypeTranslationPEO, PAY_ELE_CLASSIFICATIONS ElementClassificationPVO, PAY_ELE_CLASSIFICATIONS_TL ElementClassificationTransPE WHERE (ElementTypeDPEO.ELEMENT_TYPE_ID = ElementTypeTranslationPEO.ELEMENT_TYPE_ID AND ElementTypeDPEO.CLASSIFICATION_ID = ElementClassificationPVO.CLASSIFICATION_ID AND ElementClassificationPVO.CLASSIFICATION_ID = ElementClassificationTransPE.CLASSIFICATION_ID AND ( DATE'2013-12-13' BETWEEN ElementTypeDPEO.EFFECTIVE_START_DATE AND ElementTypeDPEO.EFFECTIVE_END_DATE)) AND ((1=2))) V476371178 WHERE V152000763.INPUT_VALUE_ID = V525814381.INPUT_VALUE_ID AND V525814381.ELEMENT_TYPE_ID = V476371178.ELEMENT_TYPE_ID AND ( ( (V525814381.LANGUAGE = 'US' ) ) AND ( (V476371178.LANGUAGE716 = 'US' ) ) AND ( (V476371178.LANGUAGE500 = 'US' ) ) )) T1503195)
select D1.c1 as c1, D1.c2 as c2, D1.c3 as c3, D1.c4 as c4 from ( select distinct 0 as c1,
  D1.c1 as c2,
  D1.c2 as c3,
  D1.c3 as c4
from
  SAWITH0 D1
order by c2, c4, c3 ) D1 where rownum
]]
[2013-12-13T14:48:16.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-18] [] [ecid: 004vMiDOx0N33F15Rvo2yd0006Ip0002Ul,0:2:1:1:5:2] [tid: 4260c940] [requestid: e5880021] [sessionid: e5880000] [username: HCM.USER] -------------------- Sending query to database named HCM_OLTP (id: <>), connection pool named Connection Pool, logical request hash 8035f1e4, physical request hash 446448e4: [[
BEGIN fnd_session_mgmt.attach_session('ED6C6550D09D82CBE0436710C10A7CE6'); END;

]]
[2013-12-13T14:48:16.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-18] [] [ecid: 004vMiDOx0N33F15Rvo2yd0006Ip0002Ul,0:2:1:1:5:2] [tid: 4260c940] [requestid: e5880021] [sessionid: e5880000] [username: HCM.USER] -------------------- Sending query to database named HCM_OLTP (id: <>), connection pool named Connection Pool, logical request hash 8035f1e4, physical request hash d90563e6: [[
BEGIN fnd_session_mgmt.detach_session; END;

]]
[2013-12-13T14:48:16.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-34] [] [ecid: 004vMiDOx0N33F15Rvo2yd0006Ip0002Ul,0:2:1:2] [tid: 46046940] [requestid: e5880021] [sessionid: e5880000] [username: HCM.USER] -------------------- Query Status: Successful Completion [[

]]
[2013-12-13T14:48:16.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-26] [] [ecid: 004vMiDOx0N33F15Rvo2yd0006Ip0002Ul,0:2:1:2] [tid: 46046940] [requestid: e5880021] [sessionid: e5880000] [username: HCM.USER] -------------------- Rows 1, bytes 32772 retrieved from database query id: SQLBypass Gateway [[

]]
[2013-12-13T14:48:16.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-28] [] [ecid: 004vMiDOx0N33F15Rvo2yd0006Ip0002Ul,0:2:1:2] [tid: 46046940] [requestid: e5880021] [sessionid: e5880000] [username: HCM.USER] -------------------- Physical query response time 0 (seconds), id SQLBypass Gateway [[

]]
[2013-12-13T14:48:16.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-26] [] [ecid: 004vMiDOx0N33F15Rvo2yd0006Ip0002Ul,0:2:1:2] [tid: 46046940] [requestid: e5880021] [sessionid: e5880000] [username: HCM.USER] -------------------- Rows 0, bytes 0 retrieved from database query id: <> [[

]]
[2013-12-13T14:48:16.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-28] [] [ecid: 004vMiDOx0N33F15Rvo2yd0006Ip0002Ul,0:2:1:2] [tid: 46046940] [requestid: e5880021] [sessionid: e5880000] [username: HCM.USER] -------------------- Physical query response time 0 (seconds), id <> [[

]]
[2013-12-13T14:48:16.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-29] [] [ecid: 004vMiDOx0N33F15Rvo2yd0006Ip0002Ul,0:2:1:2] [tid: 46046940] [requestid: e5880021] [sessionid: e5880000] [username: HCM.USER] -------------------- Physical Query Summary Stats: Number of physical queries 2, Cumulative time 0, DB-connect time 0 (seconds) [[

]]
[2013-12-13T14:48:16.000+00:00] [OracleBIServerComponent] [TRACE:2] [USER-24] [] [ecid: 004vMiDOx0N33F15Rvo2yd0006Ip0002Ul,0:2:1:2] [tid: 46046940] [requestid: e5880021] [sessionid: e5880000] [username: HCM.USER] -------------------- Rows returned to Client 0 [[

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