SQL
Discussion List
-
How to do an average days to approve formula?Content Hi all, I am trying to do an average days formula from a requisition submission date and when it was approved, and then put another column in with the month it w…Doron de Jong-57089 21 views 1 comment 0 points Most recent by aconavay General Transactional Reporting (OTBI) -
Help with Formula: most recent offerSummary I need help creating a formula to pull in the most recent offerContent I'm pulling together a list of YTD offers. I am finding records where the candidate has ac…Rosenerie Castillo 36 views 7 comments 2 points Most recent by Jonathan Chan gmg General Transactional Reporting (OTBI) -
Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?Summary Feasibility of having SQL Developer Connection to Oracle HCM Cloud Enviornment?Content Hi Experts, I hope that most of you who have worked on an On-Premise syste…AshishHCM 71 views 5 comments 7 points Most recent by narasimha arekatla General Transactional Reporting (OTBI) -
BI Publisher CSV files or Reading from Content Server sourceSummary Reading files on the Content Server in BI PublisherContent Hello, I'm trying to create a report in BI Publisher that will read an external file as a data source.…Rob F 43 views 4 comments 0 points Most recent by user12182418 General Transactional Reporting (OTBI) -
Need inputs to find who created/deleted the folder in Reports and AnalyticsContent Hi All, We have different custom folders in Reports and Analytics side. Is there any way to find who created/deleted the folder or Data model or Report? We need …Visu 24 views 4 comments 0 points Most recent by Tugce Kucukoner-144150 General Transactional Reporting (OTBI)
-
Trailing Spaces in OBIEESummary formatting questionContent Hello! I am hoping to poll the community regarding some OBIEE formatting i'm trying to accomplish. I have a report where I need to cre…Joy Hanneman-161050 17 views 2 comments 1 point Most recent by Nathan CCC General Transactional Reporting (OTBI)
-
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…Kristopher Neilsen 118 views 5 comments 0 points Most recent by VR General Transactional Reporting (OTBI)
-
Setting relative dates in a filter for an OTBI AnalysisSummary In an OTBI Analysis is there a way to add into a relative date range into a filter?Content I need an Analysis with a filter to pick up dates within the last week…Tim Welsh 255 views 17 comments 3 points Most recent by Kamran Butt-161785 General Transactional Reporting (OTBI) -
Security Console TablesContent Hi Everyone Quick question, is there a table that I can query in BIP that will show me the Roles and Roles Description? We have been struggling to assign the rig…Aaron Leggett 107 views 5 comments 0 points Most recent by Karthik Vinodkumar General Transactional Reporting (OTBI) -
Filter on blank and future datesSummary Create a filter using SQL expression to show just the null and future dated valuesContent Hello, I have a need to see only the null values and future dates. I'm …Stephanie Gott 20 views 2 comments 1 point Most recent by SantoshKumarB General Transactional Reporting (OTBI) -
Filter for terminations in prior calendar weekSummary I'm creating a termination report and trying to show which terminations were in the calendar week (Sunday-Saturday) prior from the week when the report was runCo…Karen B 34 views 3 comments 1 point Most recent by Lavanya Reddy General Transactional Reporting (OTBI) -
How to get and SQL for our own OTBI AnalysisSummary SQL for OTBI AnalysisContent Hi All, How to get and SQL for our own OTBI Analysis.I know we can get this in the advanced tab but there we cannot see the sub quer…Praveen Kumar-146357 77 views 3 comments 4 points Most recent by Christian Berg-0racle General Transactional Reporting (OTBI)
-
How to modify the content of a column through a result similar to RPADSummary How to modify the content of a column through a result similar to RPAD - we want to create a report that will need to have a specific lenght per column & wish to…
-
Oracle Fusion OTBI Direct Database Query/ReportSummary Querying Oracle Fusion OTBI feature is being deprecated for CLOUD environment from 19A releasesContent Creating Reports with Direct Database Query in Oracle Fusi…Senthilrajan V 136 views 9 comments 2 points Most recent by Senthilrajan V General Transactional Reporting (OTBI) -
Is Orders data available through the OTBI layer in Order Management / SCM?Summary Is Orders data available through the OTBI layer in Order Management / SCM?Content Is Orders data available through the OTBI layer in Order Management / SCM? Reas…Shalindra Singh 20 views 1 comment 1 point Most recent by Shalindra Singh General Transactional Reporting (OTBI)
-
Remove duplicate values in OBIEEContent Hi All, Is it possible to remove duplicate values in OBIEE? In my report, columns A and B have unique values per line for an employee, however, column G is all t…Natalie Andrek-27262 59 views 4 comments 0 points Most recent by RichardChan General Transactional Reporting (OTBI) -
OTBI Variable Presentation Date Prompt Format DD-MON-YYYYSummary Users need to be able to enter a date in DD-MON-YYYY format at the promptContent Our date format changed to dd-MON-yyyy (15-MAY-2017), but the only way the repor…Brenda Jacks-49721 95 views 1 comment 0 points Most recent by RichardChan General Transactional Reporting (OTBI)
-
Using an SQL Date Formula in OBIEE ReportSummary How do I display previous 30 days of dataContent Could someone please show me how to tweak the below formula. I’d like to pull data from the previous 30 days; ho…Nina Manns 54 views 8 comments 3 points Most recent by Nina Manns General Transactional Reporting (OTBI)
-
Can we have a OTBI analysis based on a BI Publisher Report's output?Summary Can we have a OTBI analysis based on a BI Publisher Report's output?Content Can we have a OTBI analysis based on a BI Publisher Report's output? Regards, RashmiUser_MC37Q 42 views 9 comments 0 points Most recent by User_MC37Q General Transactional Reporting (OTBI) -
Customizing a Seeded Report - Editing the Data Model and using PackagesSummary The Payable Invoice Aging Data Model uses package AP_APXINAGE_XMLP_PKG. I could use instructions on how to interact in SQL with this package.Content I am searchi…Tim Welsh 59 views 8 comments 0 points Most recent by rajArun General Transactional Reporting (OTBI)
-
OTBI - add a SQL column to a subject area analysisSummary Can you refer to a table using SQL and a subject area at the same time?Content Is it possible to add column to a subject area using SQL? I have tried editing the…Antony Hooper-29731 97 views 1 comment 0 points Most recent by venkata veeragoni General Transactional Reporting (OTBI)
-
How to create a custom read online role to allow users to self serve reports that are segregatedContent Hi All I am struggling to get to grips with one area of reporting and that is allowing users to self serve some key reports we have but I need them to be segrega…Doron de Jong-57089 26 views 0 comments 0 points Started by Doron de Jong-57089 General Transactional Reporting (OTBI)
-
Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQLSummary Pipleline Time In Process - Detail & Metrics Performance Issue - Advanced SQLContent Hi All, We have a dashboard -Pipeline Time In Process which consists of both…Ramesh Nakka 13 views 0 comments 0 points Started by Ramesh Nakka General Transactional Reporting (OTBI) -
Is it Possible to Use an Alias for the Bursting Sender Info?Summary Is it Possible to Use an Alias for the Bursting Sender Info?Content We engaged a vendor to write some BI Publisher reports, which use bursting to send out emails…Rebekah Baker 62 views 8 comments 0 points Most recent by Sricharan Monigari General Transactional Reporting (OTBI) -
Prompt Dashboard for cross subject areasSummary Prompt Dashboard for cross subject areasContent Hello, I have an analysis made by two subject areas (linked by an INNER JOIN) and the system puts "saw" alias in …User_MBZFP 48 views 2 comments 1 point Most recent by Jagadish Angadi-29558 General Transactional Reporting (OTBI)
-
Oracle BI Publisher - Report on Report Job HistorySummary Find a way to acquire all Report Job History listed and extract all data to ExcelContent Hi, I used to be an Apps DBA\Technical application Support on R12 EBS ba…Barry Stamp-73691 86 views 1 comment 1 point Most recent by rajArun General Transactional Reporting (OTBI) -
Packages in BI publisherSummary Packages in BI publisherContent Dears , I am migrating some reports from EBS R12 into oracle cloud fusion . some of these reports SQL query contains standard pac…Islam Abu Khamseh-76822 36 views 1 comment 0 points Most recent by rajArun General Transactional Reporting (OTBI)
-
Exceeded configured maximum number of allowed input recordsSummary Error message received when running reportContent Hi, could someone explain why I get the attached error? Many thanks, Antony.Antony Hooper-29731 39 views 3 comments 0 points Most recent by Vijaya Kumar-70229 General Transactional Reporting (OTBI)
-
Pass Groovy script variable to OTBI DashboardSummary Pass Groovy script variable to OTBI DashboardContent Hi All, I want to Pass Groovy script variable for OTBI Dashboard from fusion page to Dashboard (Dashboard pr…user11018780 51 views 0 comments 0 points Started by user11018780 General Transactional Reporting (OTBI)
-
Table name to capture reverse termination date & its details for reverse terminated employeesSummary Table name to capture reverse termination date & its details for reverse terminated employeesContent Hi All, In which table I can find the reverse terminated dat…Nirmal Kumar L 20 views 0 comments 1 point Started by Nirmal Kumar L General Transactional Reporting (OTBI)