Popular Tags
- OTBI 1,458
- Reporting 1,399
- FDI 1,153
- Fusion AI Data Platform 1,024
- Analysis and Data Visualization 994
- BI Publisher 868
- Analysis 684
- Oracle Fusion Analytics 597
- Administration 557
- OAC 488
- OBIEE 434
- Fusion HCM Analytics 417
- Analytics 412
- Fusion ERP Analytics 390
- BI Publisher Data Models 360
- Security 301
- HCM 270
- Answers 265
- BIP 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
-
Error in SQL query from a connection to Fusion ERPI established a connection with Fusion ERP, I want to make a manual query through SQL but when I try to do it I get the following message: "There was an unexpected error…SERGIO BARRETO 151 views 15 comments 0 points Most recent by SERGIO BARRETO Oracle Fusion AI Data Platform Forum -
Which Oracle Fusion Cloud GL tables do I join to get YTD nominal balances?Trying to build an opex report but only getting the current period values not year to date. Do I have to add multiple rows of sql into the data model to add all the peri…Lynda G 204 views 7 comments 0 points Most recent by Lynda G Oracle Transactional Business Intelligence Forum -
3Restrict BIP access (table access) for person, sensitive dataWhen creating or editing a data model it should be possible to restrict data access to certain tables that contain person sensitive data such as Ethnicity etc. The secur…Vina Vyas 101 views 3 comments 3 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Idea Lab
-
Query for Issue description and resolution in transaction consoleDears , I am working on a query to get issue description and resolution , I found them but I could not exact fault message for transaction. Here is the code I am using .…Beshoy Hakim-Oracle 41 views 2 comments 0 points Most recent by MandeepGupta Oracle Transactional Business Intelligence Forum
-
Please can someone provide me the SQL to split out "Worker"."Employee Mailing Postal Code" AS IncodeHi, i am tyring to use a calculated measure to split the "Worker"."Employee Mailing Postal Code" (Workforce Management - Person Real Time Folder) to show a column with j…MLowe3639 21 views 2 comments 0 points Most recent by MLowe3639 Oracle Transactional Business Intelligence Forum
-
Is it possible to fetch dynamic columns based on lookups in BIP report for aging purposeI had a requirement to have a different set of buckets for inventory aging reports, is this achievable?Jayant Ajayrao Deshmukh 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum -
Query to get fetch Archived Transaction Summary dataHi Expert, Does anyone have a query to fetch the Archived Transaction Summary data? I would really appreciate it if you could share a BI query here. Thank you in advance…Saher 94 views 3 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
SQL code runs fine in SplashBI SQL Connect tool but times out in Oracle BIP Data ModelHi all - I have a SQL query that runs within a few seconds in my Splash BI (SQL Connect) query tool, however when I use this same code in the Oracle Data Model in BIP it…KDR 82 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
Where do I find DFF's in subject area Workforce Management - Documents of Record Real TimeSummary: I am attempting to build a report using the Workforce Management - Documents of Record Real Time I have managed to get to the Document Type Vacation Carryover A…PamS 272 views 7 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
BI Cloud Connector support custom offerings for extract?Content Looking into using the BI Cloud Connector(BICC) for extraction of data sets for integration with our E-Business Suite custom product. The BI Cloud Connector offe…KristopherN 173 views 6 comments 0 points Most recent by S Raj Shekhar Oracle Transactional Business Intelligence Forum
-
Can you convert field [Recruiting-Recruiting Real Time] from Date to Date & Time in OTBI?We would like the time associated with the job application in the field 'Job Application - Electronic Signature' Can I convert this field to date & time instead? If so, …Wendy G 31 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
Extract all the SQL queries of different BI Publisher reportsHello, I have many reports and I want to extract all the Sql queries of their data model. I can't do it manualy because I have more than 100 reports. Can I find a way to…Sherazad Melili 31 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
how can I display days off for an employee when there is neither time in nor time out on these daysI have an issue that I need to display employee days off as "day off". For example, I have an employee whose days off are from 10:00 to 18:00 (Friday & Saturday), and hi…Salma Ashraf 11 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum
-
ORA-01427: single row subquery return more than one rowWhen I run the mapping in ODI it will getting the issue ORA-01427: single row subquery return more than one row And am add rownum=1 in join condition interface successfu… -
How to merge rows if their 2 columns are the same in OTBI Analysis?Hello, I have an analysis where I'd like to merge multiple rows if they share the same value for "Item Description" and "Unit Price". Example: | Item Description | Unit …Rojhat Sinan Balka 101 views 2 comments 0 points Most recent by Rojhat Sinan Balka Oracle Transactional Business Intelligence Forum
-
OAS/OAC - using a parameter in a dynamic SQL query.Hi, I have a workbook containing a table/graph that has been generated by a SQL query, connecting to some Oracle database tables. The SQL query is hardcoded to pull data…
-
24B: BIP - What is the subject area or tables to get transaction approvers from Learning?Please provide the subject area or an SQL tables to retrieve transaction approvers from the Learning module (24B). I have tried using this one, but it doesn't return any…Nipon 31 views 1 comment 0 points Most recent by Rajesh L-Oracle Oracle Business Intelligence Applications Forum
-
Custom report to monitor login activityLeadership would like a custom report to monitor login activity. We'd like to know which users logged in last week and which application/function they used. Sample outpu…SUSAN SANDIFER 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum -
need to add item number with item class and item category in bipneed to add item number with item class and item category in bip, How can I join EGP_SYSTEM_ITEMS_B table with EGP_ITEM_CLASSES table and EGP_ITEM_CATEGORIES_TABLE ? The…User_IQZBR 21 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
I need Item_Number with Item_Class and Item_Category in my BIP reportI need Item_Number with Item_Class and Item_Category in my BIP report, How can I join EGP_SYSTEM_ITEMS_B table with EGP_ITEM_CLASSES table and EGP_ITEM_CATEGORIES_TABLE ?User_IQZBR 41 views 3 comments 0 points Most recent by Sumanth V -Oracle Oracle Fusion AI Data Platform Forum