OTBI
Discussion List
-
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 617 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 43 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 53 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 -
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 212 views 6 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Unable to hide prior incumbent details in position FTE reportSummary: Unable to hide prior incumbent details in position FTE report Content (required): Unable to hide prior incumbent details in position FTE report. Following scree…Manoj.Gupta 91 views 6 comments 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM