OTBI
Discussion List
-
Expense Authorization along with expense report matched in Expense module reportSummary: Expense Authorization along with expense report matched in Expense module report Content (required): Expense Authorization along with expense report matched in … -
Resource budget in different currenciesI have an OTBI analysis that needs to view the resource in different currencies - as the project budget allows- , but I can't get the amount in resource currency or even… -
Fusion 20C: Custom CM Dashboard not visible to some users?Summary Fusion 20C: Custom CM Dashboard not visible to some users? Cash Manager already assigned but still not able to access the dashboard.Content Hi Experts, Fusion 20…User_87I2Y 62 views 2 comments 2 points Most recent by Georgina Catchpowle Payables, Payments & Cash Management
-
OTBI report to be accessed by differing security profilesWe have a dashboard which needs to be accessed by Line Manager, HR and Individuals. Is this possible to segregate this access in OTBI or will we need to create multiple …Clare Murtagh 31 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
HCM OTBI: OTBI Report Calculations IssueHi, I am facing an issue in OTBI which involves calculations. Please see the below example Column 1: SUM(Distinct TIMESTAMPDIFF(sql_tsi_month, "Worker"."Person Start Dat…Chaitra Lakshmi Krishna 21 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Payroll ReportSummary: Hi, We are trying to find an easy way to run a Payroll Register report from OTBI. I found this seeded Payroll Register report but it has parameters that I am un…
-
Report filter is not working in OTBISummary: Hi we need filter the two departments so When we applied the filter on department is not equal to two department names or dostnot contain also its not working. …AjayKumar Maddipati 11 views 1 comment 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
can you append the sysdate to the file name while delivering the report through agents'Summary: can you append the sysdate to the file name while delivering the report through agents' Content (please ensure you mask any confidential information): Version (…SUSAN SANDIFER 11 views 3 comments 0 points Most recent by SUSAN SANDIFER Reporting and Analytics for HCM -
How do I exclude two question codes from the following query?Summary: Unfortunately I do not know SQL and am struggling with what I would think is a simple ask. I am trying to exclude two question codes from a query that I have. C…Tammy Hemmingson 21 views 2 comments 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM -
OTBI Dashboard to report Learning costsSummary: Hello, I'm facing many difficulties to create easy-to-use dashboard to report learning costs and hours of training. I always have many lines (1 for pedagologica…
-
Avoid adding an additional field twiceHello experts, While making an advanced search, I'm facing the following issue: I need to add the Due Date field, so I click on 'Add Field' and then 'Due Date'. In this … -
otbi performance issuesSummary: we are using an OTBI reporting dashboard to get Worker Emergency contact details reported to a manager. After 24A upgrade, report is giving below error in one o…Surya_Meduri 61 views 4 comments 0 points Most recent by Surya_Meduri Reporting and Analytics for HCM
-
Using OTBI Analysis, how can we append sysdate (MM-DD-YY) to the filename?Summary: Using OTBI Analysis, how can we append the date (MM-DD-YY) to the filename? Content (please ensure you mask any confidential information): Can we append sysdate…SUSAN SANDIFER 52 views 5 comments 0 points Most recent by SUSAN SANDIFER Reporting and Analytics for HCM
-
Talent Pool Report in Oracle BIPSummary: This report is required by the business to report on the grades of talent pool candidates while they are actively part of the talent pool and later, in future y…Pradnya_Pampatwar 41 views 9 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Navigate to Installed base Assets page using action links in OTBISummary: Issue with Navigating to specific Asset summary page from OTBI analysis for IB assets Content (required): I am trying to click to view, and navigate to IB asset…Suresh Kampati 111 views 4 comments 0 points Most recent by Suresh Kampati Reporting and Analytics for SCM -
Unable to find Award Open and Close date, and Award Approval Date in OTBIHello, I am working on an OTBI report that requires the following fields: Award Approval Date Award Open Date Award Close Date I was unable to locate them in the Procure…
-
Can you use temporary tables in cloud fusion otbi?Summary: Can we use temporary tables in cloud OTBI as a replacement for multiple union select statements Content (please ensure you mask any confidential information): W…Erik Bjerkelund 103 views 2 comments 0 points Most recent by Erik Bjerkelund Reporting and Analytics for ERP
-
Req staffing agent fields in OBISummary There are no equivalent fields to this in OBI so how can I report on this using the new Recruiting universe?Content I was asked to build a report showing our ope…User_2025-01-23-20-17-41-106 61 views 2 comments 0 points Most recent by FuriousSS Reporting and Analytics for HCM -
Is it possible to create a text to column like Excel column in OTBI based on a Listagg column?Summary: I need to see data on one row. I've managed to do this using Listagg. However, now they are asking if that it not be concatenated and still keep it all on one r…Donna Fazio 21 views 5 comments 0 points Most recent by Clare Murtagh Reporting & Analytics for Sales
-
Oracle BI Catalog ReorganizationWe are planning a reorganisation of the Oracle BI Catalog folder structures and will much appreciate knowing about any standard processes or best practices that are in p…ks1075 11 views 2 comments 1 point Most recent by Clare Murtagh Reporting & Analytics for Fusion Service
-
how to display latest message in reportSummary: We are building a Service Request Dashboard , in that want to display the messages also. When we combine the SR subject Area and SR Messages Subject are , it is…Anusha716 21 views 1 comment 0 points Most recent by Clare Murtagh Reporting & Analytics for Fusion Service
-
How to setup a Canada Tax Rule for AP invoices only HST for New Brunswick (NB) Supplier Address?Summary: How to setup a Canada Tax Rule for Manual AP invoices only HST for New Brunswick (NB) ? Content (please ensure you mask any confidential information): Hello We …
-
OTBI scheduling agentsCan we use agents to deliver a url to prompt user to log into the system? We have reports which need to be delivered to recipients with varying AORs. e.g. JML for staff …Clare Murtagh 11 views 2 comments 0 points Most recent by Clare Murtagh Reporting and Analytics for HCM
-
Query to check filled and vacant positionsHi All, I need a Query to fetch Vacant and filled positions with headcount. if anyone has please share. Thanks, SowmyaSowmyaSk18 803 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Where can i find the workOrder Approval report which is to be releasedSummary: where can i identify the below attached notification report Content (please ensure you mask any confidential information): Version (include the version you are …
-
Can we edit fonts on OTBI Analysis Reports?Hi, We are reviewing our OTBI suit and wanted to know whether it is an option to change the font to meet business guidelines - is this a possibility? Thanks! Katie
-
Multiple Values to a parameter in OTBI/BIP ReportContent Hi All, We have a report requirement where we need to have a prompt which takes as good as 1000 values for Person Number at a time to run the report. we are work…Vibha Pandey - Oracle 362 views 4 comments 2 points Most recent by Saadiq Reporting and Analytics for HCM
-
which subject area contains the name column of transaction console of oracle hcmSummary: which subject area contains the name column of transaction console of oracle hcmContent (please ensure you mask any confidential information): Version (include …Sneha815353 52 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Suppress a field in BIP reportSummary: We are looking to group a field and suppress it in a BIP report. Content (please ensure you mask any confidential information): As shown in the snippet, we are …Tammy Hemmingson 11 views 1 comment 0 points Most recent by Tammy Hemmingson Reporting and Analytics for HCM