OAException java.sql.SQLException ORA-20002 When Updating Multiple Shift Durations. (Doc ID 1996480.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Resource Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When trying to update shift duration for multiple lines, the following error is received:

Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20002: 3139: 0/12 of item attribute update succeed for item 'PARMATRX/22405'
ORA-06512: at "APPS.PA_SCHEDULE_PUB", line 402
ORA-06512: at line 1

  at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
  at oracle.apps.pa.schedule.server.UpdateScheduleVORowImpl.updateRow(UpdateScheduleVORowImpl.java:667)
  at oracle.apps.fnd.framework.server.OAPlsqlViewRowImpl.callAPI(OAPlsqlViewRowImpl.java:111)
  at oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.callAPI(OAPlsqlViewObjectImpl.java:163)
  at oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.beforeCommit(OAPlsqlViewObjectImpl.java:430)
  at oracle.jbo.server.DBTransactionImpl.commitInternal(DBTransactionImpl.java:2009)
  at oracle.jbo.server.DBTransactionImpl.commit(DBTransactionImpl.java:2173)
  at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(OADBTransactionImpl.java:690)
  at oracle.apps.pa.schedule.webui.UpdateScheduleTopCO.processFormRequest(UpdateScheduleTopCO.java:580)

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