Exception In FRT Processing And File Entry Reversal In Header Table (Doc ID 2957721.1)

Last updated on DECEMBER 18, 2023

Applies to:

Goal

The goal of this article is to provide a resolution to the following error encountered during FRT batch execution:

TIMESTAMP),?) at time zone 'Greenwich' as TIMESTAMP) AS STD_TIME from DUAL /* com.splwg.base.support.sql.OracleFunctionReplacer */ with 'FixedCHAR' parameter named 'baseTZ' to : 'Europe/Paris' to indices: 1 Caused by SQLDataException: ORA-01878: specified field not found in datetime or intervalCaused by OracleDatabaseException: ORA-01878: specified field not found in datetime or interval Event was logged with key: 8537746511478847183.

Error - FileTransformWorker - A Java exception was thrown: LoggedException: The following stacked messages were reported as the LoggedException was rethrown: com.splwg.base.support.interception.SessionInterceptionManager$JumpToFWRunner.call(SessionInterceptionManager.java:349): Unable to execute callable com.splwg.base.support.interception.SessionInterceptionManager$JumpToFWRunner@7bcbd032 The root LoggedException was: Error executing iterate for rawSQL: select cast(from_tz(CAST(sysdate AS TIMESTAMP),?) at time zone 'Greenwich' as TIMESTAMP) AS STD_TIME from DUAL /* com.splwg.base.support.sql.OracleFunctionReplacer */ with 'FixedCHAR' parameter named 'baseTZ' to : 'Europe/Paris' to indices: 1 Caused by SQLDataException: ORA-01878: specified field not found in datetime or intervalCaused by OracleDatabaseException: ORA-01878: specified field not found in datetime or interval Event was logged with key: 5994684270055836769.

The entry in the transaction header table should have been reverted (?) since the file was not at all uploaded. Not even a single record. The file entry in the header table in UPLD

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.