My Oracle Support Banner

Issues with "Payroll Reconciliation Detail Report" Parameters (Doc ID 2151782.1)

Last updated on NOVEMBER 12, 2023

Applies to:

Oracle HRMS (Australia) - Version 12.1.3 and later
Information in this document applies to any platform.
This note provides a brief overview of and .

Symptoms

Problem Statement:

Following issues are observed for "Payroll Reconciliation Detail Report".

<Issue #1>

Employee LOV in the Employee parameter is not restricting employees to be retrieved depending on the values specified in other parameters (e.g.Organization, Legal Employer, Payroll).


<Issue #2>

Opening Employee LOV throws the following error when non-mandatory parameters Start Date and End Date are not specified.

No entries found for List of Values
APP-FND-01436: List of Values cannot find any values for you to choose

Cause: The List of Values execution failed to find any values.

Cause: The SQL statement specified to fdlfch() failed to return any values.

Action: Check the message stack for any SQL statement failure messages. Check
to make sure your SQL statement works in SQL*Plus. (ROUTINE=fdlfch)
No entries found for List of Values

 
<Issue #3>

Concurrent request for "Payroll Reconciliation Detail Report" fails with status=error, however no error message is shown in the request log if the program is run without specifying non-mandatory parameters Start Date and End
Date.

 

Steps to Reproduce:

The issue can be reproduced at will with the following steps:

<Issue #1>

  1. Go to Submit Request.
  2. Enter program "Payroll Reconciliation Detail Report".
  3. Select Legal Employer.
  4. Open Employee LOV.
  5. All the employees are listed.
    Same for payroll and organization.

 

<Issue #2>

  1. Go to Submit Request.
  2. Enter program "Payroll Reconciliation Detail Report".
  3. Open Employee LOV.
  4. Error occurs.

 

<Issue #3>

  1. Go to Submit Request.
  2. Enter program "Payroll Reconciliation Detail Report".
  3. Submit the request without specifying start/end dates.
  4. Program fails with status=error with no actual error message in the log file.

 

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!


In this Document
Symptoms
Cause
Solution
References


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