msd_dem_upload_forecast.upload_forecast - Unable to get export data profile id when starting EBS Upload Local Fcst, Demand Class workflow ORA-20003 ORA-06512 (Doc ID 752091.1)

Last updated on JANUARY 12, 2016

Applies to:

Oracle Demantra Demand Management - Version 7.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 29-Nov-2010***


Symptoms

When attempting to start 'EBS Upload Local Fcst, Demand Class' workflow
the following error occurs:

ERROR
"java.sql.SQLException: ORA-20015: Exception: msd_dem_upload_forecast.upload_fore
cast - ORA-20003: Error: msd_dem_upload_forecast.upload_forecast - Unable to get
export data profile id
ORA-06512: at "APPS.MSD_DEM_UPLOAD_FORECAST", line 1207
ORA-06512: at line 1

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java
:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.
java:215)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableSta
tement.java:954)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePrep
aredStatement.java:3316)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStat
ement.java:3422)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStat
ement.java:4394)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(Delegatin
gPreparedStatement.java:169)
at com.demantra.workflow.step.StoredProcedureStep.runStoredProcedure(Sto
redProcedureStep.java:167)
at com.demantra.workflow.step.StoredProcedureStep.doExecute(StoredProced
ureStep.java:108)
at com.demantra.workflow.step.LinkedStep.execute(LinkedStep.java:464)
at com.demantra.workflow.process.WFProcess.mainLoop(WFProcess.java:455)
at com.demantra.workflow.process.WFProcess.run(WFProcess.java:261)
at java.lang.Thread.run(Thread.java:534)
"

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