This content has been marked as final. Show 10 replies
You can generate a scenario for your interface and invoke that from a loadplan. Loadplan cannot invoke packages or interfaces directly.
My requirement is to execute Scenerio of Interface through Load Plan not the Package (Scenerio).
Currently I am having the following situation..
One Variable for the C$ tables, called #GLOBAL.G_C, with a refresh statement such as:
select 'C'||substr('<%=snpRef.getSession("SESS_NO")%>,1,9) from dual
Another Variable for the I$ tables, called #GLOBAL.G_I, with a refresh statement such as:
select 'I'||substr('<%=snpRef.getSession("SESS_NO")%>,1,9) from dual
In Topology Manager, Physical Schema - In the Definition tab, replaced the existing values set for the temporary table prefixes with the name of the Global Variables, for example : #GLOBAL.G_C, #GLOBAL.G_I.
These Global Variable values are refreshed before using them in the Integration Interface to get a control of Session Numbers( Same Package or Load Plan can be executed with different session numbers).
My requirement is to execute Load Plan with Interface( with refresh options) not with Package.
The run scenario step of loadplan has option to refresh variable before invoking the scenario and pass its value as input parameter to the scenario.
Doesn't that serve your purpose?
I already tried, Global Variables are not getting refreshed. I am trying to create a package to call LoadPlans, Now I have issue in giving LoadPlan Name in ODIStartLoadPlan Parameters. Load Plan Name is not getting saved in the Parameter.
Can anybody help me in refreshing the Global Variables from LOADPLAN
Can you confirm that the variable is declared as startup variable for your scenario? Loadplan copies the variables and the refresh variable basically refreshes the loadplan copy of the variable and then passes to the scenario as the startup parameter. Thats why you wont see the refreshed value in the variable history if you have historized it.
Thanks for the response
I am not using any variables to the interface Scenerio. LoadPlan has Variables(Global) which needs tobe refreshed. I need to get session no for each step of LoadPlan.
substitution api getSession() returns session information about current session. So setting current session value through variable refresh would not work because load plan executions are independent of session executions.
Is there any way to execute LoadPlan at each session, if so can you please give me a solution
I could not get the question. You want to invoke loadplan from each session? There is a oditool available to invoke a startLoadplan just like you can invoke scenario.
I would also suggest to create a separate post if you have more questions that are different then the original question.