My Oracle Support Banner

Payroll Dashboard: Payroll List of Values (LOV) Error: ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2216420.1)

Last updated on MAY 14, 2019

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.


In the Payroll Dashboard, after selecting a value from the Payroll Name drop down list and selecting 'Go', the following error occurs.

select ppf.payroll_id,ppf.payroll_name, pay_dashboard_pkg.get_payroll_status(ppf.payroll_id) PrlStatus,
  pay_dashboard_pkg.get_readiness_check_date(ppf.payroll_id) ReadinessStatus
  from pay_payrolls_f ppf
  where ppf.payroll_id = nvl(:1,ppf.payroll_id)
  and ppf.business_group_id = :2
  and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
  order by 2
at oracle.apps.fnd.framework.OAException.wrapperException(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(
at _OA._jspService(
at com.orionserver.http.OrionHttpJspPage.service(
at oracle.jsp.runtimev2.JspPageTable.service(
at oracle.jsp.runtimev2.JspServlet.internalService(
at oracle.jsp.runtimev2.JspServlet.service(
at javax.servlet.http.HttpServlet.service(
at com.evermind.server.http.ResourceFilterChain.doFilter(
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(
at com.evermind.server.http.EvermindFilterChain.doFilter(
at com.evermind.server.http.ServletRequestDispatcher.invoke(
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(
at com.evermind.server.http.HttpRequestHandler.processRequest(
at com.evermind.util.ReleasableResourcePooledExecutor$
## Detail 0 ##
java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows   ===================== The real error message is here!
ORA-06512: at "APPS.PAY_DASHBOARD_PKG", line 374

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

1. Log in to Oracle Home Page: Select Payroll Professional > Payroll Dashboard > Payroll Dashboard.
2. Refer to the Payroll Name from the drop down LOV underneath the Payroll Readiness Details section and click the Go Button.
3. Error occurs – click here for details reveals: "You have encountered an unexpected error. Please contact the System Administrator for assistance. Click here for exception details."
4. Screenshot of payroll dashboard error as shown above.


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

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