Popular Tags
- OTBI 1,509
- Reporting 1,428
- FDI 1,330
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,023
- BI Publisher 907
- Analysis 699
- Oracle Fusion Analytics 639
- OAC 615
- Administration 568
- Fusion HCM Analytics 463
- Analytics 463
- Fusion ERP Analytics 461
- OBIEE 446
- BI Publisher Data Models 372
- Oracle Analytics Cloud 312
- Security 309
- Fusion Data Intelligence 298
- HCM 297
- Fusion Data Intelligence FDI 279
- BIP 274
- Answers 267
- Analyses 258
- Developers 250
- Data Modelling and Datasets 241
SQL
Discussion List
-
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 23 views 2 comments 0 points Most recent by Kauan_Bohn Oracle Fusion Data Intelligence 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 -
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 121 views 6 comments 0 points Most recent by POD AH Oracle Transactional Business Intelligence Forum
-
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 2 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 ScreenshotRamsha Zameer 21 views 2 comments 0 points Most recent by Ramsha Zameer Oracle Analytics Publisher Forum -
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 21 views 2 comments 0 points Most recent by Raktim_Pal-IBM Oracle Analytics Publisher Forum -
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 3K views 5 comments 1 point Most recent by Vermaee Oracle Transactional Business Intelligence Forum
-
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 114 views 6 comments 0 points Most recent by Rich Merkel Oracle Transactional Business Intelligence Forum
-
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… -
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 65 views 4 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence Forum -
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 63 views 2 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum
-
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 …Iann hick 22 views 1 comment 0 points Most recent by Riyaz Ali-Oracle Oracle Analytics Publisher Forum -
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 1.1K views 3 comments 0 points Most recent by Riyaz Ali-Oracle Oracle Transactional Business Intelligence Forum
-
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…Kameron Withak 15 views 1 comment 0 points Most recent by MandeepGupta Oracle Fusion Data Intelligence Forum
-
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…Ramsha Zameer 106 views 3 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher Forum
-
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 77 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
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 997 views 5 comments 0 points Most recent by Zee Oracle Transactional Business Intelligence Forum
-
Adding Image in a BIP ReportHi All, We have a requirement to pull an image in a BI Report. Is this achievable? We are using a table (HRT_PROFILES_B) with a CLOB type field wherein the base64 format…JohnAngelo 42 views 2 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher Forum
-
Data Flow Record CountsIs there a concise way to display/calculate the total record (row) count associated with each step in a Data Flow? Users would like to have visual assurance of count tot…Matt_B 43 views 1 comment 0 points Most recent by JohnW-Oracle Oracle Fusion Data Intelligence Forum