Popular Tags
- OTBI 1,498
- Reporting 1,417
- FDI 1,290
- Fusion AI Data Platform 1,054
- Analysis and Data Visualization 1,014
- BI Publisher 895
- Analysis 699
- Oracle Fusion Analytics 632
- OAC 581
- Administration 564
- Fusion HCM Analytics 447
- Analytics 446
- OBIEE 444
- Fusion ERP Analytics 443
- BI Publisher Data Models 370
- Security 303
- HCM 295
- Oracle Analytics Cloud 292
- Fusion Data Intelligence 274
- BIP 272
- Answers 266
- Analyses 257
- Developers 249
- Data Modelling and Datasets 238
- Fusion Data Intelligence FDI 230
SQL
Discussion List
-
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 13 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 24 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 52 views 3 comments 0 points Most recent by Sumanth V -Oracle Oracle Fusion Data Intelligence Forum
-
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 51 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence Forum
-
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 …SumukhaMohan 163 views 1 comment 0 points Most recent by Aaron Leggett Oracle Transactional Business Intelligence Forum
-
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 41 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
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 511 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
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 491 views 1 comment 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
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 41 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Oracle Transactional Business Intelligence Forum
-
Query to capture payment process request approver name,Number and approved DateHi Team, We have configured BPM rules for Payment process request and we need to capture approver records like approver name, approver number and approved date along wit…Muzaffaruddin 661 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence Forum
-
When ever apply some another column in sql it will automatically affected another measure columnHello Everyone, When ever apply some another column in sql it will automatically affected another measure column in sql report I want c1 is 15 value based on add another… -
Bi Publisher Data model returning error when run, after using system variable in the sql query.We created a data model and defined a condition in the sql query using the system variable ':xdo_user_roles' (which fetches all roles of the session user) and using it, …Bishal Dutta 98 views 2 comments 0 points Most recent by Bishal Dutta Oracle Analytics Publisher Forum
-
Report output require in one rowHello Expert I have a problem with the output of the report. How can we obtain a single employee record in a row? If someone could help me with this, it would be greatly…
-
How to limit Prompts to Yes/No in Dashboard?I have a requirement to develop a table with yes/no prompts for ex: the contracts for the suppliers if the user select yes, it will retrieve all the suppliers who has th…User_1EN5M 31 views 2 comments 1 point Most recent by Rich Merkel Oracle Transactional Business Intelligence Forum
-
Employee signature picture in reportHello Everyone, Can anyone tell me how I can show an employee's handwritten signature in my report? Thank you.
-
Number columns are in text format in Excel exportHi, when our users export the data from Business Intelligence Publisher report to Excel, they want to perform additional analyses. Hence, they need to perform calculatio…Ante Obradović 761 views 2 comments 0 points Most recent by Ante Obradović Oracle Transactional Business Intelligence Forum
-
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 74 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Oracle Transactional Business Intelligence Forum