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 FEBRUARY 17, 2017

Applies to:

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

Symptoms

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

ERROR
-----------------------
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(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:3068)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1898)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:557)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:439)
at _OA._jspService(_OA.java:213)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:429)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:911)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
at java.lang.Thread.run(Thread.java:745)
## 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. Login 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.


Changes

 

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