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…

No experience with Snowflake but see if below works for you: Add an 'All' option with a null or special value, like '@ALL @' . Display Value Return Value All @ALL @ WHERE (:PARAMETER_NAME = '@ALL @' OR FIELD IN (:PARAMETER_NAME)) This makes it explicit: when @ALL @ is selected , skip filtering. I think this pattern is…

You can start with following query SELECT dept.ORGANIZATION_NAME AS DEPARTMENT_NAME, bu.BUSINESS_UNIT_NAME, le.NAME AS LEGAL_ENTITY_NAME, le.LEGAL_ENTITY_IDENTIFIER FROM HR_ORGANIZATION_UNITS dept JOIN PER_BUSINESS_UNIT_ORGS buo ON dept.ORGANIZATION_ID = buo.ORGANIZATION_ID JOIN FUN_BUSINESS_UNITS bu ON bu.BU_ID =…

It is a good question. For quick turnaround, consider taking help from Oracle Support by logging a SR.

It is tricky but see if you can make it work by using Payables subject areas like: Payables Invoices – Transactions Real Time Payables Payments – Transactions Real Time Procurement – Spend From these subject areas, you can get: Supplier Name Invoice Amounts (debited from AP) Payments GL distribution details (via invoice…

Please confirm if this question still needs answer otherwise consider closing it as Accepted Answer. Thanks