For partners that build or integrate commercially available applications and service solutions with the Oracle Cloud Platform
For partners that provide implementation or managed services around Oracle Cloud Applications
Anyone have an xml they would be willing to share or recommendations for creating a 'master' report that returns a list of all the BI reports in order to audit and clean up what has been created over the last couple of years. A few primary details I am needing to include are the report name, location of report, and if it is scheduled - who the recipients are (if possible) and last date report was run (again, if possible). Thank you in advance for any assistance/advice you are able to provide.
Hello,
For a personal BIP report schedule, if the attachment has no data on it, is there a way to call that out in the body of the email message to the user? We find that users are opening reports that have no data unnecessarily. Some days the report will have data, sometimes it might not and that could be valid. If there is a way to show the user that they don't need to open the attachment because it doesn't contain data, that would be great. Any thoughts?
Thanks,
Stephanie
New features has been added to BICCC Application as part of 19A patch, it is very good, but it will be helpful if we get some document from Oracle explaining the new features within BICCC for every major releases in Advance, Now I am looking for 19A patch new features list for BICCC. let me know if any of you have come across such documentation for BICCC.
Hello All,
I have a request to export the result output of an OTBI report to an SFTP server on a daily basis. Unfortunately the delivery Agent for scheduling OTBI reports does not have the FTP as a Destination option. Has anyone some Ideas on how I can go about this? your contributions are highly appreciated.
Regards
Kingsley
Hello,
I'm currently building an HCM Report where it looks at the Timestamp of the change (Hire/Term/etc.) and subtract 1 minute from that timestamp. Then I was hoping to run an agent every minute to pick up any changes in the last minute. I am trying to use the below filter, but when I run the report the CURRENT_TIMESTAMP does not update every time the report/agent runs. When I run the report normally it has the Timestamp of the last time I edited the report, but if I refresh on the bottom of the report it will pull the current timestamp. Below is the filter I'm trying to use and the HCM Post I created, I've also attached the related XML.
Does anyone have any advice on how to make the current_timestamp update every time the report is run or scheduled to run?
Filter
"Assignment Event Details"."Assignment Creation Date" > TIMESTAMPADD(SQL_TSI_MINUTE, -1, CURRENT_TIMESTAMP)
HCM Report Post
Hi All,
I am looking for ways to monitor the performance of OTBI Reports in fussion cloud environment. We have BIP and OTBI reports that are running poorly and I wish to find out how I can do that. Admin session mager provides the cursor cache where I can see the OTBI report run-time, logs and path but this information is only held for a very short time in the production environment.
Has anyone an idea on how i can get this information for a time period of over a month?
- Report name with path
- Runtime
- Execution time and date
Thanks
Kingsley
We have built some Custom Reports in BI Publisher that extract data to a CSV file using a simple SQL script.
This is scheduled running every hour and automatically transmits the file to a vendor's SFTP Server.
However, I'm wondering if its possible to call these jobs from the Enterprise Scheduler (ESS) so that we can maintain it from there?
Is this possible? I don't see any option for ESS jobs to transmit reports to a external SFTP server.
Please advise.
I have created an analysis on employees that works very well for HR reporting.
Due to the fact that I combine multiple subject areas I have entered several measures as well that are not necessary for the final (exported) output. I usually exclude the columns I don't need in the view edit and it works perfect for xls, pdf, exports.
Whenever I run a CSV- export with the same data however I get the whole set of infomation exported, including all columns that I had excluded. How can I reduce my CSV-export to the same amount of information as it is in the other exports?
I guess it is a really easy step, but I couldn't find the right trigger so far.
Thanks for all information in advance.
BR
Stefan
Hello,
Any ideas on how to protect reports that are scheduled?
Thanks!
Hello - I'm hoping someone can help me with this please.
I have an OTBI analysis that I want to schedule on the first of each month that will show changes in the previous month. One of the 'changes' could be that the record has been ended but because the because the subject area is a Real Time one (Payroll - Element Entries Real Time) the record is no longer current when the report is being run so it will not report the change.
Therefore, I am wondering if I could include the SQL expression below (to get to the 1st of the previous month) in the prefix to set the effective date to be the 'first of the previous month'.
TIMESTAMPADD(SQL_TSI_MONTH, -1, TIMESTAMPADD(SQL_TSI_DAY, DAYOFMONTH(CURRENT_DATE) * -(1) + 1, CURRENT_DATE))
I hope that makes sense and if someone can help me do this I'd be very grateful. I tried several different ways to add this to the Prefix with no success so I think it might be a syntax issue, or maybe it's just not possible to do this?
Many thanks
Linda