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 MARCH 08, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

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.

ERROR
-----------------------
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



STEPS
-----------------------
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.

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