Error Creating Instance and Audit Trail not visible, 'ORA-01830' (Doc ID 1954842.1)

Last updated on DECEMBER 17, 2014

Applies to:

Oracle SOA Suite - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

Unable to see composite audit trail after applying Patch 14406487 - SOA BUNDLE PATCH 11.1.1.6.4

The problem is accompanied by the following database error:

java.sql.SQLDataException: ORA-01830: date format picture ends before converting entire input string



Cause

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