Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Report builder generates data but report in Oracle R12 does not

ChezAug 22 2020 — edited Feb 9 2021

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

Comments
Post Details
Added on Aug 22 2020
1 comment
243 views