Popular Tags
- OTBI 1,457
- Reporting 1,399
- FDI 1,153
- Fusion AI Data Platform 1,024
- Analysis and Data Visualization 993
- BI Publisher 868
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 487
- OBIEE 434
- Fusion HCM Analytics 417
- Analytics 410
- Fusion ERP Analytics 390
- BI Publisher Data Models 360
- Security 301
- HCM 270
- BIP 265
- Answers 265
- Analyses 255
- Developers 246
- Data Modelling and Datasets 229
- Oracle Analytics Cloud 221
- ERP Analytics Content 215
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
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 72 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 31 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 31 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 24 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 322 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 12 views 1 comment 0 points Most recent by MandeepGupta Oracle Fusion AI Data Platform 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 61 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 51 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 904 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 31 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… -
Extracting Goal SuccessCriteriaText from hrc_txn_data that is greater than 4000 Characters using OraSummary Extracting SuccessCriteriaText for Performance Goals in Draft or Pending Approval from hrc_txn_data using SQL when SuccessCriteriaText is having more than 4000 C…Ravindra Paidiparthi 301 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence Forum
-
SQL query or Table for Cost Accounting DistributionsHi Team, Need a table which stores the information of Cost Accounting Distributions. Required columns: Run control, preprocessor, Cost prcocessor, Status, Cost organizat…Opkey PA 897 views 4 comments 0 points Most recent by Bhaskar Konar Oracle Fusion AI Data Platform Forum
-
How can I join the SCM tables with Financial tables in Oracle Fusion ?I'm developing a SQL report to join in Customer_po_number from DOO_HEADERS_ALL with Invoice_num from AP_INVOICES_ALL. However, there’s no direct common column between th…AdamOoba098 131 views 7 comments 0 points Most recent by MandeepGupta 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 11 views 1 comment 0 points Most recent by Sumanth V -Oracle Oracle Fusion AI Data Platform Forum
-
OTBI Report Too Slow / Not Generating ResultsSummary: Have created a report to pull all roles for all users (Audit purposes), and admittedly there is an excessive amount of data to pull. That being said, when runni…User_DKPSX 1.3K views 11 comments 0 points Most recent by User_ABC0S Oracle Transactional Business Intelligence Forum
-
sql query to get recorded absences on their time cards in oracle fusion cloudHi All, SQL query to get recorded absences on their time cards in oracle fusion cloud hcmmist123 51 views 1 comment 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum
-
Logical SQL in calculation validated ok but Query Error in Visualization.Hi Group, I've tried a Logical Sql in calculation in OAC, it showed validate OK,like below part1, but have Query Error in visualization like below part2. And if we use V…