| Re: Schedule Reports
Geetika,
As you are getting public reports through mails, I would suspect hat you have not used the template provided by OTM for report development.
Let me explain:
When you create a report using the standard report template, there is a piece of code in the after report trigger that generates a insert statement into the REPORT_LOG table in your reportowner schema. Once a scheduled report is generated, a REPORT_READY event is triggered inside the application with the job number of the scheduled report. The automated report job ( mentioned above in your email) picks up the job number and goes to the REPORT_LOG table and picks up the report name. It then uses the report server configuration details provided in the glog.properties of the app server and fetches the report file from the report server and sends it out.
Please check the above and advise if this resolves your problem. If not, please post your error and we will advise next steps.
Regards
Prabhakar |