My Oracle Support Banner

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

Last updated on MARCH 01, 2019

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

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.