Popular Tags
- OTBI 1,509
- Reporting 1,426
- FDI 1,324
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,023
- BI Publisher 907
- Analysis 699
- Oracle Fusion Analytics 639
- OAC 612
- Administration 568
- Fusion HCM Analytics 463
- Fusion ERP Analytics 460
- Analytics 460
- OBIEE 446
- BI Publisher Data Models 372
- Oracle Analytics Cloud 311
- Security 309
- HCM 297
- Fusion Data Intelligence 295
- Fusion Data Intelligence FDI 279
- BIP 274
- Answers 267
- Analyses 258
- Developers 250
- Data Modelling and Datasets 240
SQL
Discussion List
-
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 165 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 165 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 231 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 155 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 1 view 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 121 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 23 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 11 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 252 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 34 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 203 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 23 views 2 comments 0 points Most recent by Sanender SP Oracle Analytics Publisher Forum
-
Unable to deploy RPD and create datasetRPD deployment and dataset creation are blocked in OAS BI tool. Error for RPD deployment : Replace data model failed. ECID: 04cf824c-702d-44ad-b97d-b8178238624f-0000c412…
-
How to LinkExpense and Advance (Financials Query Report Development)Hi Oracle Community, I’m working on developing a query report in Oracle Cloud Financials and need assistance with linking an expense and an advance. I have an expense an…Kauan_Bohn 61 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum