Workflow Is Failed At Transfer Step - ORA-20000: inputs.xx_month field should be filled with values ORA-06512: at "DEMANTRA.BUILD_TEMP_DATES_TABLE", line 493
(Doc ID 2189644.1)
Last updated on AUGUST 16, 2018
Applies to:Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.
On : 12.2.4 version, LoadData
When attempting to load data into demantra internal tables using a custom import integration interface,
the following error occurs.
2016-10-03 10:20:41,363 [WFProcess_320] ERROR integration.process:
com.demantra.applicationServer.appServerExceptions.ApplicationServerException: java.sql.SQLException: ORA-20000: inputs.xx_month field should be filled with values
ORA-06512: at "DEMANTRA.BUILD_TEMP_DATES_TABLE", line 493
ORA-06512: at line 1
The issue can be reproduced at will with the following steps:
1. Log into Business Modeler.
2. Navigate to Tools > Integration Interface.
3. Create a custom integration interface to import price data.
4. Log into Workflow Manager.
5. Create an workflow with transfer step to call the custom integration interface.
6. Run the workflow.
7. It fails.
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|