Popular Tags
- Reporting 1,295
- OTBI 1,212
- Analysis and Data Visualization 796
- BI Publisher 677
- FDI 648
- Analysis 622
- Administration 502
- Oracle Fusion Analytics 459
- OBIEE 390
- BI Publisher Data Models 283
- Answers 253
- Analyses 246
- Developers 230
- Data Connectivity 196
- Security 193
- Analytics 188
- Data Modelling and Datasets 186
- HCM 184
- Report Output 164
- ERP Analytics Content 155
- Agents 145
- BIP 142
- BI Publisher Report Templates 136
- Packaging and Licensing 128
- Home and Catalog 122
SQL
Discussion List
-
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 187 views 7 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
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 135 views 6 comments 0 points Most recent by S Raj Shekhar Oracle Transactional Business Intelligence
-
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 21 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
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…User_JX3W3 31 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Analytics Publisher
-
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
-
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…User_HQ9TE 21 views 1 comment 0 points Most recent by SteveF-Oracle Oracle Analytics Cloud and Server -
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 21 views 2 comments 0 points Most recent by Sinduja Sekar-Oracle Oracle Fusion SCM Analytics
-
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 53 views 2 comments 0 points Most recent by Rojhat Sinan Balka Oracle Transactional Business Intelligence
-
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…Paula McMahon 145 views 8 comments 0 points Most recent by Christian Berg -Oracle Oracle Analytics Cloud and Server
-
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
-
ZMM Notes columns - SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID in Receivables - Transactions Real Time?Summary: Is anyone familiar with the subject area - Receivables - Transactions Real Time? I am looking for the equivalent of SOURCE_OBJECT_CODE, SOURCE_OBJECT_UID column…Scott McAnally 1.1K views 4 comments 0 points Most recent by Robert of STAU Oracle Transactional Business Intelligence
-
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…SusanSandifer 12 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence -
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 22 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
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 17 views 3 comments 0 points Most recent by Sumanth V -Oracle Oracle Fusion SCM Analytics
-
HELP WITH SNAPSHOT TOO OLD ERRORMy table is updated with 36 parallel running oracle jobs all running at the same time. All these jobs update same table but each job deal with different sequence numbers…User_JKU92 21 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
How to make prompts optional in Logical SQL based OTBI analysisHi Experts, We are trying to build OTBI analysis using logical SQL approach and there are few prompts required which are not a part of Select statement so we are trying …User_5BCP3 49 views 1 comment 0 points Most recent by Aaron Leggett Oracle Transactional Business Intelligence
-
Implement a dynamic default value for a DFF field based on another DFFCan anyone help with a SQL query - To implement a dynamic default value for a DFF field based on another DFF field in edit mode, ensuring that values captured in Task 1 …Krishna G 8 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
How can I join the DOO_HEADERS_ALL table with PO tables like PO_LINES_ALL in Oracle Fusion ?I’m working on a BI report for order and item details like order number and item number and description in Oracle Fusion, and I need to join the DOO_HEADERS_ALL table wi…User_IQZBR 159 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
How to Join DOO_HEADERS_ALL table with PO_HEADERS_ALL or PO_LINES_ALL table?I need Order number from DOO_headers_all, then item description from PO_LINES_ALL, also I need receipt_number and invoice number. HEADER_ID is not matching with PO_HEADE…User_IQZBR 259 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence
-
What is the logic to add while creating the prompt in the Logical sql query in OTBISuppose a field/column- Effective Date of Balance in Payroll should be between two dynamic parameters such as Start date and end date. Start Date and End date will be as…Dona Das-Oracle 40 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Oracle Transactional Business Intelligence