My Oracle Support Banner

After Apply RUP12 Update Function Raise The Error Oracle.apps.fnd.framework.OAException: Java.sql.SQ (Doc ID 2559456.1)

Last updated on DECEMBER 09, 2022

Applies to:

Oracle Self-Service Human Resources - Version 12.2 HRMS RUP12 to 12.2 HRMS RUP13 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Problem Statement:

When attempting to click Update Action in existing workflow after applying RUP12 , the following error occurs.

Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20002: 3103: Attribute
'HR_CONTACT_HIRE_FLOW' does not exist for item 'HRSSA/10672336'.
ORA-06512: at "APPS.WF_CORE", line 318
ORA-06512: at "APPS.WF_ENGINE", line 1656
ORA-06512: at line 1
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at
oracle.apps.fnd.framework.webui.OANavigation.getItemAttrText(OANavigation.java:2093)
at
oracle.apps.fnd.framework.webui.OANavigation.getItemAttrText(OANavigation.java:2045)
at
oracle.apps.pqh.selfservice.common.webui.EffectiveDateCO.processRequest(EffectiveDateCO.java:1
91)
at

 

 

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

  1.  Use the Non RUP12 (such as RUP11) Patch Environment

  2.  Login as Manager by using Seeded Manager Self Service Responsibility
     
  3.  Make a Transaction for Change Hours
  4.  Save for Later(Don't Submit the Changes)
  5. Applied the RUP12
  6. Log back as the Manager and Continue the Transaction(click the update action)
  7. Error can be seen.

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.