Popular Tags
- OTBI 1,482
- Reporting 1,408
- FDI 1,216
- Fusion AI Data Platform 1,043
- Analysis and Data Visualization 1,011
- BI Publisher 879
- Analysis 691
- Oracle Fusion Analytics 618
- Administration 556
- OAC 548
- OBIEE 437
- Fusion HCM Analytics 428
- Analytics 427
- Fusion ERP Analytics 413
- BI Publisher Data Models 362
- Security 303
- HCM 287
- BIP 268
- Answers 266
- Analyses 256
- Oracle Analytics Cloud 255
- Developers 248
- Data Modelling and Datasets 235
- Fusion Data Intelligence 219
- ERP Analytics Content 217
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
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 37 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 7 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 2 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 21 views 2 comments 1 point Most recent by RVohra Oracle Fusion AI Data Platform 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 AI Data Platform 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?https://us.v-cdn.net/6037859/uploads/RDOAXLD86HZH/sql-query-cc.txt I've built a BIP report and made it available to managers as a link (static URL page entry in My Team)…Shounese A 12 views 1 comment 0 points Most recent by MandeepGupta Oracle Fusion AI Data Platform 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 235 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 101 views 2 comments 0 points Most recent by MandeepGupta Oracle Fusion AI Data Platform 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 11 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 42 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 22 views 2 comments 0 points Most recent by Kauan_Bohn Oracle Fusion AI Data Platform Forum
-
OTBI column formula assistance - Change 5 days to 5 working daysI am trying to amending the below column formula to count 5 working days instead of 5 days (which it is at the moment)? I need to exclude Saturdays and Sundays. Can anyo…Tracy Goodchild 22 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum