Buttons On Salary OAF Page Raising Exception On Every First Click (Doc ID 1682074.1)

Last updated on AUGUST 10, 2016

Applies to:

Oracle Human Resources - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Salary Admin Issues

When attempting to select salary button on OAF page, the following exception occurs on every first click

ERROR
-----------------------
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT DECODE (fnd_profile.VALUE ('BEN_DISPLAY_EMPLOYEE_NAME'),
  'FN', papf.full_name,
  papf.first_name || ' ' || papf.last_name
  ) employee_name,
  DECODE (fnd_profile.VALUE ('BEN_DISPLAY_EMPLOYEE_NAME'),
  'FN', papf1.full_name,
  papf1.first_name || ' ' || papf1.last_name
--------------------
---------------------------
## Detail 0 ##
java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04061: existing state of package body "APPS.HR_SECURITY" has been invalidated
ORA-04065: not executed, altered or dropped package body "APPS.HR_SECURITY"


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Query Employee for First time
2) Go to salary screen
3) Click Add New Salary -> Exception attched in word documnet appears
4) Close Salary Screen only (not assignment screen)
5) Launch Salary screen again
6) Click Add New Salary -> No Issue will come.. It will successfully navigate to next screen.
7) change salary details on next screen
8) click on Apply -> Exception details will come
9) Close Salary Screen only (not assignment screen)
10) Launch Salary screen again
11) Click Add New Salary --> succesfull
12) change salary details on next screen
13) Apply -> Sucecssfull

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users need to go Live next month

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