My Oracle Support Banner

Payroll Balances Subject Area Not Pulling Year To Date Dimension (Doc ID 2650423.1)

Last updated on MARCH 19, 2020

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.13.19.10.0 and later
Information in this document applies to any platform.

Goal

Payroll Balances subject area not giving any results for Year to date dimension , I see results for NoCB Run dimension but not for Year to Date.


Payroll - Payroll Balances Real Time"."Balance Category"."Base Category Name" s_1,
"Payroll - Payroll Balances Real Time"."Balance Dimension"."Base Dimension Name" s_2,
"Payroll - Payroll Balances Real Time"."Balance Types"."Balance Name" s_3,
"Payroll - Payroll Balances Real Time"."Balance Value Details"."Area1" s_4,
"Payroll - Payroll Balances Real Time"."Balance Value Details"."Area2" s_5,
"Payroll - Payroll Balances Real Time"."Balance Value Details"."Area3" s_6,
"Payroll - Payroll Balances Real Time"."Balance Value Details"."Area4" s_7,
"Payroll - Payroll Balances Real Time"."Balance Value Details"."Context Value 1" s_8,
"Payroll - Payroll Balances Real Time"."Balance Value Details"."Effective Date" s_9,
"Payroll - Payroll Balances Real Time"."Payroll Actions"."Date Earned" s_10,
"Payroll - Payroll Balances Real Time"."Payroll Actions"."Effective Date" s_11,
"Payroll - Payroll Balances Real Time"."Worker"."Employee First Name" s_12,
"Payroll - Payroll Balances Real Time"."Worker"."Employee Last Name" s_13,
"Payroll - Payroll Balances Real Time"."Worker"."Person Number" s_14,
"Payroll - Payroll Balances Real Time"."Worker"."Primary National Identifier Number" s_15,
"Payroll - Payroll Balances Real Time"."Balance Value"."Balance Value" s_16
FROM "Payroll - Payroll Balances Real Time"
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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