OTBI
Discussion List
-
ERP - OTBI Advanced Features event on Sep 22th 9am Pacific TimeSummary: After the record interest from this community on the previous OTBI event 'ERP - OTBI Made Easy' in May, and several requests for an advanced session, we decided…Maria Centeno-Cloud ERP-Oracle 54 views 1 comment 0 points Most recent by Aaron Tanek Reporting and Analytics for ERP -
Job Start date in OTBI reportSummary if employee having multiple assignments but can we fetch job start date in OTBIContent Employee : works for property #1 (legal entity) with job of cashier starti…User_VR8E0 57 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Report showing new managers with direct reportsContent Hello, We need a report that will show managers with direct reports and the effective date of when they had their first direct report assigned to them. This repo…Shanna Oppenheim 104 views 7 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Employee historical rowsSummary: Looking to get a report of all employees in the system and all of their historical records. If we run the Worker Assignment Real time subject, it can pull histo…Mike Borghoff 51 views 3 comments 1 point Most recent by Mike Borghoff Reporting and Analytics for HCM -
Drill down reportSummary: Drill down report Content (required): I have created analysis with two columns as department and head count, I have created action link on headcount column whic…Reddykrishna Chidella-Oracle 21 views 2 comments 0 points Most recent by Sovitendu Jalli-Oracle Reporting and Analytics for HCM -
How to show all organization/department levels in hierarchical tableSummary: I'm trying to build an analysis showing all departments in each legal entity but only get departments that have employees connected to them. Content (required):…Matti Bugge 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Adding a column that calculates the % based on absolute numbersSummary: Content (required): Hi there I am sure this must be fairly simple but ... I have a report with pie chart for people completed, not started and in progress for L…Bobby Jourdan 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Seniority Date values are not available in OTBISummary Seniority Date values are not available in OTBIContent Hi Team, Seniority Date values are not available in OTBI, Workforce Management Assignment Real Time and Ev…User_2025-02-06-10-22-06-460 273 views 6 comments 1 point Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
OM Cloud - Has someone created any dashboard or report for the credit exposure details like in EBS?Summary: In EBS, there is a credit exposure report which has complete credit information of customer like open invoices, existing open sales order etc. which help busine… -
What happens when you change the name of an assignment analysis that is used in an initiative?Summary: I need to change the name of an assignment analysis (vs create a new assignment analysis and then create a new learning initiative.) Will OLC still reconcile th… -
OTBI Analysis Prompts NOT SEEN when I run the report in supply chain planning moduleSummary OTBI Analysis Prompts NOT SEEN when I run the report in supply chain planning moduleContent Hi, OTBI Analysis Prompts NOT SEEN when I run the report in supply ch…Sanjiiv Chavaan-158651 15 views 1 comment 0 points Most recent by Cherry Bruns-Oracle Supply Chain Planning and Collaboration -
Item Master MDM in HealthcareContent Hello, Brand new here and still not sure I understand how to review the forums, so sorry if this is an existing topic: We are a healthcare provider system (hospi…User_IBZ1J 23 views 1 comment 1 point Most recent by Shyam Lakshman-Oracle Product Master Data Management -
What tool(s) are recommended for populating a data warehouse?Summary: Content (required): We are currently using BIP because the EDW has requested full tables. We're looking into the alternatives due to our volume (35,000+ workers…Scott Paulin 11 views 1 comment 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM -
Recap of Ideas related to Audit Policies and audit logging abilitiesContent Following is a list of over 40 Ideas related to Audit Policies that we and others have logged. Most of these are essential to have complete audit logs; what we w… -
Report on Employees on Leave during a certain time periodContent Hello - We are trying to find a way to report on employees who were/are on a leave of absence during any given time frame. The issue we are having is that there …Shanna Oppenheim 83 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Filter out a double entry and leave only one entry in Person Profile Real Time subject areaSummary: Filter out a double entry and leave only one entry in Person Profile Real Time subject area Content (required): Hi there, We have a report that lists all the va…Bobby Jourdan 11 views 4 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
OTBI Column decodeHi In OTBI report , we need to decode the column value , like if column value is 'ABC' the we need to decode the it 'BCD', how can we do this please? Thanks -
Report on all the comments that the enrolled users have done in Enrollee Self-service conversationSummary: Content (required): Hi there I want to run a report on all the comments that the enrolled users have done in Enrollee Self-service conversation in a course. Is …Bobby Jourdan 1 view 2 comments 1 point Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Fixed Assets Mass Additions Subject AreaSummary: Fixed Assets Mass Additions Subject Area Content (required): Is there any subject area that provides information on Fixed Assets Mass Additions and/or any other… -
Create and Implement Certificate of Completion - Newsfeed UXContent HI all. It's been a pretty recurrent ask here, so i have put up a short document explaining how to do this in a NUX enabled environment. So please read carefully… -
Not able to view entire data in assignment and performance related subject areaSummary: I am using performance document status Real time/worker assignment real time subject areas but in the respective subject area I am able to see only my record. I…Kamini Kaushik-Oracle 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Identifying Lowest Level Tasks and Parent TasksSummary: Identifying Lowest Level Tasks and Parent Tasks via the Fusion UI, OTBI or Reporting Content (required): Is there a flag or marker in the Task Structure, or in … -
Fusion Self Service Procurement RolesSummary: What are the job roles that would be considered as Fusion Self Service Procurement cloud roles. I added Procurement Requestor role to a user but user can not se…Shivaji Muttarapu 41 views 3 comments 0 points Most recent by Maithily Kohale-Oracle Self Service Procurement -
Not able to view entire employees details in Subject area only able to view own recordSummary: I am using Assignment and performance related subject area to fetch details of employee but when I am using my subject area it is only displaying only my data. …Kamini Kaushik-Oracle 151 views 3 comments 2 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Reporting on Guided Learning UsageContent Hello, This might be a long shot, but our business is trying to report on how often employee's are using guided learning. Are there any tables that store the usa…User_2025-01-31-00-25-12-234 27 views 4 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Trying to create a calculated item using fields from two subject areasI have created a report using balances and calculation cards. The report will run and return data from both areas but when i try to create a new field using a formula th…Sharon Harper 21 views 1 comment 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Two initiatives - One with Expiry and the other one WithoutContent Hi there please share your experiences for the next case I have a course that is with Default assignment rules - Never Expires. I want to have two initiatives On…