DMW: Transformation Fails with "ORA-01861: literal does not match format string"
(Doc ID 2534302.1)
Last updated on DECEMBER 15, 2024
Applies to:
Oracle Life Sciences Data Management Workbench - Version 2.4.8.1 and laterInformation 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 |