OTBI
Discussion List
-
Using SET VARIABLE PARAM_EFFECTIVE_DATESummary I'm trying to default the "SET VARIABLE PARAM_EFFECTIVE_DATE=" back 3 daysContent I'm trying to set the "SET VARIABLE PARAM_EFFECTIVE_DATE=" prefix. I want to us… -
BIP report RTF template excel output type date formatting issueSummary: Hi, Trying to show BIP report output data in excel using RTF template, but when we click on the output data column in the excel data file , the date value showi…Kumar -Oracle 56 views 5 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
BIP Bursting - Linked OTBI Reports HelpHi all, I'm wondering if anyone has a solution to a challenge I've encountered recently. I have two OTBI reports, a feed and a report where the report links to the feed.…MikeW 11 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can we add Rehire column status in OTBI report? Is there any filed is there ?Summary: In a report we need to add rehire column status but there is no field to add this in OTBI report Content (please ensure you mask any confidential information): …Ishrath Begum 15 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Calculating average headcount and turnoverSummary Calculating average headcount and turnoverContent We'd like to be able to calculate the average turnover rate for rolling 12 months by using Period End Headcount…Emily Robinson 343 views 5 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM
-
Veteran Self-Identification Status - no results in OTBI Person Real Time SA **Updated**Summary: I have the 'Veteran Self-Identification Status' along with the other Veteran statuses in multiple analyses and dashboards. Recently, sometime after 8/15/2024, t…Susan Anderson 83 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM -
How can we find the path of the report being referenced in a dashboard within OTBI/catalog?Content Hi All, Is there a way to find the path of the report that is referenced in a dashboard? We have several custom dashboards built by various people within the org…PriyaPenugonda-SC 570 views 5 comments 0 points Most recent by Gokul10 Reporting and Analytics for HCM -
Future Dated Hires and Assignments not showing on reportSummary: I have created a report that picks up future actions. I am using the effective date from the Assignment Events Subject area and it picks up some of the future a… -
OTBI : How to customize the seeded OTBI dashboard and analysis used in the dashboardSummary: Hi All, I have to customize the line manager dashboard -> Absence (tab). When I click on edit dashboard -> edit the analysis, I can see the analysis. But I want… -
Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reportsSummary: Fetch the latest Completion record on the course level in Oracle Learning Cloud OTBI reports Content (please ensure you mask any confidential information): I am… -
How to run report to pull specializations and courses on a single report?Summary: I need to run a report with all specializations with the courses in the specializations with course sequencing position. I don't need any user information, just…
-
Issue with the candidates merged record getting pulled into the OTBI reportSummary: We have built an OTBI candidate report to pull candidates in certain phases and states, we are excluding rejected by employer and withdrawn by candidate. We hav…Denise Izzi 11 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
When I add a specific filter that I need, my report errorsI have an analysis in Workforce Learning - Learning Records Real Time Here is my SQL: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',PREFERRED_CURRENCY='Use…
-
add date conditionSummary: Hi Everyone, I need your assistance in regards to add a date condition in analysis. I have to add a condition in the where clause and want out those positions. …
-
Limiting restricted, Confidential and PII fields BI Authors in HCMSummary: Our goal is simple: Make OTBI authorship available to as many HR and potentially non-HR employees as possible while being conscious of security. Example: Make a…bwdata 33 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI ResourcesContent Resources to help you get the most from OTBI. Training Oracle Applications Analytics Cloud Service Videos (Oracle Learning Library) - many are no longer availabl…Julian Challenger-Oracle 34.2K views 84 comments 116 points Most recent by Mark Stoker Reporting and Analytics for HCM -
What tables to use to pull Learning Class Training Supplier?Summary: Need to find which database tables to use to pull 'Training Supplier' found in Oracle HCM Learning Classes Content (please ensure you mask any confidential info…marcfromhawaii 164 views 4 comments 0 points Most recent by Ramchander Pothanolla Reporting and Analytics for HCM
-
OTBI Recruiting Candidate Data SecurityHello, We currently operate in multiple GDPR countries, and our Legal/Data-Privacy departments are requiring that we lock down candidate and job requisition data based o…Nick Dorfner 12 views 2 comments 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace -
Date format in OTBI PromptSummary: How to change prompt values from datetime to date. Instead of "11/12/2024 00:00:00" I want "11/12/2024" Content (please ensure you mask any confidential informa…
-
Roles and Privileges ReportHi, Can you please help me to develop a report that lists all the privileges for all roles (including both predefined & custom roles) in Fusion? Something like this: Rol… -
Assignment Manager (Unsecured) Dimenssion in Goals Real Time SASummary Data Role Data security not working in OTBI, when using the Assignment Manager (Unsecured) Dimmension in goals Subject areaContent Hi Team, We are using the Dime…Chethan Voma-20174 51 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Misalignment Candidate selection process phase and state between OTBI and UISummary: Content (required): Hello Guys, We would create a report that show for each Candidate selection process Phases and States the correct number of application. By …Giuseppe Iacono 21 views 9 comments 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI Subject Area: "Payroll - Personal Payment Details Real Time" --> Target Bank --> Selected AccoSummary OTBI Subject Area: "Payroll - Personal Payment Details Real Time" --> Target Bank --> Selected Account FlagContent HI, I am looking to identify a field in the OT… -
I would like a way to report that includes the following information in one report:Approval Status: Details of the goals. Pending approvals indicating whether they are with the HR manager or department. Goal details before HR approval: To allow review …
-
BI Publisher is limited in Storage?Summary: Does anyone know, What is the maximum volume of gigabytes that can be stored in different file formats? Regards, Content (please ensure you mask any confidentia…Hernan Modlin-Oracle 1 view 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Termination Headcount from Trend real Time not giving correct headcountSummary: I'm working on an OTBI analysis to calculate and display the turnover percentage for leavers over the last two years as a line graph. The objective is to show t…
-
Need to add Adjustments and Absences in two different columns. Please hep me with the querySummary: Hi Folks, I need to add Adjustments in one column and Absences in one column in the report in Absence Management. Please help me with the query. Content (please…Raj_540 2 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Employees on Leave - Retrieving Assignment Dates for Old Reason CodesSummary: We are trying to create a report that has all employees who are on leave with the date they went out on leave. However, in OTBI if a change is made to an employ…joshvanlaan 4 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to get Month name as abbrevation concat with year in OTBIHi Experts, Can someone please help me how can we get Month name Concat with year in the same column in OTBI. We have a requirement to show the date's in the below scree…