OTBI
Discussion List
-
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 91 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
-
How to run REST API to update invoice payment method ?Summary: How to run REST API to update invoice payment method ? Content (required): Hello There are more than 3,000 invoices with a wrong payment method hence I was wond…Cesar Saveedra 631 views 7 comments 0 points Most recent by Swapnil Kashid Payables, Payments & Cash Management
-
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 123 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 333 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 43 views 4 comments 0 points Most recent by Raghavendra M Reporting and Analytics for HCM -
GETTING ERROR WHEN USING TWO SUBJECT AREASummary: I HAVE ONE SUBJECT AREA "Procurement - Procure To Pay Real Time'' I SELE CT PO NUMBER , CREATION DATE , CLOSED DATE, AND FROM ANTHOR SUBJECT AREA ''Procurement …
-
Report on total number of direct and indirect reports by managerSummary How can I sum distinct direct and indirect reports by manager?Content Hi - I'm having a hard time figuring out how to sum direct and indirect report total counts…Julia SRI International 471 views 9 comments 0 points Most recent by RamyaK Reporting and Analytics for HCM
-
How do I create a learning category headcount report?Summary: I am having to create new reports for the new Learning Subject Area (Workforce Learning - Learning Records Real Time) due to the Learning Management Subject Are…
-
Report on Salary Change Action and ReasonSummary I'm looking to report on Action and Reason within Manage SalaryContent Using the Compensation - Salary Details Real Time subject area I'm able to pull Action and…User_2025-01-25-00-37-41-739 211 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM