My Oracle Support Banner

Workflow EBS Upload Local Forecast From Demantra To VCP ASCP Errors - java.sql.SQLException: ORA-20015: Exception: msd_dem_upload_forecast.upload_forecast - ORA-00904: (Doc ID 473383.1)

Last updated on JUNE 07, 2021

Applies to:

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


On 7.1.1 Demantra with EBS 11.5.10 in CRP:
When attempting to run the Workflow EBS Upload Local Forecast, the following error occurs in the Collaborator.log:

14:32:03,603 [WFProcess_2] FATAL appserver.workflow.general :: appserver.workflow.general
java.sql.SQLException: ORA-20015: Exception: msd_dem_upload_forecast.upload_forecast - ORA-00904:
"EXP"."LEVEL3": invalid identifier
ORA-06512: at "APPS.MSD_DEM_UPLOAD_FORECAST", line 911
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.receive(
at oracle.jdbc.driver.T4CCallableStatement.doOall8(
at oracle.jdbc.driver.T4CCallableStatement.execute_for_rows(
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(
at oracle.jdbc.driver.OraclePreparedStatement.execute(
at oracle.jdbc.driver.OracleCallableStatement.execute(
at com.demantra.workflow.step.StoredProcedureStep.runStoredProcedure(
at com.demantra.workflow.step.StoredProcedureStep.doExecute(
at com.demantra.workflow.step.LinkedStep.execute(
at com.demantra.workflow.process.WFProcess.mainLoop(

The customer has tried several times deleting the levels and populating them back in the integration profile but to no avail:

1. Get the LEVELs:


---   -----------   ---------
353 424            2
353 425            3

2. Check the value in the column LORDER. Check for the value 3.  It is there.

3. If Yes, then ask the customer to:
A. delete all the levels from the data profile. save. query the table TRANSFER_QUERY_LEVELS again. There should be ZERO records for the data profile.

Deleted levels and ran the query.
No data in transfer_query_levels table.

B. add back the levels again to the data profile. save. query the table TRANSFER_QUERY_LEVELS again. There should be records for the data profile. Also the LORDER column should now be populate correctly with no missing numbers in sequence.

Added levels back.
Data is in transfer_query_levels table, same as in step 1 before deleting.

C. restart the application server, and then try running the export workflow again.

Ran the Workflow and got the same error as before.

The issue can be reproduced at will with the following steps:
1. Run the EBS Upload Local Forecast workflow
2. Note the error message in the Collaborator Workbench and detailed messages in the Collaborator.log


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

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