Readiness Configuration > 0RA-06502 on FND_LOOKUP_VALUES_PKG, Line 138 (Doc ID 2011112.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Getting an error when creating Readiness Configuration in the Payroll Dashboard.
Unable to proceed.
Happens for all Payrolls.



PARTIAL ERROR STACK
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.FND_LOOKUP_VALUES_PKG", line 138
ORA-06512: at line 1
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.pay.selfservice.dashboard.server.PayDashboardLookupEOImpl.insertRow(PayDashboardLookupEOImpl.java:821)
at oracle.apps.fnd.framework.server.OAPlsqlEntityImpl.doDML(Unknown Source)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4542)
at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1770)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3004)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2815)
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1978)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2180)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:705)
at oracle.apps.pay.selfservice.dashboard.webui.PayReadinessStartUpCO.processFormRequest(PayReadinessStartUpCO.java:253)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:854)
...
## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.FND_LOOKUP_VALUES_PKG", line 138
ORA-06512: at line 1
...
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.apps.pay.selfservice.dashboard.server.PayDashboardLookupEOImpl.insertRow(PayDashboardLookupEOImpl.java:816)
at oracle.apps.fnd.framework.server.OAPlsqlEntityImpl.doDML(Unknown Source)
at oracle.jbo.server.EntityImpl.postChanges(EntityImpl.java:4542)
at oracle.apps.fnd.framework.server.OAEntityImpl.postChanges(OAEntityImpl.java:1770)
at oracle.jbo.server.DBTransactionImpl.doPostTransactionListeners(DBTransactionImpl.java:3004)
at oracle.jbo.server.DBTransactionImpl.postChanges(DBTransactionImpl.java:2815)
at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:1978)
at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2180)
at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:705)
at oracle.apps.pay.selfservice.dashboard.webui.PayReadinessStartUpCO.processFormRequest(PayReadinessStartUpCO.java:253)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:854)
...


STEPS TO REPRODUCE
Payroll Professional > Payroll Dashboard > Readiness Configuration
> [Create]
> Enter data
  - Process Type = Concurrent Program
  - Process Name = BEE Batch Process
  - o Select Payrolls
  - select ANY Payroll in the LOV
> [Apply]
Receive error stack

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