I donot think Oracle Support is monitoring these Forums. If you need immediate attention, try to call them or escalate based on the client needs. Anyways, as a second option if your reporting needs include reusable filters or data sets, you might consider building: BI Publisher data models with custom logic OTBI analyses…

Are you open to custom BI Report for Forecasting View If you need to show a "forecast-adjusted" report without altering billing: Use OTBI or BI Publisher to create a custom report Pull forecast data independently from contract billing data

If you're limited in what the CAA subject area exposes and open to BIP Model: Create a BI Publisher Data Model that joins: AP_INVOICES_ALL AP_INVOICE_PAYMENTS_ALL AP_PAYMENT_SCHEDULES_ALL AP_CHECKS_ALL XLA_AE_HEADERS and XLA_AE_LINES (for journal info) From here, you can build a report that: Pulls invoice journal entries…

Excellent, thanks for sharing.

Please check with Oracle Support by logging a SR, Oracle team have more knowledge base and might have seen this with other Users. Otherwise, log an Idea in Idea Lab. Hope it helps!

I think it is known limitation with runcat. You might need to dump everything to XML and use python to extract, again not sure. Best of luck!

appreciate any updates…

Direct DB access is not allowed from cloud. You can create reports in BI Publisher that query transactional data. You can schedule these reports to generate extracts (CSV/XML) and push them to external systems (e.g., via FTP/SFTP, UCM, REST APIs). OTM Cloud provides REST APIs to query transactional data (e.g., shipments,…

Thanks @Vismay Barot . please close the post as Accepted answer.

I think Oracle currently does not support conditional expand/collapse controls on specific nodes within a hierarchical column. Log an Idea in Idea Lab or take help from Oracle Support.

Cannot access the SR, appreciate if you can keep us updated here. It will help for other OAC users.

It is going to be a task for you, try using OAC REST API or OCI logging for more advanced monitoring and email alerts.

You need to be a SQL expert , may be use a custom SQL query that joins the transaction table to itself, something like SELECT …. FROM transactions t1 JOIN transactions t2 ON t1.Indv_Value = t2.Indv_Value AND t2.Tran_Date > t1.Tran_Date AND t2.Tran_Date <= t1.Tran_Date + INTERVAL '2' DAY WHERE t1.Authorization_IND =…

Typically, OAS releases trail major OAC updates by 6–12 months, and only include features that are cloud-independent. Keep an eye on blog updates or webinars from Oracle Analytics product management or leadership

Please share your approach we also need it.

It is tricky , you might need to work with ORacle Support. Also, Instead of using the plain P0/P1/P2/P3 format (Go URL filters), you should pass the filter as a presentation variable, which can be referenced directly inside the analysis including conditional formats.

Can you create a derived column in In your data model / dataset, Example: CASE WHEN TRUNC("Your_Date_Column") = TRUNC(CURRENT_DATE) THEN 'Y' ELSE 'N' END AS Is_Today Now add this column to your canvas. Create a hidden filter Is_Today = 'Y' on to limit data to today’s date. Leave the List Filter for date visible, users can…

Did not get the question… What is the issue here?

Not sure if it will work for you but try by making your canvas dimensions match this aspect ratio as closely as possible. try setting canvas width = 816px and height = 1056px for US Letter. If you want landscape orientation, flip the values (width = 1056px, height = 816px).

Can you try this SQL in BIP (if available in your data model): SELECT ul.USER_NAME, ul.EMAIL_ADDRESS, ul.START_DATE, lh.LOGIN_DATE, lh.LOGOUT_DATE, lh.SESSION_ID, lh.CLIENT_HOST_NAME, lh.CLIENT_IP_ADDRESS, lh.LOGIN_TYPE -- e.g., UI, WebService FROM FND_USER ul JOIN FND_LOGIN_HISTORY lh ON ul.USER_ID = lh.USER_ID WHERE…