OTBI
Discussion List
-
OTBI Comparison between two tables with the same fields in one tableHello! I would need some help with this idea of an analysis. The idea would be to make a comparison in a single table of two different tables with the same fields. Somet… -
Absence calendar inc work patternSummary: Is it possible to report on work patterns/worker availability in OTBI Content (please ensure you mask any confidential information): Hello With the ability for …Helen Thomas 24 views 2 comments 0 points Most recent by Helen Thomas Reporting and Analytics for HCM
-
How to schedule an OTBI report using agent if the report has two dates as prompt?Summary When we schedule this OTBI report with agent, it pulls all data which are not in the range of default valuesContent We have an OTBI report which has "from date" …Linda Huang 377 views 7 comments 0 points Most recent by Sushant95-Oracle Reporting and Analytics for HCM
-
Headcount and Termination # for Turnover and ESG reportHi there, We are looking for the columns in subject area to display precise headcount and termination number for Turnover and ESG reports. Below are other numbers which …Yiming Xiong 13 views 2 comments 0 points Most recent by Yiming Xiong Reporting and Analytics for HCM
-
BI Publisher : I need to create a report to track the changes on employement for my employeesSummary: I need to create a report to track the changes on employement for my employees with situation before the action and action reason and the situation after the ac…Ayoub AFRASS 24 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM -
Maryellen_Gancena 12 views 3 comments 0 points Most recent by Maryellen_Gancena Reporting and Analytics for HCM
-
Audit Document Records AccessContent Hi experts - hoping you can help with an OTBI or BIP audit report. I have the tables needed to run a report on what documents exist in the Document Records secti…Prudence K 118 views 11 comments 0 points Most recent by Malla Pratibha Reporting and Analytics for HCM -
-
While scheduling a OTBI report, run time parameters are not coming up in General TabSummary While scheduling a OTBI report, run time parameters are not coming up in General TabContent Hi Team, When i tried to schedule a report using OTBI, there are run …Harish Kumar Kovi 75 views 12 comments 1 point Most recent by Phani S-Oracle Reporting and Analytics for HCM
-
Primary Beneficiary DetailsSummary: I need to create an OTBI analysis for to get details about one benefit plan including primary beneficiary details. I used the Benefit- Enrollment Real time subj…Ayesha Iroshani 33 views 4 comments 0 points Most recent by Mahesh Sharma Reporting and Analytics for HCM
-
Original Referral SourceSummary: How can we show the original referral source from the candidate's general profile? Content (required): If an employee refers a candidate for the first time the …
-
Alert (Bell) Notifications to Line Manager from OTBISummary Alert (Bell) Notifications to Line Manager from OTBIContent I have a requirement where i need to send a notification as well as an email to a line manager when t…Mansur Khalil 139 views 7 comments 0 points Most recent by User_ZICBC Reporting and Analytics for HCM -
Termination report pulling last compensation of hourly associates but not salaried associatesSummary: Term report pulling last salary of hourly associates but not salaried associates Content (please ensure you mask any confidential information): Hi! I am in need…Ameya_J 24 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Payroll Results with Details NeededDoes anyone have a query or XLM for a payroll results report that provides the hours and amount by pay element along with the specific pay rate for each element? We are … -
Historical Benefits Enrollment DataHi I am looking to see if anyone has a report showing historical benefits data by employee (both active and inactive) . Something that will show me all plan election det…
-
Diversity Report - multiple linesSummary How to report on the latest entry?Content Hi, The report attached works for me apart from 8 employees that are appearing with multiple lines of data. I've spoken…User_2025-02-05-22-44-35-842 126 views 28 comments 1 point Most recent by Cindy Hager Reporting and Analytics for HCM -
In OTBI-Whr to find the Approval Pending with /submitted by/submitted date info in job RequisitionSummary: I am trying to create a pending Job requisition OTBI report, in the subject area Recruiting - Recruiting real time with the requirement in adding information re…Sankaran Lakshminarayanan 1 view 1 comment 1 point Most recent by Sankaran Lakshminarayanan Reporting and Analytics for HCM
-
How to remove these many duplicates of Child Role columnDear Experts, The Below query producing duplicates. Could you please help out me. Query: ============================================================================== S…
-
Null row is occurring in OTBI because of Case statementI am facing some strange issue where null row is getting when i had use case statement one of the attribute as we have multiple phone types and for one of the employee h…
-
Query to find the email recipients of the scheduled BI ReportsSummary: Hi, Is there any Query to find the recipients of the BI Scheduled Report using Job. If I knew the Report name, I can get this details by Jobs History -> Edit . …Faqir 226 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Keri N 2 views 2 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
OTBI Formula HelpHi all looking for help on a formula for an OTBI Analysis on terminated records similar to the MS Excel formula of IF Action Reason EQUALS "Entity Transfer" or "Continge…
-
Transaction ID is missing Human Capital Management - Approval Notification Archive Real TimeSummary: We are trying to develop a report with below two subject area Workforce Management - Worker Assignment Event Real Time and Human Capital Management - Approval N…
-
Darrin N 3 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I create multiple records in a single payload from Postman?Hi, I can create them one by one as follows, but I get the following error when creating more than one record in a single payload. Can you correct my mistake? Thanks { "…Cansel Karasoy 11 views 2 comments 0 points Most recent by Bianca Culea-Oracle Reporting and Analytics for HCM -
All Active employees that receives no pay or $0 gross pay for any pay periodSummary: There is a requirement where client need a report having list employees receiving no pay or 0$ Gross pay based on previous 26 pay periods. We have a bi-weekly P…Rahul Saini 21 views 1 comment 0 points Most recent by Anca Andronic-Oracle Payroll and Global Payroll Interface (GPI)
-
unable to access data from Compensation- Salary Details Real time with custom roleWe have created an OTBI report using Compensation - Salary Details Real Time. We have created a custom Role for Human Resource Analyst. With this role we are unable to a…
-
Query that fetch Calendar Events and LocationSummary: I need a query to link Locations and Calendar Events, but I couldn't figure how to do it. Anyone have any query like these? So far I've accomplish this one but …Matheus Roberto 252 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Parag Hiremath 2 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Any report or query to get Error subprocesses from the payroll flowSummary: Any report or query to get Error subprocesses from the payroll flow Content (please ensure you mask any confidential information): Hi Team, Greetings! When a pa…Parag Hiremath 24 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM