Popular Tags
- OTBI 1,417
- Reporting 1,378
- FDI 1,016
- Analysis and Data Visualization 971
- BI Publisher 834
- Analysis 669
- Oracle Fusion Analytics 566
- Administration 555
- OBIEE 427
- OAC 378
- Analytics 367
- BI Publisher Data Models 343
- Security 286
- Answers 264
- Analyses 253
- HCM 248
- Developers 241
- BIP 239
- Data Modelling and Datasets 221
- Data Connectivity 206
- ERP Analytics Content 200
- BI Publisher Report Templates 192
- Report Output 182
- Customizing Reports 154
- Agents 151
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
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 25 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 21 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 38 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 9 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
-
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 …
-
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 20 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.2K views 5 comments 1 point Most recent by Vermaee Oracle Transactional Business Intelligence
-
Issue with multi-select filter in reportI'm developing a report and encountered a problem when trying to select items in a filter. In its current configuration, I can extract either ONE specific item or ALL it…Kauan_Bohn 36 views 6 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence
-
How do I modify an IKM in ODI 12c to prevent duplicates in a target table?Hi everyone, I was practicing ODI 12c and I came across this problem: I have a mapping in ODI 12c that inserts the data from a staging table into a staging history table…Ngoc Phung 15 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Cloud and Server
-
I see a table in ALL_TAB_COLUMNS, but when I try to query to table it says it doesn't exist.So I was looking for a table and I could see it in the ALL_TAB_COLUMNS using this query: SELECT DISTINCT TABLE_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'ase_app_role…drudd 25 views 4 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence
-
I see a table in ALL_TAB_COLUMNS, but when I try to query to table it says it doesn't exist.So I was looking for a table and I could see it in the ALL_TAB_COLUMNS using this query: SELECT DISTINCT TABLE_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'ase_app_role…
-
SQL query to get SO DetailsCan someone please provide SQL query to get SO, Customer, ship_to, bill_to, delivery_id, invoice_number, payment_terms and other detailsDinesh K89 12 views 2 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
BIP Report to Extract Resource Actuals and Budget and expenseExperts, I have requirement to develop a BIP report to extract resource actuals, Budgets and expense. I was able to develop another report to extract this info based on …
-
BIP Report fails with Maximum Limit Exceeded even after applying all filtersBIP Report fails with Maximum Limit Exceeded even after applying all filters Content (please ensure you mask any confidential information): Hi Team, Greetings! We are ge…Parag Hiremath 57 views 3 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence
-
What is the minimum information necessary to update contractsSummary: Trying to create a data model and report to fix contracts that are missing PERIOD_OF_SERVICE_ID.I can run an SQL query on any of the tables, filter by PER_CONTR…
-
Performance Issue After Joining EGO_ITEM_EFF_B on the basis of CHANGE_LINE_ID. Any solutions?Hi, I’m working on a query that previously ran within seconds, but after adding the lastLEFT JOIN, the execution time has increased significantly—even for a single chang…
-
How to join price list tables with price strategy and customer site detailsi have below tables from price list and price strategy qp_price_list_items_int ,qp_price_list_charges ,qp_tier_lines ,qp_pricing_strategies_tl I want above tables to be …Mazher Shaikh 32 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
How to add row number (fixed order) in analysis?Summary How to add row number (fixed order) in analysis? Content Hello Oracle Team, Is there a way to add row numbers in analysis? When I used RCOUNT(1), the row number …Jonathan Chan gmg 815 views 5 comments 0 points Most recent by Zee Oracle Transactional Business Intelligence