My Oracle Support Banner

Error When Trying to Update a Case Folder: ORA-06512: APPS.HZ_TIMEZONE_PUB (Doc ID 2785785.1)

Last updated on NOVEMBER 18, 2024

Applies to:

Oracle Credit Management - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

Error when trying to update a case folder:


Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT CaseFoldersEO.CASE_FOLDER_ID,
   CaseFoldersEO.CASE_FOLDER_NUMBER,
   CaseFoldersEO.CREDIT_REQUEST_ID,
...
## Detail 0 ##
java.sql.SQLException: ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "APPS.HZ_TIMEZONE_PUB", line 708
ORA-06512: at "APPS.HZ_TIMEZONE_PUB", line 702
ORA-01403: no data found
ORA-06512: at "APPS.HZ_TIMEZONE_PUB", line 687

Steps to Reproduce:

Responsibility: Credit Management Superuser
Navigation: Analysis

  1. Click on the update icon for an existing case folder.

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