Open a Service Request (SR) and ask Oracle Support to retrieve the internal logs. They may be able to provide limited visibility on a case-by-case basis.

I donot think it is possible, but Oracle Support is your best bet You can try creating your own custom PL/SQL function to convert a number to Spanish words (for PEN and other unsupported currencies). Then use this function in your data model SQL. Hope it helps!

Can you try creating two rows in RA_CUSTOMER_PROFILES_INT_ALL Account-Level Profile (Row 1) Field Value Customer Account Source System e.g., FUSION Customer Account Source System Reference e.g., CUST123 Account Site Source System Leave NULL Account Site Source System Reference Leave NULL Profile Class e.g.,…

I donot think it is possible with RTF Template, might be with Excel but you need to ready to try few things: High level steps could be create 3 sheets - let's say SheetA, SheetB, SheetC On each sheet, define the layout you want (headers, columns, etc.) These can be totally different across sheets. Replace 'PARAM_X' with…

You can try following: Create a "Deprecated Datasets" folder Set folder permissions to Admins only Move the custom dataset into this folder. This method also hides the dataset from the UI for most users.

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.