OTBI
Discussion List
-
BI Reports are failing with error as Could not connect to OBI Presentation ServiceSummary: BI Reports are failing with error as Could not connect to OBI Presentation Service Content (please ensure you mask any confidential information): Hi Team, Greet…Parag Hiremath 43 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Total earnings inaccurate based on positions in Gross Earnings ReportI created an OTBI report include employees' 'Name', 'Position' and 'Gross earnings'. For prompt of time range, I use 'Pay period start date' and 'Pay period end date'. A…Yiming Xiong 13 views 4 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
How to display Active employees count month wiseSummary How to display Active employees count month wiseContent Is there any way on calculating employee count by month in OAC. The starting point is an Employees table …Saptadip 381 views 6 comments 1 point Most recent by Lakshmi Devi Bathala Reporting and Analytics for HCM
-
Position Grade Code and Position Grade Name not being populated in OTBIHi all, We have an issue that the Position Grade Code and Position Grade Name is not being populated in OTBI. The only field that is populated is "Valid Grades" and this…
-
Busting OTBI Myths - Reporting current and previous values side by sideContent Myth: You can't report current and previous values side by side One common example is reporting the current assignment values and the previous ones after an assi…Julian Challenger-Oracle 369 views 11 comments 5 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Copying OTBI reports in bulkSummary: Copying OTBI reports in bulk Content (please ensure you mask any confidential information): Hi Team, Greetings! There is a requirement to copy multiple OTBI Rep…Parag Hiremath 12 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Subject Area for Personal Payment Method DetailsSummary Subject Area for Personal Payment Method DetailsContent Hi All, Can any one please help me to find OTBI Subject area for personal payment method details. I have …nitin Sharma 202 views 13 comments 1 point Most recent by GopiKAutomus Reporting and Analytics for HCM
-
Absence Calendar Details Real Time - Reporting on employee absences by daySummary This is a white paper to enable the customers to generate and render worker absences breakdown by day using the absence calendar details real time subject area.C…Raghavendra Raghunath-Oracle 2.1K views 46 comments 13 points Most recent by gclampitt Reporting and Analytics for HCM -
OTBI Analysis, Payroll - Calculation Cards Real Time - PAE - How do I show each linked assignment?Summary: I'm trying to create an analysis to report on employee Calculation Cards using Payroll - Calculation Cards Real Time and in the case of employees with multiple …Julie Searles 65 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time"Summary: Unable to fetch the State, County and City values through "Payroll - Calculation Cards Real Time" subject area Content (please ensure you mask any confidential …
-
Is there a way we can use embedded reports for custom error messagesWe have a requirement to have an error message to validate entries in a standard field in Learning module. As far as we have checked, there are no autocomplete rules ava…
-
Opportunity Marketplace Out of the Box ReportingSummary: Opportunity Marketplace Out of the Box Reporting Content (please ensure you mask any confidential information): Are there any out of the box reporting for Oppor…
-
How to make bold font in a custom formulaSummary: Using subject area WFM Worker Assignment Real Time, field Worker/Address Line 4. Is there a way to modify this formula to show 'MISSING' in bold red text? CASE …
-
BI report does not open in android devicesWe have a third party payroll integration and we have a report so that payroll outputs can be pulled from self service. When this report is opened from the mobile applic…Ömer Vardar 35 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
I was trying to create a report to pull employees, excluding the managersHow to pull employees using OTBI and to exclude managers who are also an employee. please share ideas thanks.Joliver Caangay 22 views 2 comments 0 points Most recent by Joliver Caangay Reporting and Analytics for HCM
-
unable to get the assignment details for pending worker from checklist real time subject areaHello Team, while running the report from checklist real time subject area the orgainzation hierarchy levels are showing null and also all the attributes for assignment …Shivam Naugraiya 4 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Oracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportOracle query to get values on 9 box grid for a person in HCM fusion talent review meeting reportDeepeeka Nath 57 views 4 comments 0 points Most recent by Neno Kolonich Reporting and Analytics for HCM
-
Journey's comments section data is missing in OTBI reportJourney's comments section data is missing in OTBI report Step 1 - We have created a journey. Employee will be able to use the Journey. Employee is able to enter the com…Challa Ramya-Oracle 13 views 2 comments 0 points Most recent by Diana Mitrovski Reporting and Analytics for HCM
-
OTBI Analysis Columns displayed by prompt valuesHi Experts, We have a balance report that works well. However, we would like to display in it some context based assignment DFF's. We would like to keep 1 report for eac… -
Absence Calendar Direct Reports Current Month not returning any valueHi Experts, When we are running the report "Absence Calendar Direct Reports Current Month" from Line manager Dashboard, It is coming as empty. I have checked then backen…Nivya Mathire 85 views 8 comments 0 points Most recent by Gunasagar Thimmapuram-Oracle Reporting and Analytics for HCM -
Query to get all approval transactions pending with terminated line managersSummary: How to get all approval transactions pending with terminated line mangers. I need a query to get all details including approver's person number/username. Conten…Smitashree Pradhan 92 views 3 comments 0 points Most recent by Aditya Jena Reporting and Analytics for HCM
-
BI Publisher Report SQL Error : SQL or ORA exceptions caused due to invalide sql , database packageSummary: I've created a headcount report that combine all workforce informations based on per_all assignments, compensation data based on cmp_salary_v cmp_salary_v2... i…Ayoub AFRASS 826 views 5 comments 0 points Most recent by Juan Pablo Gonzales Reporting and Analytics for HCM -
OTBI analysis for consolidated manager viewSummary: I am creating a manager dashboard comprises of performance, goals, feedback, check-ins and performance booster report. We need to apply a filter for manager whi…Techie 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to convert RTF template file from LF to CRLFSummary: Convert file from LF to CRLF Content (please ensure you mask any confidential information): I would like to ask on how to use the CRLF in RTF Template. Is it li…MayCab 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Values being truncated at 240 characters in the non-Excel output formatsHow to address those values being truncated at 240 characters in the non-Excel output formats.Ronel M 7 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Transaction Console Subject AreaGood Day Experts, May I know what subject area to use to get processes from Transaction Console? The following are the process name: - Manage Salary - Change Personal In…
-
Payroll - Element Entries Real Time SA not returning car allowance Elements in the reportSummary: I have created an OTBI report with car allowance element entries for two Business units by using "Payroll - Element Entries Real time" subject area, each BU hav…Hitachi ServiceDesk 14 views 0 comments 0 points Started by Hitachi ServiceDesk Reporting and Analytics for HCM
-
How to use outer join in OTBI AnalysisContent Hi All, I am using Worker Assignment Real Time Subject area and i have to pull only the person who has home phone number . The person who don't have home phone n…User_2025-02-04-18-22-33-673 1.4K views 5 comments 1 point Most recent by RajaPalli Reporting and Analytics for HCM -
Employee displays in analysis for indirect leader they no longer report up toSummary: We've kicked off our workforce compensation cycle. I have an employee who changed managers earlier this year. The indirect manager they previously reported to i…Susan Anderson 21 views 2 comments 0 points Most recent by gclampitt Reporting and Analytics for HCM