Popular Tags
- OTBI 1,492
- Reporting 1,414
- FDI 1,255
- Fusion AI Data Platform 1,047
- Analysis and Data Visualization 1,015
- BI Publisher 888
- Analysis 696
- Oracle Fusion Analytics 626
- OAC 570
- Administration 561
- OBIEE 443
- Fusion HCM Analytics 440
- Analytics 437
- Fusion ERP Analytics 433
- BI Publisher Data Models 366
- Security 311
- HCM 294
- Oracle Analytics Cloud 272
- BIP 272
- Answers 267
- Analyses 257
- Developers 249
- Fusion Data Intelligence 242
- Data Modelling and Datasets 237
- ERP Analytics Content 221
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
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 136 views 4 comments 0 points Most recent by mgoswami Oracle Fusion Data Intelligence Forum -
3Improving 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 63 views 5 comments 3 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab -
Email Update and Add EmailHi Expert, Looking an HDL where we can add and update the work email through HDL. Thank you!jsmithA 42 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 37 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 25 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 19 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 239 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 32 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 134 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 17 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 46 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum -
how to Linking Expense 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 27 views 2 comments 0 points Most recent by Kauan_Bohn Oracle Fusion Data Intelligence Forum