1 Reply Latest reply: Dec 6, 2012 1:07 AM by AlexAnd RSS

    BI data templates without grouping

    User405774
      Hi,

      I created a data template, it has the following query:

      SELECT DEPTNO,
      DNAME,
      LOC,
      CURSOR(SELECT EMPNO,
      ENAME,
      JOB,
      MGR,
      HIREDATE,
      SAL,
      nvl(COMM,0) COMM
      from EMP ) as EMP
      from dept
      where deptno = nvl(:p_DeptNo,deptno)

      When i run the concurrent program, xml output has tags for deptno, dname, loc, but all the values in the cursor are blanks. SQL does return data, but the xml resulting xml tags doesn't have any data. Something must be wrong with the data template that i created.

      Can someone pls guide me how to build a data template when inline cursors are used in the SQL?

      12.1.3 / 11g

      Thanks,
      K
        • 1. Re: BI data templates without grouping
          AlexAnd
          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?

          >
          SELECT DEPTNO,
          DNAME,
          LOC,
          CURSOR(SELECT EMPNO,
          ENAME,
          JOB,
          MGR,
          HIREDATE,
          SAL,
          nvl(COMM,0) COMM
          from EMP ) as EMP
          from dept
          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
          ...
          from SCOTT.dept
          ....
          because if you run concurrent it run by apps user