Import Interface Does Not Recognize Date Input
Last updated on DECEMBER 18, 2017
Applies to:Oracle Demantra Demand Management - Version 12 and later
Information in this document applies to any platform.
When you attempt to run an import integration interface with date fields,
the following error occurs.
....[WFProcess_52] ERROR integration.process:
com.demantra.applicationServer.appServerExceptions.ApplicationServerException: java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected NUMBER got DATE
STEPS TO REPRODUCE
1. Log into Workflow Manager.
2. Run the workflow with a transfer step to load data.
3. Data fails to import into demantra internal tables.
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