My Oracle Support Banner

DMW: Transformation Fails with "ORA-01861: literal does not match format string" (Doc ID 2534302.1)

Last updated on JUNE 07, 2021

Applies to:

Oracle Health Sciences Data Management Workbench - Version 2.4.8.1 and later
Information in this document applies to any platform.

Symptoms

DMW 2.4.8.1, a Transformation is failing with the following error message in the log:


ERROR
-------
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin <SCHEMA_NAME>.<PACKAGE_NAME>.<PROCEDURE_NAME>; end;" caught:java.sql.SQLException: ORA-01861: literal does not match format string
ORA-06512: at "<SCHEMA_NAME>.<PACKAGE_NAME>, line 4
ORA-06512: at line 1



STEPS TO REPLICATE
-------------------
1. Log into the DMW User Interface
2. Go to the Study, select Data Model, select Table 
3. Execute the Transformation 
4. Results in the aforementioned error message in the Transformation Log.



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


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