OTBI
Discussion List
-
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 31 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 176 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 193 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 11 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 11 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 83 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 1 view 0 comments 0 points Started 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 11 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 21 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 82 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 23 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 31 views 1 comment 0 points Most recent by Anusha Bhat-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 … -
Unable to save XML in BI Publisher.Summary Unable to save XML in BI Publisher.Content Unable to save XML in BI Publisher. We are getting an error: Upload file size exceeds the maximum size limit defined b…Aloka Bhattacharya 50 views 12 comments 0 points Most recent by YASHWANTH GOWDA H R Reporting and Analytics for HCM -
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 11 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 31 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Beginning and Ending balance in Subject Area "Fixed Assets - Asset Balances Real Time" not showing cContent Hi all I'm trying to build a Fixed assets balance, based on the Subject Area "Fixed Assets - Asset Balances Real Time". For some reason it shows the wrong deprec…Anders W. Langholm 95 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP