Hi Community, I am recently seeing that multiple select options in OTBI is not working perfectly and the report jobs are getting failed. Is someone else facing this issue? What is the reason behind this issue and what is the fix?
It is working only once and then it starts failing. Need some suggestions
Anand,
What is the issue! What is the error message? What is the sql you issue to get that error message? (cut paste since most people for security must not read attachments by strangers on the internet)
Assume this is a publisher report in OTBI (yellow) not an analysis in OTBI (blue). You said report jobs so does it fail if you run without schedule? Does it fail if you run data model without report? In the data model is your data set type sql with i) data source 1 of 3 application database or ii) logial query from subject areas data source biee? The syntax for multiple select is different as each is a different version syntax of SQL.
Hi,
The report is running successfully but only once in 10
times. Rest times it is failing with Error:
SQL query time exceeds the limit (600 sec). Stopped processing.
[INSTANCE_ID=bip.bi_server1]
Note: This error is coming when I am scheduling the Report and the successful run is giving the report within 2 minutes
Please find the below screenshot where out of 7 schedules only one ran successfully(Parameters is same for all these runs)
Description: The Oracle Fusion Data Intelligence (FDI) Product Roadmap Update provides an overview of the latest developments and future plans for FDI. Oracle Product Management experts will share upcoming capabilities, key enhancements, and product direction, helping attendees understand what is changing and how these…
We have a Talent Community Pool configured with Organization and Job Family criteria. Some candidates were added to the pool, but we are unable to determine which specific criterion they matched. Is there a report, analysis subject area, audit history, or backend table that shows the attribute values that resulted in a…
Hi, We are looking for PVOs for below tables in BICC Can you guide us on the approach to extract data for these? PON_AGREEMENT_LINES_ALL PON_AGREEMENTS_ALL PON_APPROVAL_HISTORY PON_CONTRACT_PARTIES PON_PRICING_TERMS PON_TERMS_AND_CLAUSES Thanks, Nitin
Hi All, We are using Oracle Fusion Cloud Procurement and would like to secure the Purchase Order (PO) PDF that is generated from Oracle Fusion. Our requirement is to have the generated PO PDF password-protected, so that the recipient must enter a password before the PDF can be opened. Can someone please advise? We are…
Does Fusion release supports propagating an HTTP XML Feed authentication exception into the BIP-based ESS job’s completion text.
