Reports
Discussion List
-
Reflect one row when there are duplicate rows of dataSummary: Request received to have report with multiple rows of data for workers to reflect one row for each worker, but still include all data. Hopefully the screenshot …Jessica D 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to format thousands with a space in an rtf template for HCM compensation change statements?Summary: How to format thousands with a space in an rtf template for HCM compensation change statements? Content (required): Hello, We are customizing compensation lette…Trisha Bucktawor 95 views 1 comment 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPSummary Help -> Audit/field Change Reports (Old Value -> New Value) - OTBI or BIPContent Hello, Looking for a quick help, please. Searched the archives but could not fin…SantoshKumarBhairi 194 views 12 comments 0 points Most recent by Ninja Reporting and Analytics for HCM -
how can we go with below requirement in OTBI between 2022-23 data of absenceSummary: Hi Team, we have requirement in between 2022-23 data for absence accural balance for annual leave , enchased and lapsed. by using accural real time subject area…AjayKumar Maddipati 22 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
New tab on the home page of Oracle HCM (Me | My team | My client Group | My reporting) - languageSummary: New tab on the home page of Oracle HCM (Me | My team | My client Group | My reporting) - text depending on language Content (required): Hello, I am creating a n…Jacqueline GRANDIN 102 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Assignment Changes including Effective SequenceSummary: Hi - I have a logical SQL built that is looking for changes in a DFF field that do not take place on a Sunday. It is supposed to capture the changes between row…
-
Pivot table column blankSummary: Content (required): Hi, I've created an OTBI report using the Workforce Performance - Performance Rating Real Time subject area, with a Pivot for the Manager Ra…Joe Dorrian 22 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Grade step start date per employeeSummary: Content (required): Hi, would anyone be able to point me in the right direction for creating a report that tells me how long each employee has been at their cur…Leanne W 11 views 4 comments 0 points Most recent by Kathi Chenoweth-Oracle Reporting and Analytics for HCM
-
Security views for disciplinary and grievances reportSummary: Security views for disciplinary and grievances report Content (required): Hi All, Is there any secured views available for disciplinary and grievances report? I…Venkatesan 2 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Mid Year Check In ReportSummary: Hi All, We have a requirement to fetch both the employee's & manager's responses to the questions for the 2022 Mid-Year Check In. Looking for a report which cov…Peeyush Chandel 41 views 4 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM -
How can I pull all reports and their permissions available /shared folder/custom/ pathSummary: How can I pull all the reports available in "/Shared folder/Custom/" path with their permissions through backend(sql) or any other alternate, with environment h…Nidhi S 326 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Assignment EFF Rest APII am trying to query from postman with the relevant platform_id information using Assignment eff rest api,(/hcmRestApi/resources/11.13.18.05/emps/{empsUniqID}/child/assi…Cansel Karasoy 12 views 1 comment 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM -
calculate the past experience in HCM BI ReportSummary: calculate the past experience in HCM BI Report Content (required): My client requirement is to calculate the past experience and current organization experience…
-
Measurement to sum Actua Effort for yeach years starting from Current_DateDears, i've been trying to create performance tiles based on following measurements so to have sum of actual effort for the last 3 years splitted by years: Sum of Actual…
-
Cannot Modify Chart Properties on BI Publisher for WordSummary: I am trying to edit an rtf document using BI Publisher for Word to increase the size of the chart and the font. When double clicking on the graph/chart to displ…Johnna Balane 123 views 3 comments 0 points Most recent by SATHISHKUMAR SUNDARESAN Reporting and Analytics for HCM
-
In which subject area can I find 'Business Title'Summary: I need to create a report/analysis, showing all assignments, where job is not equal to Business Title. Content (required): I have started on an analysis with su…Morten Graae 529 views 4 comments 0 points Most recent by Stela Martins-Oracle Reporting and Analytics for HCM
-
Custom Error message on OTBI Reports / Dashboard Reports DisplaySummary: We need to display the custom error message on OTBI reports. Please provide the workaround for this. Content (required): OTBI Reports / Dashboard Reports - Disp…
-
How to create a report with manager management levelSummary: report with manager management level Content (required): Hi, I need to create a report with every employee of my company and relavite manager. I need also to re…Alberto Americi 92 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on Prior Visa InformationSummary: I needed help with BIP SQL code that can help me extract prior visa information for employees. Content (required): Currently if an employee has multiple visa in…Rohan Fernandes 26 views 8 comments 0 points Most recent by Rohan Fernandes Reporting and Analytics for HCM
-
Payroll-Personal Payment Details Real Time Target Bank Account is Null but not "IsNull" in the fieldSummary: Content (required): We are trying to find all the employees that have missing Bank Account Numbers or Bank Sort Codes We are currently using Payroll - Personal … -
Change Assignment without Salary update included in the compensation salary audit reportSummary: Change Assignment without Salary update included in the compensation audit report. Why would this be included in the compensation salary audit report if salary …
-
Are any specific role or privilege or job is required to access service infolets.Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Arpita Maitra 2 views 2 comments 0 points Most recent by Arpita Maitra Reporting and Analytics for HCM
-
Job Code Usage ReportIs there a report shows the last time an associate was in a given job code. We have a number of job codes with no one in the title. It would be helpful to know if the jo…Rebekah Gilday 16 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Emergency Contact and Employment Info ReportSummary: Hi all. I've reviewed the documentation shared in other posts, but I'm still not getting there, for some reason (likely user error!). I need to create a report …Jessica D 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI analytic: Populate a value in a column based on another columnHi ! In my OTBI analysis I want to have column formula where I check if an employee have any value in column A. If a value in present in column A for an emoloyee, I want…Ida-OC 649 views 4 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Report to show all items in the report and analytics catalogSummary: Is there a way to pull a report to show all items in the catalog (Shared Folders & Dashboards)? Content (required): Hi, This might be a long shot but does anyon…Amar Bilkhu 773 views 11 comments 2 points Most recent by ahmed alsharief Reporting and Analytics for HCM
-
Role requirements for editing templates within XML server?Summary: We have been eliminating the Application Implementation Consultant role from power users and have noticed gaps in our access to different system functions. Can …
-
Need 'Work Order Number' details of Background check page Under Screening section In BIp ReportSummary: Need 'Work Order Number' details of Background check page Under Screening section In BIp Report Content (required): Hello Experts, I Need the Work Order Number …
-
Dynamic Link to Oracle Business Intelligence Dashboard Not WorkingContent Hello, We are trying to use the dynamic link functionality for a custom icon so that when users click the icon, they are re-directed to the Oracle Business Intel…Dustin Dominic 97 views 7 comments 2 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Employee Missing PPM detailsSummary: Hi everyone, I need a query for those employees whose bank details are missing(PPM), If anyone has this query. Please share with me. Thank you.Saher 12 views 3 comments 0 points Most recent by Karla Dixon-Proactive Support SPA-Oracle Reporting and Analytics for HCM