Popular Tags
- OTBI 1,514
- Reporting 1,429
- FDI 1,352
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,025
- BI Publisher 910
- Analysis 700
- Oracle Fusion Analytics 645
- OAC 634
- Administration 569
- Fusion HCM Analytics 481
- Fusion ERP Analytics 473
- Analytics 469
- OBIEE 446
- BI Publisher Data Models 372
- Fusion Data Intelligence 320
- Oracle Analytics Cloud 318
- Security 314
- Fusion Data Intelligence FDI 310
- HCM 301
- BIP 277
- Answers 267
- Analyses 258
- Developers 251
- Data Modelling and Datasets 242
SQL
Discussion List
-
1SQL Passthrough (?) option for manual query datasetsI'm not very technical so if this is a non-starter or there's a solid workaround that already exists, please advise. We have users that query SQL data sources directly i…JeffK 94 views 4 comments 1 point Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics Idea Lab -
New Tutorial: How to Connect an AI Agent to an OAC MCP Server in Oracle AI Data PlatformIn this tutorial you’ll learn how to connect an AI agent to an Oracle Analytics Cloud (OAC) MCP server in Oracle AI Data Platform. This connection enables an agent to us… -
What are the different ways to access the Oracle ADW database without having the relevant User nameIs there a way to access the Oracle AADW database without being assigned the FAW Service Administrator role, using only a native database username and password with read…User_7AIAG 196 views 2 comments 0 points Most recent by RVohra Oracle Fusion Data Intelligence Forum
-
5Improving SQL Developer Productivity in Oracle Fusion HCMProblem Statement: Oracle Fusion HCM SQL Developer Experience Currently, developing and validating SQL queries for Oracle Fusion HCM is a highly fragmented and time‑cons…Chakresh Nayak 251 views 7 comments 5 points Most recent by M Vijayalakshmi Oracle Transactional Business Intelligence Idea Lab
-
FDI 26ai ADW: GRANT SELECT ON SCHEMA OAX$DW to a custom database user?Is it possible to grant select any table on schema OAX$DW to a custom database user within a 26ai ADW? If so, please clarify any pre-requisite steps such as ADMIN or OAX…Angel Torres-Vargas 298 views 4 comments 0 points Most recent by mgoswami Oracle Fusion Data Intelligence Forum -
Email Update and Add EmailHi Expert, Looking an HDL where we can add and update the work email through HDL. Thank you!jsmithA 208 views 4 comments 0 points Most recent by RVohra Oracle Transactional Business Intelligence Forum
-
Whenever I try and reference a where clause key flexfield it inserts null into my sql scriptHello, Version: Oracle Analytics Public 12.2.6.4.0 I have a simple query that like the following: SELECT TOWN, STRNUM, STRNAME FROM CUST.ADDRESS WHERE STRNUM > 100 I als…
-
Formula Expression values are processed differently when selecting different system language NL-ENGCurrently, our report transforms column A to Column B by using a Case - when - then setup. For example, Case when column A = 'Value_1' then 'Value X' when Column A = 'Va…Sant 4 views 0 comments 0 points Most recent by Sant Oracle Transactional Business Intelligence Forum
-
extract substring into new column FDIHi! I have this FDI subject area and was trying different types of SQL functions with not much success. Can you please help with this issue? I would like to extract from…Raluca Balan-Oracle 129 views 2 comments 1 point Most recent by RVohra Oracle Fusion Data Intelligence Forum
-
Delete record from Custom TableHi All, we are using a custom table "MKT_REF_ENTITIES" to store data as a part of journal import and we have came across a occurrence where we need to delete few records…Chetan007 27 views 2 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Oracle Fusion Data Intelligence Forum
-
BIP Report DynamicallyHi We have a BIP report with daily frequency, and we need to pass the schedule start time to the data model SQL input parameter#p_from_date to fetch the incremental valu… -
How can I ensure my BIP report for line managers only returns results of their reporting line?I've built a BIP report and made it available to managers as a link (static URL page entry in My Team) and it works perfectly except it returns results for all employees…Shounese A 12 views 1 comment 0 points Most recent by MandeepGupta Oracle Fusion Data Intelligence Forum
-
Registration URLCode and registrationAccessCodeWe are implementing Supplier Registration.We need required tables to get this information for Registration URLCode and registrationAccessCode dynamicallly based on user …
-
RTF Template: Background Image Only Appears in PDF Output, Missing in Other FormatsHi everyone, I'm creating an RTF template in Oracle BI Publisher to generate a certificate-style report. The goal is to display a background image (a certificate design)…
-
Finding Duplicate valuesHi all… Apologies in advance if this question is entered into the wrong forum. If so, please let me know where it would be best to ask this question. I am attempting to …
-
Time Card StatusHi everyone, I am trying to create a BIP report for Time Card Change History which includes both "Time Entry" and "Time Card Status". For Time Card Status, I am trying t…Candy Miles Domingo 262 views 2 comments 0 points Most recent by Kaustubh Deshmukh Oracle Transactional Business Intelligence Forum
-
How do I change YTD to FYTD in a measure column?In the General Ledger Transactional Balances Real Time, there are measures for "Entered YTD CR" and "Entered YTD DR". This gives totals for the calendar year. How do I u…L G 31 views 2 comments 0 points Most recent by L G Oracle Transactional Business Intelligence Forum
-
Difference in Grand Total Calculation between OBIEE and OAS with COUNT DISTINCTWe recently migrated from OBIEE to OAS using the same RPD, but we noticed a difference — which does not occur every time we run the reports — in the Grand Total values o…
-
SQL to get individual compensation plan items to show under Additional compensationI want fetch Additional Compensation details for Individual Compensation plan through SQL. below is the screen I want to query. Person will have multiple plan and option…Raghavendra M 264 views 2 comments 0 points Most recent by MandeepGupta Oracle Fusion Data Intelligence Forum
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…Sanender SP 22 views 2 comments 0 points Most recent by Sanender SP Oracle Analytics Publisher Forum