SQL query to extract UDT table — Cloud Customer Connect
Apr 13, 2023 · Hello, We are trying to create a data model in which we can pull all the data of the UDT into a report. The sql I have been using is the following.
Query for materialized view space and date created?
May 4, 2015 · Is there anyway to query for when a materialized view was created and how much data is in it?
ORA-04063: package body "SYS.DBMS_SNAPSHOT_UTL" has errors
Apr 16, 2013 · Dear Team, while access the users below are the error showing in the alert log.User not able to continue the work and i can't able to create new materialize views ...
How to extract BPM approval flows? — Cloud Customer Connect
Sep 22, 2025 · A customer decided to return to FSM after switching to BPM on Oracle's recommendation, because BPM supposedly offered more options for better management of approval …
What happens to materialized view log when materialize view is on a ...
May 24, 2012 · What happens to materialized view log when materialize view is on a database that was dropped? May 24, 2012 11:40AM edited May 26, 2012 7:54PM 3 comments Answered
Need help to pull Organization ID per Hierarchy Level — Oracle
Dec 3, 2024 · We are looking to pull the Organization ID for each hierarchical level, specifically for Level 1, Level 2, and Level 3.
Oracle Transactional Business Intelligence
Welcome to the Oracle Transactional Business Intelligence Community Forum! Whether you're a seasoned user or just starting your journey with OTBI, the solution for transactional reporting in …
FCCS: how to add The Non-Indexed Attribute to a dense dimension
Jan 23, 2023 · A non-indexed attribute dimension is primarily a metadata construct used for filtering, although it can be materialized in the database during cube refresh in various ways, typically as a …
Do we need to register CPQ as the pricing application in OSS_PRICING ...
Dec 8, 2023 · However, to materialize this integration, would we need to register CPQ as the pricing application with OSS_PRICING_APPLICATION profile option within Fusion? If yes, what should be …