My Oracle Support Banner

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

Last updated on FEBRUARY 22, 2019

Applies to:

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


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(
  at oracle.apps.fnd.framework.server.OAPlsqlViewRowImpl.callAPI(
  at oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.callAPI(
  at oracle.apps.fnd.framework.server.OAPlsqlViewObjectImpl.beforeCommit(
  at oracle.jbo.server.DBTransactionImpl.commitInternal(
  at oracle.jbo.server.DBTransactionImpl.commit(
  at oracle.apps.fnd.framework.server.OADBTransactionImpl.commit(


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.