Unable To Fetch Data From "Payroll Interface Inbound Record Real Time" Subject Area (Doc ID 2222546.1)

Last updated on JANUARY 12, 2017

Applies to:

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

Symptoms

On : Rel 11 Pb 11 version, Global Human Resources

ACTUAL BEHAVIOR
---------------
Have requirement to load payroll interface inbound records data and has loaded data into those tables using HCM Data loader with PayrollInterfaceInboundRecord.dat file.
When we try to create an analysis using "Payroll Interface Inbound Records Real Time" subject area, we are not able to get any output if he selects fields from HRY_PI_INBD_RECORDS table. It is saying "No Rows exist for the specified criteria".
However when selecting only the fields from Child Record HRY_PI_INBD_RECORD_INFORMATION, are able to see data in the output. 

Why are we unable to see the inbound records information from parent table?


EXPECTED BEHAVIOR
-----------------------
To be able to fetch data from "Payroll Interface Inbound Records Real Time" subject area.
 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Load data into HRY_PI_INBD_RECORDS and HRY_PI_INBD_RECORD_INFORMATION tables using HCM Data loader with PayrollInterfaceInboundRecord.dat file
2. Try to create an analysis using "Payroll Interface Inbound Records Real Time" subject area
3. Not being able to get any output if he selects fields from HRY_PI_INBD_RECORDS table: "No Rows exist for the specified criteria"
4. When selecting only the fields from Child Record HRY_PI_INBD_RECORD_INFORMATION, being able to see data in the output.


BUSINESS IMPACT
-----------------------
The issue has the following business impact

Unable to fetch data from "Payroll Interface Inbound Records Real Time" subject area.

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