Service Costs or Charges Report: Errors JBO-27122, java.sql.SQLException, ORA-01403, ORA-06512: at "APPS.HZ_TIMEZONE_PUB"
(Doc ID 1558127.1)
Last updated on FEBRUARY 06, 2022
Applies to:
Oracle Teleservice - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
When attempting to perform one of the following actions from the 'Create Service Request' form:
- Run the Charges Report
- View Cost Details
the following error occurs.
Error:
## Detail 0 ##
java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-01403: no data found
ORA-06512: at "APPS.HZ_TIMEZONE_PUB", line 708
*or*
You have encountered an unexpected error. Please contact your System Administrator for assistance.
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT inc.incident_id "incident_id" , inc.incident_number "ServiceRequestNumber" ,
## Detail 0 ##
java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-01403: no data found
ORA-06512: at "APPS.HZ_TIMEZONE_PUB", line 708
Steps:
Scenario 1:
(R) Service
(N) Service Requests > Create / Find Service Requests
- Create a new SR, or open an existing SR
- Navigate to the Charges Tab and add Charges lines
- Click Charges Report button.
Scenario 2:
(R) Service
(N) Service Requests > Create / Find Service Requests
- Create a new SR, or open an existing SR
- Navigate to the Charges Tab and add Charges lines
- Click on Menu > Tools2 > View Cost Details
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 |