Have you ever found yourself trying to deal with this scenario?
Consider the situation where you have to run certain report, which is keyed by the Business Unit and Company. Once the report is run using a job using a batch user id, the report should go to the CEO of the Company and Business Unit combination.
The above requirement can be achieved as below through an XML Publisher report.
Great and concise how-to guide for a very common requirement by Anoop Savio over at The Oracle PeopleSoft Blog. Read the post here.