Reports
Discussion List
-
How to open OTBI on phone applicationDear All Kindly find the below: I have create an otbi analytic and dashboard but I want to link it to the phone application What is the name of the app ? How to link it?…mickel rmeily 31 views 5 comments 1 point Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
How to Fetch more than 1000 records with BIP or OTBI reportSummary: Fetch more than 1000 records with BIP or OTBI report. Content (required): Hi, How to fetch more than 1000 records with BIP or OTBI report. I tried with Paramete…Sudheer YN 31 views 6 comments 0 points Most recent by Rich Merkel General Transactional Reporting (OTBI) -
we have two subject areas in ORC but unable to find Offer Extednded DateSummary: Hi Team, we have two subject areas recurting real time and recurting events real time we unable to find Offer Extednded Date -column how can we find that column…AjayKumar Maddipati 41 views 9 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI) -
Need to remove delete option of report from BI Abstract roleContent Hi, We have created BI abstract roles for giving access to reports. how to remove delete option of report for those users in BI catalog? Regards, Nivya Version 1…Nivya Mathire 27 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI) -
How to default the method of opening for an analysis that has been favorited?I have an analysis with a filter marked as a Favorite. The issue I have is when I click on the analysis from the Favorites dropdown, it opens into edit mode. Is there a …Mike Burnett 51 views 10 comments 0 points Most recent by Nathan CCC General Transactional Reporting (OTBI) -
How to build an Analysis on OTBI to show every colleague's default expense account?Summary: Need report to show all colleague's default expense accounts. Content (required): I need to create a report to show every colleague's default expense account so…
-
we need every year annual review value in performance documentsSummary: Hi Team, We need every year annual review value in performance documents in OTBI in sunbject area of performance rating real time. EXample--FY2021 Employee Annu…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
Finding the alphabets from a Alphanumeric in OTBI.Summary: I have a requirement to identify the alphabets (be it upper/lower case) from a string. The format of the sting is as follows: SSN: ****-XX-XXXX (112-10-1234) TI…satya_nvs 21 views 2 comments 0 points Most recent by Venkat Koduvayur-Oracle General Transactional Reporting (OTBI)
-
Count positive values and compare with total count to get the aggregated share of positive valuesSummary: How can I count the number of positive values in a column and compare with the total count to get the share percentage of positive values? Content (required): I…Stefan pettersson 31 views 3 comments 0 points Most recent by Stefan pettersson General Transactional Reporting (OTBI)
-
Turnover by Ethnicity - Report AssistanceSummary: We are currently running into issues creating a Turnover report by Ethnicity due to how ethnicity is handled in Oracle. This is causing employees to be duplicat…
-
How do we build an OTBI report to see the ratings of a Business Unit head's organization?Summary: The client requires a report that can be run to fetch the Performance ratings of all the employees that fall under a particular Business Leader (direct as well …Shubham Shree 11 views 1 comment 0 points Most recent by Sovitendu Jalli-Oracle General Transactional Reporting (OTBI)
-
Fusion BI Catalog Folder Management Best PracticesSummary A white paper on Fusion BI Catalog Folder Management Best PracticeContent This white paper provides the best practices for working with BI catalog folders, and s…User720640-Oracle 108 views 1 comment 9 points Most recent by HarishVummidi General Transactional Reporting (OTBI) -
Does anyone know what tables are needed to create OTBI report "Transactions awaiting my action"?Summary: Indirect Procurement stakeholder wants to create an OTBI report for "Transactions Awaiting My Action". This would be used to review POs that were not successful…MarysueMcCracken 11 views 4 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
is it possible to copy all users' reports from their own folders to the Share folder?Summary: Hi, Who can advise: is it possible to copy all users' reports from their own folders to the Share folder? For example, I have created a report and saved it in M…Ann Djiyanova 31 views 5 comments 0 points Most recent by Gaurav Bharadwaj-Oracle General Transactional Reporting (OTBI)
-
Report showing incorrect rolling monthsSummary: Hi Team, We have absence rolling report last 12months but only showing last 10 months data for country. i mean rolling need to Feb'22 to Jan'23 but its taking o…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by Dhruvjoshi23 General Transactional Reporting (OTBI)
-
Report Location of following seeded reportsHello - We are having a request to implement/customize the following reports but will have to analyze first the complexity of each report. Unfortunately, we are unable t…ZenG 21 views 2 comments 0 points Most recent by Gaurav Bharadwaj-Oracle 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 1 comment 1 point Most recent by Parag Hiremath General Transactional Reporting (OTBI)
-
Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22ASummary: Table to retrieve records from Audit reports in Oracle Cloud Fusion ERP 22A Content (required): Which table in SaaS stores information for Audit Reports? Table …Abhilash K - Deloitte USI 12 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI General Transactional Reporting (OTBI) -
View Previous run history of an agentSummary View Previous run history of an agentContent Hi I have created an agent to run a report in Oracle BI. I have scheduled the agent . It seems last run has failed b…Ritwick Chatterjee 46 views 6 comments 2 points Most recent by Andrew_Schmitz General Transactional Reporting (OTBI) -
How to add on Home Email address into a OTBI report?Summary: See work email, but home email is updated in myHR however dont see the home email address field to add in report - Please advise. Content (required): Version (i…Abhishek Bagh 31 views 1 comment 0 points Most recent by Mandeep Gupta General Transactional Reporting (OTBI)
-
We have Connect Conversation Questionnaire below in Performance mgmt how can we extract the reportSummary: we have Connect Conversation Questionnaire below in Performance mgmt how can we extract the report in below questions and answers filled by emps. Performance >>…AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati General Transactional Reporting (OTBI)
-
Recruiting: How to create a report to show the list of Offer approversSummary: Hi All, There have been many issues in 22B regarding (Recruiting) Offer approvals getting stuck, or not working the way they should be. It was just recently fix…Jessie Gee 11 views 1 comment 0 points Most recent by PatriciaS-Support-Oracle Recruiting, Opportunity Marketplace -
which subject area we get father/husband names in OTBISummary: Hi Team, we need data employees of father and husband names so could please assitance on. Content (required): Version (include the version you are using, if app…AjayKumar Maddipati 22 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
how to put a Countif in a unique field in an OTBI reportSummary: In my report, I have Person Number field which is unique, however the report has some duplicate entries. I only need to understand how do I get a count to see h…Abhishek Bagh 31 views 8 comments 0 points Most recent by Amrita Gupta-Oracle General Transactional Reporting (OTBI)
-
Repeat Column Headers in BI Publisher Excel TemplatesSummary Repeat Column Headers in BI Publisher Excel TemplatesContent Hello Everyone, I have a requirement to repeat column headers in BI publisher excel templates when t…Dhanuka Chamal 40 views 5 comments 2 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI) -
In OTBI Agent how can we apply mails in CC (carbon copy)Summary: HI Team, I can't seen in OTBI Agent no option for cc (carbon copy) Mails to add the recipecients. only To option available . Any other option for cc in otbi age…AjayKumar Maddipati 11 views 2 comments 0 points Most recent by ravikiran goda-Oracle General Transactional Reporting (OTBI)
-
R13.x Deprecated and New BI View ObjectsSummary This posting includes R13 deprecated Business Intelligence View Objects (BIVOs) that are unavailable for extraction using BI Cloud Connector (BICC) in Oracle App…Rashmi M-Oracle 5.4K views 14 comments 11 points Most recent by LCann-Oracle General Transactional Reporting (OTBI)
-
Do analyses run with Agents log to "OTBI Usage Real Time" subject area?Summary: Do analyses run with Agents log to "OTBI Usage Real Time" subject area? Content (required): Version (include the version you are using, if applicable): Code Sni…Andrew_Schmitz 1 view 4 comments 0 points Most recent by Andrew_Schmitz General Transactional Reporting (OTBI) -
OTBI: Find the number of Working/Business Days between two dates and exclude Public HolidaysSummary OTBI: Requirement to find the number of Working/Business Days between two dates, therefore the calculation must exclude days that fall on Weekends or Public Holi…Richard Beet 157 views 5 comments 0 points Most recent by Venu Kumar General Transactional Reporting (OTBI)
-
OTBI Multi Language Support - Report not bringing back data when in different languageSummary: When users who have a different language selected other than English runs a New Hire report, the report will bring back no data because of a string in the filte…Max W 11 views 4 comments 0 points Most recent by Bhaskar Konar General Transactional Reporting (OTBI)