OTBI
Discussion List
-
Benefits Enrollment Real Time Subject Area not pulling for future dated enrollmentsSummary: Hi All! We just completed Open Enrollment and tried running a report based on the above Subject area and we are only able to pull current year. Is this how the …Tristan Aquino 43 views 8 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
Report to pull goals not createdSummary: Can any one please send me the query or analysis to pull the employees who not created goals. Content (required): Version (include the version you are using, if…Reddykrishna 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Hourly Rate FormulaSummary: I have a report using the subject area Compensation – Salary Details Real Time and need to add a formula that calculates a base hourly rate. Here is what I'm lo…JHaden3 114 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to find and report on duplicate socialsSummary: I have a requirement for an analyses report that identifies duplicate social records. When duplicates are found, the report detail will include Person Number, P…
-
How to link Action and Action Reason to a BPM Worklist taskSummary: Hi. We can create a BIP where we have the BPM Worklist tasks but we would like to have Action and Action Reason included in that report so we can see what Actio…Jesper Majgaard Jakobsen 12 views 0 comments 0 points Started by Jesper Majgaard Jakobsen Reporting and Analytics for HCM
-
Unable to extract OTBI Italian Collective agreements information for WorkersSummary: Content (required): Hi team, We are unable to extract standard fields on contracts for Italian Employees related to collective Agreements with OTBI. Do you have…Gabriele Falso-Oracle 12 views 9 comments 0 points Most recent by Gabriele Falso-Oracle Reporting and Analytics for HCM -
Date Match Formula ErrorSummary: Date match formula errors when I run the report. CASE WHEN "Work Relationship Details"."PER_PPS_LEG_DDF_ST_BS_SR_STRT_T_" = "Workforce Management - Worker Assig…
-
Benefits | Added or Removed Dependents ReportSummary: Hi All! Does anyone have an example report that shows added or removed dependents? Content (required): We would like to audit our benefits to see if employees h…Tristan Aquino 12 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Report to show Employees Not Paid in the Last 6 MonthsSummary: I am trying to work out Casual employees that have not been paid in the last 6 months. I can get employees that were paid over 6 months ago, but this also shows… -
OTBI Report Performance IssueSummary: OTBI Report Performance Issue Content (required): Hi Team, We have developed the turnover dashboard using "Workforce Management - Workforce Trend Real Time" sub…Vasanthakumar Ravi 78 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
OTBI Agent Email From, Reply-to, CCSummary OTBI Agent Email From, Reply-to, CCContent Hi all: Using an Agent, is it possible to alter the "From" email address and add "CC" and "BCC" email addresses? The c…User_2025-02-04-23-32-05-891 140 views 7 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Turnover -Month on MonthSummary: I am looking for calculating turnover 12 months from a certain date month by month. But I want the period start date to remain the same as the start month of th…
-
OTBI filter to compare two attributesHello, We're building an OTBI Analysis that compares, for each employee, the competency’s rating given by his/her line manager in a Performance Document and the minimum …gguittini 62 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
HCM Reporting Only Role - Both BI and OTBISummary: Hi Guys, Anyone has any idea how to go about creating a Reporting Role for Applications Internal Team for adhoc BI & OTBI reporting . Is there a delivered role …AshishERPCloud 31 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
OTBI report to sum element Medical ER rate for calendar year where payroll isn't processed in OracleSummary: Looking for OTBI report to sum element Medical ER rate for calendar year per employee where payroll isn't processed within Oracle for W2. Or if someone has a da…Becki Willard 23 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Most recent salary record (Active and Termed)Summary: I have a report using the subject area Compensation – Salary History Details Real Time. I need the report to display only the most recent salary record for both…
-
Need inputs to display Dependent and other information side by side in OTBISummary: Need inputs to display Dependent and other information side by side in OTBI Content (required): We developed Benefit OTBI report. Currently if an employee is ha…
-
Voluntory Turnover ( Full Time Equivalent) - Workforce Management - Workforce Trend Real TimeSummary: I need to understund in the subject area the calculation rules applicated for the turnover Content (required): in order to create a monthly report on Voluntary …Ayoub AFRASS 23 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI Reports of ORC - Job Requisitions not open yet - Field Status come filtered and only show opeSummary I´m trying to create a report to list all job requisition that are in a phase before been publish or open to publish. But whe I add Phase field from phase histor…Christian_Kaladjian-Oracle 42 views 6 comments 0 points Most recent by Bounmy Reporting and Analytics for HCM -
Need to report on how long is it taking for managers to approve their tasks in a particular workflowSummary: We need a report from the workflow side of things to give us insight into how much is each manager taking to approve their tasks. Content (required): This is a …
-
Recruiting -Recruiting real time report relatedSummary: I have created two reports to fetch candidate details using Recruiting -Recruiting real time . I am getting duplicate data how I can restrict it , Also in one o…Rajib_Samanta 42 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to link Allocated tasks with questionnairesSummary: hello everyone, In order to create a report on the offboarding /exit interviews i need to link the allocated tasks with the questionnaires to get the allocated …Ayoub AFRASS 57 views 1 comment 0 points Most recent by Rambabu Laveti-Oracle Reporting and Analytics for HCM
-
Learn Overdue CountSummary: I am trying to pull a report for Learners having more than 5 or more training overdue. So I created one report to get the count and the other report to pull the…Anita 21 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Report or Query of all active report agents?We are hoping to pull a report of all active report agents to determine recipients. We are able to look at agents that are saved in the shared folders, but the concern i…Jenna Fuchs 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Ability to resize Dashboard on a pageSummary: Hi - my organization is currently working on implementing Oracle Learning and I was playing around with the Administrator Dashboard: The goal was to see if we c…
-
Report on names of attachments attached to Document Record TypeSummary: Is it possible to generate a report which lists all names of attachments attached to the document type? Do not need to be able to download the file just want to…
-
W_2 document delivery preference reportSummary W_2 document delivery preference reportContent Hi All, Recently we enabled W_2 consent functionality enabled. Is there any seeded report to get the details that …Peoplesoft 41 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Need Employee wise data where Checklist Response Text and Response answer in same row using OTBITrying to create an OTBI report from a survey which consists of both Response answer type and Text answer type questions. The report should show employee details, checkl…
-
Report for AgentsSummary Build a report about all our existing agentsContent Hi, Does anyone know if I can create a report that will present all our agents - Agent name, the content of t…