OTBI
Discussion List
-
Offer ID not showing up on Recruiting Real Time Subject AreaSummary: Offers created under a requisition, but Offer IDs not showing up on the backend Recruiting Real Time subject area. Content (required): For a particular requisit…User_2025-07-18-13-29-11-469 71 views 8 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Fetching column for employee Feedback(in PD) whether it is completed/bypassed in OTBI reportsSummary: I have a requirement to add one column in OTBI report to fetch the status of employee feedback if is completed or bypassed. Can we use SQL query to fetch the de…Kamini Kaushik-Oracle 11 views 2 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Reporting on Eligible for Pretax Age Catch-Up Contributions FieldSummary: Looking to include the column Eligible for Pretax Age Catch-Up Contributions in a payroll report to pull all data assigned to a person's Reporting Information c…Emily Meyer 31 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Certification link is not working after implementing Redwood.Summary: We just realized that learners cannot access the course completion certificate when they complete the training. Content (required): When learners complete the t… -
Org levels missing from the OTBI report for the inactive treeWe recently did our restructures and created a new version of the tree. The old version end on 2-Jul and the new version starts from the 3-Jul. Now the Org tree has leve…Girish Bhatia 42 views 7 comments 0 points Most recent by Girish Bhatia Reporting and Analytics for HCM -
Issue with Logical SQLSummary: Hi, I was working with a Report which will provide various employee emails like home email and business email addresses along with few other assignment details.… -
How to receive description of EFFs' LOVSummary: Hello Experts, We have created a report to see the item attributes. For a case we need to see the description of the value. Do you know in which table the value…
-
How to return Geographies using OTBISummary: We want to return Geographies (State, County and City) using OTBI. But the data should not return the geocodes but should return the actual name. Ex: State: LA …RenzelkeithCoquia 1 view 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
How do I remove unwanted commas in OTBI report outputSummary: Custom address field column contains extra columns when source column is null Content (please ensure you mask any confidential information): I have created an O…DennisOliver 31 views 5 comments 0 points Most recent by DennisOliver Reporting and Analytics for HCM -
Display Source warehouse information during Item entry in the sales orderSummary: Hi Folks We would like to see the source warehouse along with On-hand information during item entry in the sales order Content (please ensure you mask any confi…
-
HCM native datamodels/bipSummary: are there another schema.table wich sample reports delivered in HCM Cloud are stored to extract a list of them ?? Content (please ensure you mask any confidenti…
-
Formula to calculate Learning Assignment Creation Date + 7 Days in OTBISummary: Hi, I am trying to create an assignment analysis that will assign a course based on the Assignment on Date + seven calendar days. Can you please suggest if it i…
-
How to filter the column values by another column?Summary: I'm currently creating an OTBI report under this Subject Area: Workforce Management - Checklist Real Time I want to filter employees which have these Response A… -
Facing issue with top manager type in OTBIWe have created otbi report using top manager type. Multiple managers are visible in OTBI, but in system only 1 manager is tagged. Is there any way we can pick the activ…Pranay_Soma 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Coding Conditional Formatting into LSQL?Summary: Logical SQL Conditional Formatting OTBI Content (please ensure you mask any confidential information): Hi All, When building a report in LSQL - I apply the SQL …William_Johnson 21 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Release 13 - Annoyingly hidden folders menuContent Hello, Since R13 the Reports and Analytics page has changed, and annoyingly the folders are hidden and have to click an icon to view them, when they load they do… -
How to create a record in the position flexible field from postman with Oracle Rest API?Hi, I want to send a record to the flexible field opened on the position with the help of Oracle standard rest APIs. But when I examine the oracle document, I cannot see…Cansel Karasoy 31 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Budget vs. Actual Cost Comparison by Business Unit with sql errorSummary: unable to execute Budget vs. Actual Cost Comparison by Business Unit with the error Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY…
-
How to use event triggers to send a reportI created a report in OTBI that returns urgent requisitions that were not processed by the buyer, but I would like to send this report to the buyer when an urgent line r…Mateus Henrique Fetzner 21 views 1 comment 0 points Most recent by Mateus Henrique Fetzner Reporting & Analytics for Fusion Service -
To pull Open Enrollment Benefit data if life event closed and Employee Enrollment not yet submittedSummary: To pull Open Enrollment Benefit data if life event closed and Employee enrollment not yet submitted Content (required): We are looking SQL query/OTBI report to …
-
How to Calculate the outstanding balance based on the parameter for receivables invoice in OTBISummary: How to Calculate the outstanding balance based on the parameter for receivables invoice in OTBI Content (required): For example, if invoice is paid in October m…Harshil Tolia 271 views 1 comment 0 points Most recent by Andreea Laura Panait-Oracle Receivables & Collections
-
Display multiple emails/phones on one row when there ae multiple records of the same typeSummary Multiple emails/phones with multiple recordsContent Hi All, I have built my query for displaying employee information with their different emails and different p…User_2025-02-04-08-51-08-912 35 views 2 comments 0 points Most recent by Kuldeep Gawali Reporting and Analytics for HCM -
What are tables and views that are storing Pricing Service Mapping?Summary: i need to know which tables or views are storrring the data cerated in the manage service mappings task Content (please ensure you mask any confidential informa… -
Workforce Management - Worker Assignment Event Real Time - Assignment FTESummary: We want to achieve below requirement using OTBI. Can we get FTE and leaving reason from the same SA or need to join other SA to get the data ? Can we get Assign…Jatin_Maru_1 33 views 2 comments 0 points Most recent by Jatin_Maru_1 Reporting and Analytics for HCM