Popular Tags
- OTBI 1,450
- Reporting 1,395
- FDI 1,129
- Analysis and Data Visualization 988
- BI Publisher 858
- Analysis 682
- Oracle Fusion Analytics 593
- Administration 555
- OAC 467
- OBIEE 433
- Analytics 404
- BI Publisher Data Models 358
- Security 295
- HCM 270
- BIP 265
- Answers 264
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Data Connectivity 210
- ERP Analytics Content 210
- BI Publisher Report Templates 205
- Oracle Analytics Cloud 202
- Fusion Data Intelligence 193
- Report Output 184
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
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 ERP Analytics -
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)…
-
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 …User_DARJB 64 views 3 comments 0 points Most recent by Sushant Mishra Oracle Analytics Cloud and Server
-
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 208 views 2 comments 0 points Most recent by Kaustubh Deshmukh Oracle Transactional Business Intelligence
-
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…
-
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…
-
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…
-
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…User_5F97D 20 views 1 comment 0 points Most recent by GayathriAnand-Oracle Oracle Analytics Cloud and Server
-
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 36 views 2 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence -
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…
-
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 26 views 1 comment 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
Query to identify Work Orders WHERE Work Centre IS NULLIs it possible to create an analysis in OTBI to retrieve work orders that are not associated to any work centre? Our organisation has multiple departments (work centres)…POD AH 52 views 6 comments 0 points Most recent by POD AH Oracle Transactional Business Intelligence
-
1Data Models: Restrict/enable access to certain data tablesWe want our CMMS analyst team to have access to (and build) data models specifically for the Maintenance area. However, due to current system limitations, we are unable …POD AH 5 views 1 comment 1 point Most recent by ShankarS-Oracle Oracle Transactional Business Intelligence Idea Lab
-
Query to get Change Order TasksHi. I am looking for Query to get Change Order Tasks from SCM Oracle fusion tables. Attaching Screenshot -
Sickness Absence End Date not updated in ANC_PER_ABS_TYPE_ENTRIES tableWe initially have had an existing approved Sickness Absence for an employee with duration - Start Date - 01/06/2025 End Date - 28/06/2025 Then we have modified the End D…Raktim_Pal-IBM 23 views 2 comments 0 points Most recent by Raktim_Pal-IBM Oracle Analytics Publisher -
ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?Summary: Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID column…Scott McAnally 2.4K views 5 comments 1 point Most recent by Vermaee Oracle Transactional Business Intelligence