My Oracle Support Banner

Unable To Import Opportunity - Stuck in 'Base Table Upload in progress'. (Doc ID 1459666.1)

Last updated on NOVEMBER 03, 2016

Applies to:

Oracle Fusion Opportunity Management - Version and later
Oracle Fusion Opportunity Management Cloud Service - Version and later
Information in this document applies to any platform.



  If you are a Software-as-a-Service (SaaS) customer, there are multiple sections in this document that need not be performed by you. Please log a Service Request in My Oracle Support for Oracle to do this for you.


While trying to import Opportunity, the batch is stuck in 'Base Table upload in progress' status.

Error Message shows:


ODI-1226: Step V_DEFAULT_PROD_GRP fails after 1 attempt(s). ODI-1236: Error while refreshing variable CRM_MOO_IMPORT.V_DEFAULT_PROD_GRP. Caused By: java.lang.Exception: ODI-17511: No value to be set to variable DefDate:null DefN:null DefV:999997826069849 IndStore:L ITxtDefT:null ITxtVar:null SessNo:1838501 VarDatatype:A VarLongValue:null VarName:CRM_MOO_IMPORT.V_DEFAULT_PROD_GRP. at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute( at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute( at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask( at com.sunopsis.dwg.dbobj.SnpSessTaskSqlV.processTask( at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask( at com.sunopsis.dwg.dbobj.SnpSessTaskSqlV.treatTask( at com.sunopsis.dwg.dbobj.SnpSessStep.treatAttachedTasks(



To view full details, 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 a vibrant support community of peers and Oracle experts.