Reports
Discussion List
-
How to find failed transaction on a person numberTSummary Transaction console failed transaction columnContent Which column will store the failed transaction status. How to find failed transaction on a person numberKammarapalli Venkatesh-Oracle 20 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Vertical display of text in titleContent We built a 9-Box using performance tiles and would like to display labels against the Performance boxes. Is that feasible? Thank you!User_2025-02-10-08-27-16-805 22 views 9 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Scheduled Reports Are Stuck on either "Running" or "Waiting" StatusSummary Scheduled Reports Are Stuck on either "Running" or "Waiting" StatusContent Hi, Our scheduled BIP reports are stuck on "Waiting" or "Running" status, even the one… -
Report on Transactions that failed in BPMSummary Report on Transactions that failed in BPMContent Hi Has anyone worked on creating reports based on BPM tables. I have requirement to fetch the failed termination…User_2025-01-30-21-52-52-008 130 views 6 comments 0 points Most recent by Kammarapalli Venkatesh-Oracle Reporting and Analytics for HCM -
Issue passing the date parameter to the date parameter while creating a link to the other BIP reportSummary I have been tryingng to create a link for a custom BIP report in my existing report for which I am passing 3 string parameters which worked fin, while passign th…User_2025-02-07-18-15-37-534 125 views 2 comments 0 points Most recent by User_2025-02-07-18-15-37-534 Reporting and Analytics for HCM -
CASE statement THEN valueContent I would like to add a case statement logic where if a condition holds true, a column value is displayed. But in addition to the value being displayed from the sy…User_2025-02-10-08-27-16-805 25 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Ethnicity bar graphSummary Bar graph does not match tabular view.Content I am trying to pull employee ethnicities from the system. I have come across multiple posts on how to bucket employ…User_2025-02-10-08-27-16-805 68 views 6 comments 1 point Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Sample Workforce Compensation BIPContent Hello experts, where could I find sample Workforce Compensation BIP? I need to build a BIP report allowing managers to see their direct/indirect reports for the …Valerio Curzi 49 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
As of Date Worker ReportSummary OBTI Report with Worker Information as of specific dateContent I am looking for way to build a report in OBTI that contains worker data that can be pulled from a…Mike Householder 29 views 2 comments 1 point Most recent by Mike Householder Reporting and Analytics for HCM -
Head Count as of given dateContent Hi Experts, We are looking for a report which has the below data point. The worker subject are giving information as of date and in the current requirement we ne…Kiran Kancherla 34 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report on Performance Document AcknowledgmentSummary Is there a table or Subject area to report on employee acknowledgement?Content Is there a table or Subject area to report on employee acknowledgement? We need a …User_2025-02-05-15-32-02-086 47 views 3 comments 1 point Most recent by Nivya Mathire Reporting and Analytics for HCM -
Reporting on saved goalsSummary Reporting on a goal before it's been approved by the managerContent Hello, We used to be able to report on goals using Goal Status Overview Real Time. The Versio… -
Hire Date using OTBI Reporting (Not to include Global Transfer Dates)Content Greetings, We recently went live with Oracle HCM Cloud in January and we are trying to figure out how to correctly report a hire date using OTBI Analysis reporti… -
AOR using SQLSummary Display AOR fields by Employee Number and NameContent HI All, I hope someone can help me with a SQL. I want to try and build a common query that we can use in ou…User_2025-02-04-08-51-08-912 58 views 1 comment 1 point Most recent by Srdjan Ostojic Reporting and Analytics for HCM -
As Of Date reporting and dimensional attributes in OTBIContent Hi, We want to use As Of Date reporting with OTBI. But we are not sure which dimensional attributes will also move to the value at this 'As Of Date'. Will all di…User10137270-Oracle 28 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Instance identifier in BIP reportSummary We need specific report to run only if it is on specific instance (say Test POD).Content We need specific report to run only if it is on specific instance (say T…Priyanka More-Oracle 178 views 5 comments 1 point Most recent by Priyanka More-Oracle Reporting and Analytics for HCM -
How to load sample report in Oracle HCMContent Hello experts, I need to load a custom template as example in Oracle HCM. I want to load an image showing a sample performance document. In addition, I have crea…Valerio Curzi 33 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Simple logical sql query fails to load in data modelSummary Simple logical sql query fails to load in data modelContent We were trying to create a data model with Simple query(Name = Any , Data Source = Oracle BI EE, Type…Sreedharan-Oracle 77 views 7 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Question on .catalog filesContent Hello Experts, I got two questions (probably a weird ask) on BI catalog objects. In /analytics (OBIEE), the archive will create a .catalog file instead of a.xdo/…Akash Kiran Jana 159 views 5 comments 2 points Most recent by Akash Kiran Jana Reporting and Analytics for HCM -
Infolet Visibility IssueSummary Can we use Assignment's Descriptive field value in Infolet EL expressionContent Hi, We need to set the Infolet Visibility based on Assignment's Descriptive field… -
How to remove an unwanted character in rtf template (PDF Output)Summary How to remove an unwanted character in rtf template (PDF Output)Content Hi Experts, We are generating confirmation letter with PDF format for this we are using R…Bala Kasineedi 543 views 4 comments 0 points Most recent by Bala Kasineedi Reporting and Analytics for HCM -
Multiple Worksite report is not returning data for TX after 21-A updateSummary Multiple Worksite report is not returning data for TX after 21-A updateContent Multiple Worksite report is not returning any data for Texas or New Hampshire afte… -
Report for final year-end performance ratingContent Hello Oracle community, We are looking for a report for final year-end performance rating for each employee. Version 21ADHolzemer 36 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Extract Projected Accrual Absence Balance in HCM/BIP reportSummary Extract Projected Accrual Absence Balance in HCM/BIP reportContent Hi Experts,We have a requirement to fetched projected Absence balance of employee in extract t…Rajeev Nayan 718 views 6 comments 3 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
We need to fetch all active records from current Organization Tree for department structureSummary We need to fetch all active records from current Organization Tree for department structureContent Hi Experts, We need to fetch all active records from current O…Balaganapathi Kasineedi 67 views 6 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Organization Levels, Organization Manager Names, and their Effective DatesSummary Organization Levels, Organization Manager Names, and their Effective DatesContent Hi Experts, Good day! Can you please help and guide or redirect me to resources…Raymund Jerome 10 views 4 comments 0 points Most recent by Raymund Jerome Reporting and Analytics for HCM -
21A Enhancement- HR_DOR_REPORTING_LIST_VSummary 21A Enhancement- HR_DOR_REPORTING_LIST_VContent Do you need to update/fix any security roles after this enhancement in 21A? How do you "control this access" with…Andrew_Schmitz 58 views 3 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Report to show all future approversContent Hi, Does anyone know of a report or way to query, all future approvers in an approval chain for notifications. For example, next approver is person x, then once … -
Number of Rows in a ReportSummary How to see the number of rows in a reportContent I am new to OBTI and am trying to build report up slowly and trying not to lose employee details as I go along o…Sharon Harper 35 views 5 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Report to fetch Open Notifications for the employeeSummary Report to fetch Open Notifications for the employeeContent Hi Guys, I have a requirement to send all the open notifications as a summary via email every week to …Vinod SM Gowda 46 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM