Error While Refreshing Variable E1TOAPSPROJECT.PVV_MFG_USER_ID (Doc ID 2176196.1)

Last updated on AUGUST 25, 2016

Applies to:

Oracle Value Chain Planning Integration Base Pack - Version 11.1 and later
Information in this document applies to any platform.

Symptoms

You are getting the below error while running the Collect Planning Data concurrent program.
Through investigation you found the code that is failing is:
select user_id from apps.fnd_user where user_name LIKE 'MFG';
There is no value returned for this query when you are running this in VCP APPS schema.


ERROR
ODI Scenario : LOADE1ATPRULESDATATOAPSPKG FAILED. Session #: 858027
02-AUG 06:44:55 : Error Message: ODI-1226: Step PVV_MFG_USER_ID fails after 1 attempt(s).
ODI-1236: Error while refreshing variable E1TOAPSPROJECT.PVV_MFG_USER_ID.
Caused By: java.lang.Exception: ODI-17511: No value to be set to variable 'E1TOAPSPROJECT.PVV_MFG_USER_ID'.
at oracle.odi.runtime.agent.execution.sql.RefreshVariableExecutor.execute(RefreshVariableExecutor.java:70)
at oracle.odi.runtime.agent.execution.sql.SQLExecutor.execute(SQLExecutor.java:1)
at oracle.odi.runtime.agent.execution.TaskExecutionHandler.handleTask(TaskExecutionHandler.java:50)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlV.processTask(SnpSessTaskSqlV.java:410)
at com.sunopsis.dwg.dbobj.SnpSessTaskSql.treatTask(SnpSessTaskSql.java:2625)
at com.sunopsis.dwg.dbobj.SnpSessTaskSqlV.treatTask(SnpSessTaskSqlV.java:240)
at com.sunopsis.dwg.dbobj.SnpS


STEPS TO REPRODUCE
1. Log in to Advanced Supply Chain Planner resp
2. NAV: Collection -> JD Edwards EnterpriseOne -> Collect Planning Data
3. Launch the concurrent request.


BUSINESS IMPACT
Due to this issue, users cannot collect the data from JDE to VCP

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