OTBI
Discussion List
-
Costing of Positions subject area in OTBI?Summary: We get requests from all of our customers in Academics and Healthcare for reports/ analysis that show position costing but we have to use BI Publisher since we …Darren Nelson 317 views 9 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to write filter for custom logic?Summary: I have a parameter Diverse, it has values ALL and Diverse. if user selects Diverse it should display the counts of diverse employee, if ALL selected all employe…Raghavendra M 91 views 14 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Report tabs on Learning admin dashboardSummary Report tabs on Learning admin dashboardContent Hi All I've noticed in a few Oracle videos, the Learning admin dashboard has a number of different tabs (see attac… -
DFF at Supplier Address not visible in OTBI report Subject AreasSummary: Content (required): Hi, I have created an OTBI report for Supplier Master details. I have defined few DFFs at supplier profile level, site level and at address … -
In need of a report that returns associates who had a change in their direct managerSummary: Have a need for a report that returns associates who have changed their direct manager Content (required): We have a need for a report (BIP or OTBI) that will i… -
Can't see absence reason in reports after putting end date inside the relevant absence typeSummary Can't see absence reason in reports after putting end date inside the relevant absence typeContent Hi, We have an issue that after putting the end date to an abs…Markovich Chen 33 views 3 comments 0 points Most recent by Jonny Varley Reporting and Analytics for HCM -
Number of invoices processed per FTE that performs the process “Process accounts payable (AP)”Summary: Number of invoices processed per FTE that performs the process “Process accounts payable (AP)” Content (required): We are making an attempt to calculate the per…SaurabhSinghal26 92 views 1 comment 0 points Most recent by SaurabhSinghal26 Payables, Payments & Cash Management
-
PRC - Unable to create Purchase Requisition with Destination Type as InventorySummary: Content (required): Hi, I am trying to create requisition with destination type as Inventory. But when I add item and click on cart system throws below error: "…
-
Inquiring logic used in one field of OTBI reportSummary: Need to know the logic used to calculate the field 'Years of service' Subject Area: Workforce Management - Work Relationship Real TIme Measurement Name: Years o…Jithin Mathews 41 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Getting line break and error while extracting the report.Summary: I have created one BI report using e-text template while extracting it , giving me error and line break refer the attached image. What could be the possible rea…Rajib_Samanta 41 views 3 comments 0 points Most recent by Rajib_Samanta Reporting and Analytics for HCM -
Can you use wildcards in a CASE statement?Summary: I have an analysis where if the Job Name is like 'abc%', '%hpr%', then I want to display certain text. Note that there are multiple wildcards, some only before,…
-
sum of 2 columns to be shown in 3rd column in OTBISummary: Hello, We are trying to sum 2 columns data and show it in 3rd column, however, it is not working. candidate-Job Applied + Candidate-Prospect = Total Referred Ca…Shiva Prasad M 121 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Add division parameter to OTBI reportSummary: I am trying to create an OTBI report under the expense report templates to show approvers of given POs. I am able to add fields for company, department, and acc…
-
Learning Count Using Disability StatusSummary: Using the Workforce Learning - Learning Records Real Time Subject Area to pick up disability (which is using Workforce Management - Person Real Time to count th… -
Length of Time in Job OTBISummary We have a reporting requirement where we need to capture the Length of Time in Job. Is it possible through OTBI?User_2025-01-25-03-18-49-935 97 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
What is the expnse items date field in OTBI for out of pocket expensesSummary: We are creating a report in OTBI for expenses. We are using Expense Transactions Real Time subject area. We want to pull the expense item date onto the report. …
-
Export to excel for an OTBI analysis in Guided JourneysSummary: We have deployed an OTBI analysis in Guided Journeys that would be most useful if the user could export it to excel. Is there a way to incorporate this feature …Amy Wilson 51 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to create a learning Analysis that is triggered by #of days past a certain date?Summary: Please, we're trying to understand if there is a capability with learning assignments (possibly via an OTBI analysis) to trigger certain learning based on an em…
-
How can I fix some columns in the Analysis report?Hi I created a report from analysis and set it to Fixed headers with scrolling content. But I have too many columns in my report, so I need to freeze 3-4 columns. How is…Cansel Karasoy 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Period Close-GLSummary Period Close-GLContent Is there a report that shows the day the GL period was closed.
-
Pre-Requisite of Course A Completion but Not Enrolled in/Completed for Course BSummary: I have a business requirement to set up an analysis report in the Assignment Analyses area, where the prerequisite of being able to enroll in Course B, is the c… -
Fetch users who have NOT logged in since past 30/60/90 days and send reminder emailSummary: Fetch users who have NOT logged in since past 30/60/90 days and send reminder email Content (required): I need to fetch list of users who have NOT logged in sin…Neelesh Varma 331 views 4 comments 0 points Most recent by Neelesh Varma Reporting and Analytics for HCM
-
Ability to track the number of times learner retook/reviewed an already completed learning itemSummary: Looking to create a report that gives the number of times a learner has reviewed or retaken an already completed learning item. Is this information recorded, an…KatHugh 41 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
Filter based on custom values in promptSummary: How to filter analysis based on custom values in prompt? Content (required): I have a variable prompt which has custom values like ALL, Female, Ethnicity etc. i…Raghavendra M 41 views 4 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM