OTBI
Discussion List
-
Difference between OTBI subject area "Real time" and those without "Real time"Content Hi all, Please explain as to what is the difference between the OTBI subject area "Real time" and those without "Real time" . Best Regards, VipushaVipusha Chandrakumaran 84 views 7 comments 2 points Most recent by RyanPasca1 Reporting and Analytics for ERP -
Disable email notifications for Non Catalog Learning ItemsSummary: Hello We would like to disable any notifications for non-catalog learning items added but can;t see any documentation on how to do this. It isn't controlled via…
-
Converting to dateSummary: We have hire date and we are using this to create a two new columns called 'Current Year Anniversary Date' and 'Days to Anniversary Date'. It used to work earli…Simranjeet Singh 36 views 2 comments 0 points Most recent by Simranjeet Singh Reporting and Analytics for HCM
-
Calculate FTE and headcount automatically filed nameSummary: Calculate FTE and headcount automatically filed name Content (please ensure you mask any confidential information): In the "Change Assignment" UI, we have "Calc…Visu 45 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
Balance Sheet by Project: Does this necessitate a project GL Segment or is there another way?Summary: We are in the design phase of a Financials and PPM implementation. Customer desires Project Balance sheets. Other than creating a GL segment for project (not be… -
Is there a way to review users' usage of self service procurement?Summary: Is there a report which we can run to review when users last used their access to self service procurement, in order to manage which users require access? Conte… -
How to Join the AoR (Area of Responsibity) table columns in OTBI logical SQLContent Hello All, As per my knowledge and got the information from other resources, OTBI does not currently support Areas of Responsibility (AoR) and there is no any su…Janardhana Kondaveeti 179 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to use the BIP Report Data Set (Sql queries) into the OTBI Subject AreaSummary: We have created a custom HCM OTL Roster report on the monthly basis based on the scheduler profile. We have to use these Data Set (SQL Queries) directly into th…Venkatesh Babu Somalinga 227 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Looking for Issue description and resolution querySummary: Content (please ensure you mask any confidential information): Dears , I am working on a query to get issue description and resolution , I found them but I coul…Beshoy Hakim-Oracle 12 views 1 comment 0 points Most recent by Vali-Oracle Reporting and Analytics for HCM
-
How to create report for this absence plan pageSummary: Hi , I want to code this page , can anyone help me in this . And i want to get the it as of balance calculation date my report should work. Content (please ensu…Vishnupriya 13 views 1 comment 0 points Most recent by Ionela - Oracle Reporting and Analytics for HCM
-
1Manage version control over OTBI SaaS reportHello. We need to enable version control over OTBI reports in Fusion SaaS. Is there any way to manage version control with Git or another tool? Then, for the reports dev…Darwin HP 92 views 4 comments 1 point Most recent by Darwin HP Reporting & Analytics for Fusion Service -
In OTBI Offboarding Clearance Journey Report Assigned To is not populated for the checklistSummary: In OTBI Offboarding Clearance Journey Report Assigned To is not populated for the checklist where a group is assigned. Also Completed By is not available in OTB…
-
Date a collaborator was added on req ORCSummary: Is there a way to report off when a collaborator was added to a requisition? Content (please ensure you mask any confidential information): Version (include the…Shanna Oppenheim 3 views 0 comments 0 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
How to make HCM Line Manager Dashboard available to HR Admin Roles ?Currently Line Manager Dashboard works only for its direct and indirect reports. We want it to execute under the Data Security of HR Admins, so that they can see data fo…RahulMore 15 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Period of service ID is Null - Cannot link contract to assignment in analysisHi all, I have an issue where contract values cannot be searched for many assignments. If I add a measure (Such as "Employment Contract"."# Of Current Contracts") or ass…Kameron Withak 24 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Attachments - Deeplink in OTBIHi, Is it possible to have a deep link for attachments in OTBI so that the person accessing the report can view the respective attachments, such as PDFs, highlighted in …
-
Combine OTBI and BIP report, role issue/quesitonSummary: I have created a report where I combine OTBI and BIP report in one BIP datamodel. This is due to missing information on OTBI side. Report works as a charm but l…alexey.shtrakhov 83 views 5 comments 0 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
how to find the employee tenure of the current position in the report.How to find the employee tenure of the current position in the report.Mohamed Eliyas 22 views 3 comments 0 points Most recent by Mohamed Eliyas Reporting and Analytics for HCM
-
I need a sql report to pull employees who has changes with there department on specific yearHello Experts, do you have some reports that will pull the data of an employee who has changes with their department, Much appreciate to someone will share Thanks,Joliver Caangay 35 views 1 comment 0 points Most recent by AnushaDB-Oracle Reporting and Analytics for HCM
-
How to report on reverse termination?Summary: Trying to report on reverse termination, but I get no results We are sruggling to document reverse terminations performed by our costumers in HCM, since in the … -
Error while using multiple OTBI Subject areas in one reportSummary: Error while using multiple OTBI Subject areas in one report Content (required): I was trying to combine 2 OLC OTBI SAs and getting the following error. Is there… -
RSSP - Source Application information to be available in subject area?Summary: RSSP - Source Application information to be available in subject area? Content (please ensure you mask any confidential information): Hi Experts, I got it from …
-
How to edit Create Accounting Execution Report to add "Created By" columnI created a copy of standard create accounting execution report in Reports and Analytics to edit the columns reflecting in the report. Upon exploring, adding a "Created …Butch Melvin 17 views 1 comment 0 points Most recent by gabriel.g.popescu-Oracle Subledger Accounting & Accounting Hub
-
Workforce Management Subject Areas (Historical Role & Manager Data)Morning Everyone, I'm investigating a quirk with an OTBI report that we've recently developed for viewing various articles of information for new starts within our organ…John Aitken 34 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM