Error Opening UWQ - IN ON_ERROR trigger - FRM-41843: Invalid time zone region for ADJUST_TZ

(Doc ID 1993846.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Advanced Collections - Version 12.1.3 and later
Information in this document applies to any platform.


After application of <patch 19048616>- 'IEX R12.1: IEX RPC, AUGUST 2014', when attempting to open Collector's Work Queue,
the following error occurs:

First the Note:
IN ON_ERROR trigger

Then the error:
FRM-41843: Invalid time zone region ? for ADJUST_TZ

The issue can be reproduced at will with the following steps:
1. In Collections Agent, click on the Collector's Work Queue
2. The above mentioned errors show up. 

Note: The error can come up after application of any other patch too and not limited to the one mentioned above.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms