My Oracle Support Banner

Service HTML Error "Action Did Not Succeed Due To The Use Of The Browser Navigation Buttons" Exception JBO-27122 (Doc ID 1902990.1)

Last updated on JULY 21, 2020

Applies to:

Oracle Customer Support - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to update a Service Request in Service HTML, the following error occurs:

Error

Action did not succeed due to the use of the browser navigation buttons. The page has been refreshed. Any un-saved changes may have been lost.

Exception Details:
 
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation.

Statement:
select  rownum as data_id , log_date , case when order_log_time = 2
  then case when lead(order_log_time) over (order by order_log_date desc) = 1
  then case when sr_log_time <> lead(to_char(sr_log_date, fnd_profile.value('CSZ_LOG_TIME_FORMAT')))       over (order by order_log_date desc)
  then lead(to_char(sr_log_date, fnd_profile.value('CSZ_LOG_TIME_FORMAT'))) over (order by order_log_date desc)||' '|| fnd_message.get_string('CS', 'CSZ_LOG_TO') ||' '|| sr_log_time ||' - '||user_name
else sr_log_time||' - '||user_name       end     else       sr_log_time||' - '||user_name
 end
   else case when sr_log_time is not null then  sr_log_time||' - '||user_name
     else    null
      end
[...]

Steps to Reproduce

(R) Customer Support Specialist
(N) Agent Dashboard
   - Open a Service Request
   - Open another IE tab or window and open another responsibility
   - Go back to the SR, add a note and save

The issue also occurs when nothing else from the E-Business Suite is open on a different Tab or Window.
Noticed that when updating the SR, the Framework drop-down lists for "Navigator" and "Favorites" are being displayed unintentionally.

Changes

 

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
Changes
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.