This content has been marked as final. Show 1 reply
right forum - Re: BI data templates without grouping
because it's ebs related question
When i run the concurrent program, xml output has tags for deptno, dname, loc, but all the values in the cursor are blanks.
how did you check it?
if query in data template so it's sqlStatement section. do you have dataStructure section in datatemplate?
from EMP ) as EMP
where deptno = nvl(:p_DeptNo,deptno)
above query return any data for your parameter? and by which user? if it test schema SCOTT then you need to use
because if you run concurrent it run by apps user
... from SCOTT.dept ....