Get Started with Redwood: Oracle Cloud SCM and Purchasing
OTBI
Discussion List
-
Performance Managment Document ReportingSummary: I need to know how to pull Section Comments made on Performance Goals, in the Performance Document. These are the Goals that are pulled into the the Performance… -
OTBI Report data issueSummary: OTBI Report data issue Content (please ensure you mask any confidential information): Hi All, We developed OTBI report with Workforce Management - Worker Assign…
-
Can you use "prompted based on results of another analysis" when using presentation variables?Summary: Essentially we need to find the delta/ difference between two analyses that are date tracked to different points in time in the Prefix of the OTBI Analysis usin…
-
OTBI - add a graph to show the number of candidates by locationSummary: I've created an analysis using Recruiting - Recruiting Real Time Subject area and have been trying to add a graph to show the number of candidates by location, … -
When the employee open a report we need to send one email to same employeeSummary: When the employee open a report we need to send one email to same employee Content (please ensure you mask any confidential information): Hi Team, We have a req…
-
Generate an OTBI or BI report that notes mileage or kilometer distance from home zip to work locatioSummary OTBI or BI Publisher SQLContent Does any one know of a way to get, for each Employee, the distance in miles or kilometers from the worker's home zip to work loca…User_2025-01-28-21-53-32-678 47 views 2 comments 2 points Most recent by Sonia Canumay Reporting and Analytics for HCM -
Getting Style Error when exporting OTBI reportSummary: Content (please ensure you mask any confidential information): Hi there, I get this error when exporting a learning report from the Learning Records Real time s…Bobby Jourdan 12 views 4 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
Columns Missing from the Subject Areas in OTBIwe have 3 OTBI reports showing error in the output, when i checked, some of the column headings are in the report like 1.Deduction Developer DF_QUALIFYING_PEN_SCHEME 2.D…Global Support Desk 20 views 3 comments 0 points Most recent by Global Support Desk Reporting and Analytics for HCM
-
OTBI - Filter Learning records per year and not between two datesSummary: Content (please ensure you mask any confidential information): Hi there, we have a simple learning dashboard with learning completions of employees. My colleagu…Bobby Jourdan 11 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM
-
HIDE THE FACTORY CATALOG FOLDERSContent Hi We are in 19D and we have removed one of the role which is(Extension Folder Reporting Duty) from Custom BI Webcat Reporting Duty to hide the Extension folder …
-
Where can I find tax registration Number for Reporting UnitSummary: Please can anyone tell me where the tax registration number is in OTBI, I am wanting to add it to a report but cannot find it. Content (required): I am looking …Sharon Harper 71 views 6 comments 0 points Most recent by Lauriane Massin Whitaker Reporting and Analytics for HCM
-
Transactions Tables are not storing Data for few TransactionsSummary: Hi Team, I am trying to fetch the transaction details for Time Change Request Approval. But I have encountered that there two tables that were not storing any d…Dasari Dileep 266 views 5 comments 0 points Most recent by kanchana venkatasubramanian Reporting and Analytics for HCM
-
How to add values from column to Dynamic column in OTBIHi All, We have a requirement, to add one column values (Answer) to Dynamic columns (Question). Please see the below screenshot to clearly understand the requirement. We…Chaitra Lakshmi Krishna 41 views 3 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM
-
Convert Fact columns into Measure type in OTBI to get subtotalSummary: Hello, We are building a basic report and we try to view total for Total, Taxable Monthly, Non Tax Monthly etc based on Accounting Date. The issue is that all t…Raluca Balan-Oracle 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Licenses & Certs appearing on OTBI report but not seen in systemSummary: We are seeing a few different scenarios where our OTBI report is pulling in active (not expired) Content Items for employees, but we're not seeing them represen…Jessica D 61 views 5 comments 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
Report on Messages sent to Candidates using a message templateSummary: Content (required): I'm looking to report on Email messages sent to candidates who've submitted a job application. Any thoughts on which subject area/dimension …Susan Anderson 58 views 4 comments 0 points Most recent by Lee Charleton Reporting and Analytics for HCM -
OTBI - Performance Subject area & field to pull Evaluation Topics, Perfomance and Core Value ratingsSummary: We need a report that pulls the manager ratings and comments from the Evaluation Topics section for the performance and core values. Content (please ensure you … -
Issue with the candidates merged record getting pulled into the OTBI reportSummary: We have built an OTBI candidate report to pull candidates in certain phases and states, we are excluding rejected by employer and withdrawn by candidate. We hav…
-
BIP Reports Metadata tablesSummary need Metadata tables for BIP reportsContent I am looking for the fusion table(s) that store metadata of reports (such as created by and timestamps). can someone … -
Link between OTL time Entries with Element Entries or Calculation cardsContent Hi All, We enter data in OTL and transfer batch. Then calculation cards and Element entries will be created. We need SQL Query/OTBI link between OTL time entries…
-
Task Performer name in Workforce Management - Checklist Real Time is blank in OTBISummary: Task Performer name in Workforce Management - Checklist Real Time is blank in OTBI Content (please ensure you mask any confidential information): If the Task pe…AvinashP 24 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dies anyone know the table and field for "Enrollment Type Description" in OBTI Learning?Summary: Does anyone know is what the table and field that correspond to "Enrollment Type Description" and/or "Enrollment Type" in OBTI. Specifically under "Workforce Le…
-
Succession Plan ReportHow to view All Private succession plan available in system in OTBI ?prags 61 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Tip on how to remove the dashboard header when embedding in a screenSummary Tip on how to remove the dashboard header when embedding a dashboard into a custom pageContent I have been asked a few times recently if it is possible to embed …Caroline Gladwin-Oracle 346 views 7 comments 10 points Most recent by Aishwarya_15 Reporting and Analytics for HCM -
BIP Report schedule to send data only when it has dataSummary: I want to schedule a BIP Report daily but it only send the report if there is a data in the report. If the report does not have any data, it will skip. Content …Haikal Hamdan 21 views 3 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Matrix Manager HDL Load shows new manager in UI but not in OTBISummary: We completed an HDSL load of new Matrix Manager assignments for employees. The UI shows the new manager but the OTBI report does not. Reflect the update. Is the…
-
Converting to dateSummary: We have hire date and we are using this to create a two new columns called 'Current Year Anniversary Date' and 'Days to Anniversary Date'. It used to work earli…Simranjeet Singh 32 views 2 comments 0 points Most recent by Simranjeet Singh Reporting and Analytics for HCM
-
Position History ReportingSummary Is it possible to report on changes to positions themselves over a period of timeContent I have a requirement to report on historical changes to positions in OTB…Jo Kelly 215 views 4 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculate FTE and headcount automatically filed nameSummary: Calculate FTE and headcount automatically filed name Content (please ensure you mask any confidential information): In the "Change Assignment" UI, we have "Calc…Visu 23 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Human Capital Management
-
How to Join the AoR (Area of Responsibity) table columns in OTBI logical SQLContent Hello All, As per my knowledge and got the information from other resources, OTBI does not currently support Areas of Responsibility (AoR) and there is no any su…Janardhana K 179 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM