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 280
- BIP 274
- Answers 267
- Analyses 258
- Developers 250
- Data Modelling and Datasets 241
SQL
Discussion List
-
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 322 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 1.4K views 4 comments 0 points Most recent by Bhaskar Konar Oracle Fusion Data Intelligence 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 194 views 7 comments 0 points Most recent by MandeepGupta Oracle Fusion Data Intelligence 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 21 views 1 comment 0 points Most recent by Sumanth V -Oracle Oracle Fusion Data Intelligence 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.4K 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 72 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… -
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 281 views 15 comments 0 points Most recent by SERGIO BARRETO Oracle Fusion Data Intelligence 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 306 views 7 comments 0 points Most recent by Lynda G Oracle Transactional Business Intelligence Forum
-
4Restrict 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 246 views 3 comments 4 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 84 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 23 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 113 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 143 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 310 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 201 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 41 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 32 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 15 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher Forum