My Oracle Support Banner

JBO-27122: SQL Error - Page Exception When Clicking Cancel Button On Service Request HTML (Doc ID 2675931.1)

Last updated on MAY 29, 2020

Applies to:

Oracle Teleservice - Version 12.2.8 and later
Information in this document applies to any platform.


Users are getting a "Page Exception" error when clicking on Cancel button on the Service Request HTML Screen.

Navigation and Steps:

Field Service Manager-->Service Request-->Customer Management-->HTML Contact center--> Search for customer--> navigate to service request info tile.
--> Click on Service request hyperlink to open any of the SR.
--> Navigate to Resolution and wrap up tab to open the Task.
-->click on Cancel button on the Task details page.
-->page will navigate to Service request HTML
-->Click on cancel button on the service request to navigate back to html contact center.

Page will error .

Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT a.party_type,
FROM csc_prof_module_groups a,
  csc_prof_groups_b b
WHERE a.dashboard_group_id = b.group_id
  AND a.party_type IN (:1,'ALL')
  AND a.form_function_name = :2
  AND (((a.responsibility_id = :3
  AND a.resp_appl_id = :4
  ) AND a.responsibility_id IS NOT NULL
  ) OR a.responsibility_id IS NULL
  AND TRUNC(Sysdate) BETWEEN TRUNC(NVL(b.start_date_active, Sysdate))
AND TRUNC(NVL(b.end_date_active, Sysdate))
  ORDER BY a.party_type DESC,




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.