Popular Tags
- OTBI 1,501
- Reporting 1,420
- FDI 1,293
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,015
- BI Publisher 898
- Analysis 699
- Oracle Fusion Analytics 634
- OAC 582
- Administration 564
- Fusion HCM Analytics 447
- Analytics 446
- OBIEE 444
- Fusion ERP Analytics 444
- BI Publisher Data Models 370
- Security 303
- HCM 295
- Oracle Analytics Cloud 294
- Fusion Data Intelligence 276
- BIP 272
- Answers 266
- Analyses 258
- Developers 250
- Data Modelling and Datasets 238
- Fusion Data Intelligence FDI 232
SQL
Discussion List
-
The columns like BANK_NAME and BANK_BRANCH_NAME are blank in iby_ext_bank_account tableWe have a requirement to generate a report retrieving the details of changes made by an employee to their bank details in the payment methods page. We have created a use…Anusha B S 71 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum -
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 1 view 0 comments 0 points Most recent by Pradnya_Pampatwar Oracle Transactional Business Intelligence Forum
-
Pending Transaction next ApproverHello, using oracle cloud BI (SQL), i'm trying to write a datamodel that pulls the pending transaction data and i need information such as the pending with who (current …Hussain Ghuloum 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Oracle Fusion Data Intelligence Forum
-
Accounted VAT queryHi, I have a data model which works for the majority of Accounts Payable Invoices in Fusion Financials, but I have isolated tax lines which do not appear. Taking my more…Robert of STAU 341 views 1 comment 0 points Most recent by Sinduja Sekar-Oracle Oracle Fusion Data Intelligence Forum
-
We have requirement for SQL Query to find open transfer orders for create shipmentHi Everyone, We are trying to get All open transfer orders for create and completion shipment against the Sales Order Lines in current quarter. Getting failed to derivin…Srinivas_VNM 222 views 1 comment 0 points Most recent by Sinduja Sekar-Oracle Oracle Analytics Publisher Forum
-
Time Card StatusHi everyone, I am trying to create a BIP report for Time Card Change History which includes both "Time Entry" and "Time Card Status". For Time Card Status, I am trying t…Candy Miles Domingo 38 views 1 comment 0 points Most recent by Sinduja Sekar-Oracle Oracle Business Intelligence Applications Forum
-
DFF Lexicals in a Non-Standard SQL DataModelHi, We have the requirement to write our data model using the 'Non-Standard SQL' SQL type because we need the use of CURSOR statements to return data back in a nested st…Paul Hassall 21 views 0 comments 0 points Most recent by Paul Hassall Oracle Analytics Publisher Forum
-
Count days function in subject areaHi Everyone, Is there a way to count days in the subject area? I'm working on a checklist subject area, where I want to count task-assigned days. The report count days l…
-
Fusion Analytics Autonomous database Series: Connecting via SQL developerThe video describes how users can connect to SQL Developer using wallet file Download Wallet file https://docs.oracle.com/middleware/1213/wls/JDBCA/oraclewallet.htm#JDBC…Abhishek Bajpai - CEAL Team-Oracle 111 views 0 comments 2 points Most recent by Abhishek Bajpai - CEAL Team-Oracle Oracle Fusion Data Intelligence Forum -
3Logical SQL Query WizardTo improve the experience for end users and to enable full utilisation of the Oracle Analytics self-service capabilities, it will be useful for functionality that enable…Joel Acha11111 51 views 3 comments 3 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Analytics Idea Lab -
Filtering report data based on the time on or before the current date at either noon or midnightI have a small summary report of a few columns to make sure that the PVO data we extract for the SubledgerJournalDistributionExtract PVO matches up to what is in oracle.…Dave Kekish 162 views 1 comment 0 points Most recent by Dave Kekish Oracle Transactional Business Intelligence Forum -
1Attempting to create a lookup table, getting syntax errorI am attempting to use SQL to create a report that determines whether a procurement was completed late or not depending on a number of factors. Due to the many condition…Mariyam129 41 views 2 comments 1 point Most recent by Mariyam129 Oracle Transactional Business Intelligence Idea Lab
-
5Allow Developers to write SQL and preview data on the same screenWhen creating an SQL Data Model, I have to write my SQL in the "Diagram" tab, close the window go into the "Data" tab to see a preview of the results. Realize the change…User_315WR 61 views 2 comments 5 points Most recent by Bret Grinslade - Oracle Analytics-Oracle Oracle Transactional Business Intelligence Idea Lab
-
Regarding 2911553.1 SSL transport detected mismatched server certificateHi Team, For past few days we couldnt connect SQL Dev with ADW instance using wallet file because of the retired the Organizational Unit (OU) field in the tnsnames ora f…Sowmiya Ranganathan 132 views 7 comments 0 points Most recent by Gianni Ceresa Oracle Analytics Forum -
How do I determine a person record is merged in Oracle HCM FusionWe have a series of outbound demographic files to third parties and we are paying thousands in additional licensing due to "merged" person records being included. For ex…CarmenR. 11 views 0 comments 0 points Most recent by CarmenR. Oracle Business Intelligence Applications Forum -
MCPD on Assignment - get top of stackWe are using the following qualifiers for getting a recent assignment. paam.primary_flag='Y', paam.assignment_type='E', paam.effective_latest_change='Y', paam.assignment…Wendy G 81 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
Can you get data from data model or report (not analysis) thought web service (XmlViewService) ?Summary: We need to get the data displayed in a data model or report in an web service (for further integrations). The web service is XmlViewService which allows Execute…maria.stanciu 292 views 4 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum
-
SQL Syntax for Max Salary Record?We would like the most recent salary amount. We used the query below but when we run the SQL we get the error that ORA-00923: FROM keyword not found where expected. Is t…Wendy G 31 views 2 comments 0 points Most recent by Wendy G Oracle Transactional Business Intelligence Forum
-
Where to access Logical SQL queries for parameter creation?In many of the instructional videos about parameters, the Logical SQL query is simply pasted into the box without the video creator mentioning where to access it. Or if …Caroline Blanchard 141 views 2 comments 1 point Most recent by David Granholm-Oracle Oracle Fusion Data Intelligence Forum -
BIP SQL low performanceWe have two instances with same transaction data. And we released the same data model and report in the two instances. Instance 1 has good performance(100s) but instance…