Hi Gurus,
I have developed a simple custom report to show my problem. When I run the code out of Toad I get results without a problem. When I run it out of Report Builder I get data without a problem.
I have defined the executable, concurrent program, data definition and template. I am able to generate the xml out of Report builder.
However when I run this report out of Oracle it generates no xml data and therefore no output results.
this is the code inside the rdf file...
select
pp.person_id,
pp.EMPLOYEE_NUMBER,
pp.title,
pp. first_name,
pp.middle_names,
pp.last_name,
pp.full_name,
pp.EMAIL_ADDRESS email
from
hr.per_all_people_f pp
where pp.EMPLOYEE_NUMBER = :p_employee_number
and sysdate between pp.EFFECTIVE_START_DATE and pp.EFFECTIVE_END_DATE
and pp.Business_GROUP_ID = 101;
When I run this in Reports Builder I get results but when I run this out of Oracle it returns no results. I have attached the TEST setup screenshots
I am just at a loss as to why this would be.
Any suggestions?
Thanks
Tams