Popular Tags
- OTBI 1,393
- Reporting 1,362
- FDI 946
- Analysis and Data Visualization 937
- BI Publisher 814
- Analysis 660
- Administration 551
- Oracle Fusion Analytics 541
- OBIEE 420
- Analytics 336
- BI Publisher Data Models 335
- OAC 320
- Security 263
- Answers 260
- Analyses 253
- Developers 239
- HCM 234
- BIP 230
- Data Modelling and Datasets 217
- Data Connectivity 205
- ERP Analytics Content 198
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
SQL
Discussion List
-
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 17 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 21 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 11 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 29 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 16 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 757 views 5 comments 0 points Most recent by Zee Oracle Transactional Business Intelligence
-
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…
-
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 255 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle Oracle Transactional Business Intelligence
-
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…
-
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…
-
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…
-
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…
-
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.1K views 11 comments 0 points Most recent by User_ABC0S Oracle Transactional Business Intelligence
-
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 22 views 1 comment 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence
-
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…