My Oracle Support Banner

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

Last updated on JULY 07, 2020

Applies to:

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


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 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,
  '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"

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 attached in word document 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 --> successful
12) change salary details on next screen
13) Apply -> Successful


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.