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
Liked it
Thanks.. I don't think so they will provide anything? better create an Idea (Bug) for this as well. Please share if you get solution from Oracle or in any other channel?
Thanks,
-Sudha
Thanks for update.
Try to schedule the report in BIP and go to output tab and change the name before submit so that you can restrict suffix.
change the name before submit will reflect the current run file name so it will not affect on your template name
Hi Stephen,
I think the "Receivables Aging by General Ledger Account Report" failed might be due to timeout error. since SQL Query Timeout value is 30min by default.
Try to pass more parameters as much you can and see the out come. still failing then you need to customize the report to increase the value.
Check if you can override the SQL Query Time out property at Data Model level.
Please check "SQL Query Timeout" section in document -
https://www.oracle.com/technetwork/middleware/bi-publisher/bip-memoryguardproperties-5035822.pdf
Thanks,
-Sudha.
Hello,
Case 1) You do not want to display the template name suffix to report then you can schedule the report through ESS Job then you can see only Report name comes as file name.
ex:- Report Name is "Test_Report" then your output file should be "Test_Report.xlsx" (if xlsx format) etc...
Case 2) If you want to run ad-hoc request like online then put the Template name as "Output" so that the output would be "Test_Report_Output.xlsx" which make sense to see the file name.
Hope this helps you
Thanks,
-Sudha
what is the error you are getting?
Please share your query so that we can try to help you
Use this table ask_deployed_domains
This feature is possible for Email or FTP but not for normal output in BI Publisher
You can create simple custom BIP Report
Hi Simon,
Thanks for update here. The idea has been created by myself only so can you please help to like(vote) for it so that it will be in priority list. Oracle Product team will pick the idea's to fix based on the votes and most of the customers who got impacted?
So please help with your groups to get vote.
Thanks,
-Sudha
I think No other options available so you have to re-schedule them...
In RTF Template you can use below scenario
<?for-each-group:ROW;./due_date?> --- <?end for-each?>
https://community.oracle.com/thread/4134146
Can you please share the SQL query?
Try Decode then XML TAG
<?xdofx:DECODE(PAY_TERMS, '1', 'One', '2', 'Two')?>
like this