OTBI
Discussion List
-
What roles needed to let custom HR Specialist Role able to open any report or analysis?Content What roles needed to let custom HR Specialist Role able to open any report or analysis? and what controls reports and analysis data security? BI consumer Role? B…Walid Hamdy 58 views 5 comments 0 points Most recent by Srinivas Pendyala-Oracle Reporting and Analytics for HCM -
OTBI Report showing multiple Parent Position Codes for a recordSummary Display the current parent position code in the OTBI analysisContent I have an OTBI analysis that is using Workforce Management - Worker Assignment Real Time and…User_2025-02-04-08-51-08-912 35 views 8 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Number of days a requisition is suspendedSummary Asking if it is possible to calculate the number of days a requisition is suspended (regardless of the number of times it is suspended) in OTBIContent Hello ever…Tom John Bontoyan 58 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
Benefit Eligibility CriteriaContent Hi All, When we click on the Eligibility profile able to see View hierarchy and Eligibility criteria. Can you please share inputs in which Table/OTBi subjetc are… -
Personal Payment MethodSummary Is it possible to report on personal payment method when this is blankContent Hi, please can someone confirm if it is possible to identify in a OTBI report when …Helen Tilling 138 views 4 comments 0 points Most recent by User_2025-02-08-06-26-45-662 Reporting and Analytics for HCM -
OTBI - Learning ILT Activity classroom - Can anyone find the field in OTBI?Content Hello, We are trying to pull together a custom report on the details of the upcoming offerings and activities for an instructor. One of the fields that we cannot… -
Conditional format image - The file type is invalid, only .png .jpeg .jpg .gif and .bmp files are suContent I am trying to add a image if a condition holds true but I am getting this error message trying to upload an image. I confirmed the image format I am trying to u…User_2025-02-10-08-27-16-805 11 views 6 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
HDL - Element Entry IDContent Hello, I'm trying to update recurring element entries but am not sure where to find the ElementEntryID so that we can refer the HDL to a specific element entry. … -
Report that capture ad-hoc paymentsContent We have a requirement for a report that capture all ad-hoc payments. I am not able to find ad-hoch payment information in any seeded report nor is it possible to…Stefan pettersson 27 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Payables, Payments & Cash Management -
How to calculate the total cost of a ProjectSummary How to calculate the total cost of a ProjectContent In calculating the cost of a Project, I normally used the Committed and Projects Cost. Is this the best optio… -
Account Reference InformationSummary Provide account reference to customers requesting on accounts looking to add businessContent We have customers on a regular basis coming to us asking for referen…User_J9K1Y 51 views 1 comment 0 points Most recent by User_2025-02-05-00-10-05-674 Receivables & Collections -
How to Embed a BIP Report with Prompts on a DashboardSummary How to Embed a BIP Report with Prompts on a DashboardContent Hi All, I have an existing custom Missing Time Cards report which is built using a custom SQL refere…Vinay Soni 242 views 4 comments 0 points Most recent by Anil Kola-Oracle Reporting and Analytics for HCM -
Data Model for HR Service RequestsSummary looking to report on HR Service Request dataContent Hi, we've recently started using the 'HR Service Request' facility. Was wondering if anyone had built a data …David McLellan 42 views 4 comments 0 points Most recent by David McLellan Reporting and Analytics for HCM -
Individual prompts for two analysis on a dashboardContent Hello, I've been working on a dashboard where we need to have two analysis. There is one column which I wanted to use as prompt individually for each analysis. I…Praneeth K-261878 19 views 6 comments 0 points Most recent by Praneeth K-261878 Reporting and Analytics for HCM -
Calculating Difference from Headcount factContent I am trying to calculate difference between Headcount (Fact from Assignment Real Time) by work location and the number of employees that uploaded a document type…Riti Malhotra 38 views 5 comments 0 points Most recent by Riti Malhotra Reporting and Analytics for HCM -
How to find failed transaction on a person numberTSummary Transaction console failed transaction columnContent Which column will store the failed transaction status. How to find failed transaction on a person numberKammarapalli Venkatesh-Oracle 20 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Did You Know: Drill Down to Fusion PPM and Grants Applications from OTBI ReportsSummary Provides step-by-step instructions to define OTBI reports that use deep links to drill down to details in Fusion PPM and Grants Applications. Content Oracle Tran…Bob Sheldon - Oracle-Oracle 165 views 0 comments 5 points Most recent by Bob Sheldon - Oracle-Oracle Project Management -
OTBI Analysis with EIT fieldsSummary Need to display current Parent Position Code for the record but EIT causing duplicationContent HI all, I need some help with an Analysis - I have paired the anal…User_2025-02-04-08-51-08-912 161 views 4 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM -
Withholding Tax ExemptionSummary Withholding Tax ExemptionContent Withholding Tax Exemption is setup for period Jan-20- Mar-21. When entering an invoice is it the Invoice date that the system us… -
OTBI > Subject Area for Employees Assigned Work ScheduleContent Hello All, I will appreciate your support in the following issue: We have defined different Work Schedules which are assigned to different population based on sp… -
Out of control sessions since upgradeSummary SessionsContent We're mid-upgrade and while investigating performance in reporting I noticed that we have an unreasonable amount of active sessions. We have +400… -
Trend Lines in OTBI ChartsContent Hello, Is it possible to add trend lines to an OTBI bar graph? We are creating a dashboard for HRHD and want to add a trend line on top for number of cases. I've…User_2025-01-31-00-25-12-234 84 views 10 comments 1 point Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Vertical display of text in titleContent We built a 9-Box using performance tiles and would like to display labels against the Performance boxes. Is that feasible? Thank you!User_2025-02-10-08-27-16-805 22 views 9 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to report on req lines creation (catalog, smart form, non catalog request)Content Does OTBI allow for the ability to create a report which would allow procurement personnel to see/summarize requisition lines by how they were created (catalog, … -
Publish Data from UI: the column sequence keeps changingSummary Users are using publish data functionality from Dm/SOP Cloud. Once they add a new column, the column sequence changes in the output file.Content Hi All, Our user…Ankur Bhatia 48 views 5 comments 0 points Most recent by Ankur Bhatia Supply Chain Planning and Collaboration -
ORC Candidate Diversity - SummarySummary Getting to one row per job requisition?Content I've created an analysis that uses the delivered counts of applications, veterans, gender, and disability status t…User_2025-02-10-15-34-12-310 146 views 2 comments 0 points Most recent by User_2025-02-10-15-34-12-310 Reporting and Analytics for HCM -
Adding Action link on Performance Document Created vs Not createdSummary Adding Action link on Performance Document Created vs Not created Content Hi, We have requirement to add an action link and display the employee populations in t…Prabhu Krishnamoorthy 30 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Intercompany (AGIS) AutomationContent Basically current steps : 1. When AP capture Invoice in Entity A with Entity B Interco chargeback dimension (last 3 digits) 2. Interco Module : Interco Team will… -
How to calculate time from different eventsSummary Calculate time difference between different phases (events) in a recruitment processContent Hi, I´m trying to create a report where I can report on the different…Even Kjorsvik-Oracle 41 views 1 comment 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM