Reports
Discussion List
-
Percentage of Employee With and Without Goals not showing properly in columnsSummary: Hello again, I need help to check my case statements. The % of employees with and without goals are not reflecting properly. CASE WHEN "Workforce Goals - Goal S…Marilyn O 25 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How can we display different Infolet tiles based on each page?Summary: Is it possible to display difference Infolet tiles based on page (e.g., Me, My Team, My Client Info)? Can EL expressions solve this problem? If so, please provi…Nipon 13 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting on Payroll Balances with a Time Definition DimensionSummary: Hi, we have a number of payroll balances defined which utilise element allocation functionality and have a 'time definition' dimension i.e. _REL_BD_TDPTD. The t…Jon Taylor 14 views 2 comments 0 points Most recent by RJH.CC.gov.uk Reporting and Analytics for HCM
-
Mass Download of Document Records errorsSummary: Can you get details on the skipped downloads or those with errors? Content (please ensure you mask any confidential information): This is in the log file: Total…Stephen Jones 14 views 1 comment 0 points Most recent by Stephen Jones Reporting and Analytics for HCM
-
Could not find the lookup HRC_TRANSACTION_STATUSSummary Could not find the lookup HRC_TRANSACTION_STATUSContent Hi Experts, As a part of pulling the Approval Transaction Details, I have used the table HRC_TXN_DATA. Th…Charan Kollipara 112 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
which table has the information of Legislative Categories for Manage legala AuthoritiesSummary: Hi Team, We need a table where the information of Legislative Categories stored for Manage legala Authorities. We have the table HZ_PARTIES to get Legal authori…Opkey PA 11 views 1 comment 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
User unable to run OTBI report but could in the pastSummary: All of a sudden this user is not able to run reports specific to ORC. I cleared the server cache but it's still not working. Any ideas prior to logging an SR? C…THawkins_LGI 45 views 15 comments 0 points Most recent by THawkins_LGI Reporting and Analytics for HCM -
BIP HCM Payroll - Is there any alternative to pull the Payroll process statusBIP HCM Payroll - Is there any alternative to pull the Payroll process status apart from below Query /* ( SELECT meaning FROM hcm_lookups WHERE lookup_type = 'ORA_HWM_PA…BhaskarDondapati 314 views 10 comments 0 points Most recent by Sunil Makam Reporting and Analytics for HCM
-
Processing Bar Not Visible During Report Generation – Needs Left Alignment or Fixed PositionSummary: When running a wide report, the Processing bar appears centered on the report, making it not visible unless the user scrolls horizontally. This causes confusion…
-
Capability to add CSP Progression Comments in OTBI analysisHi All, Currently, it is possible for a recruiter to add the comments while moving a candidate to different phase / state. The comments are visible in Progress tab under…PranitSawant 11 views 2 comments 0 points Most recent by PranitSawant Reporting and Analytics for HCM -
BI Publisher – Is it Possible to Reposition the 'Processing' Notification for Wide Reports?Summary: In BI Publisher, when running a report that is horizontally wide, the "Processing" notification only appears near the center of the report layout. This requires…
-
Performance Management Goal Report - Fusion OBISummary Listing of employees that have been assigned a goal planContent I am trying to write a report in Fusion OBI that will pull all employees that have been assigned …User_2025-01-25-02-27-42-541 101 views 7 comments 0 points Most recent by Naim Reporting and Analytics for HCM -
OTBI Logical SQL complex query assembler - NOW 10 subject Areashttps://us.v-cdn.net/6034893/uploads/IRBUUHV044EZ/logical-sql-assembler-v5.xlsx Summary Now updated - Combine analyses from up to 10 different subject areas (V4) Content…Maxime Pignot-Oracle 1.6K views 14 comments 15 points Most recent by Maxime Pignot-Oracle Reporting and Analytics for HCM -
How to connect to Oracle HCM Cloud to Power BI using CDataSummary: We are trying to connect to Oracle HCM Cloud to Power BI using CData ( https://www.cdata.com/drivers/oraclehcm/powerbi/ ) So, our PowerBI developers can utilize…
-
Birthday In Next 7 Days (Birthday THIS WEEK)Summary: Could someone please share an OTBI Birthday report that can be scheduled to run every Monday, showing Birthdays that week (Monday thru Sunday). For example, whe…
-
Retrieving learner-submitted attachments through the BI reportSummary: I need to fetch learner-uploaded attachment details via the BI report from the specified path below. UI Path - Edit Assignment > Related Materials > Learning As…Sanduni Pathirathne 23 views 3 comments 6 points Most recent by Harikaran Ravikumar Reporting and Analytics for HCM
-
Tables Containing Approval History with Approver Names and Statuses in Oracle HCMHi! Which tables contain the information from the Approval History section, including the names of the approvers and their statuses? Do you have an example query?LeonardoNogueira 23 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Headcount is different across Line Manager Dashboard and reportingSummary: Hi, I am having an issue at the moment where the Line Manager Dashboard is showing me 5.8k Headcount and 5.1k FTE, but my OTBI report is picking up 6159 active …GregoryKew 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Absences created in Advanced modeSummary: It appears that the OTBI report splits out absences created in Advanced Mode onto separate lines by work week but gives the total absence duration for the leave…Stephen Jones 73 views 3 comments 0 points Most recent by Natalie A. Reporting and Analytics for HCM
-
Absence Detail AnalysisSummary: I'm looking to create an analysis which will show a detailed list of all absence entries in our system. I've created the following using Workforce Management - … -
Road map to upgrade BIP Excel 97 version to excel 2010HI Team, I am for road map plan to upgrade BIP Excel 97 version to excel 2010. Currently BIP excel supports 97-2003 version only. Most of the advance excel function like…shiva G1 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to get list of tables that stored a data in oracle fusion hcmSummary: I am looking for list of table name that stored a data in oracle fusion hcm. Content (please ensure you mask any confidential information): Version (include the…Anup Karmankar 42 views 4 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Redwood Workflow NotificationsWe have custom workflow notifications currently still in the Classic UI. We are in the process of migrating all modules to Redwood. Please help us transfer the custom wo…
-
Required Table or SQL query to get Phase details for the ORC moduleSummary: Hi, Required Table or SQL query to get Phase details uder the task: Candidate Selection Process Configuration for the ORC module Content (please ensure you mask…
-
Group similar columns together in bip report either through report editor or rtf templateSummary: We have a requirement to build a performance report in BIP to bring all the similar worker and manager comments in single row instead of the rows being repeated…
-
when I scheduled OTBI report through agent it's failingSummary: Hi Team, when I scheduled OTBI report through agent it's failing. Thanks, Ajay Content (required): Version (include the version you are using, if applicable): C…AjayKumar Maddipati 99 views 4 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
In RTF Tag is not getting into BoldSummary: We are printing CTC - Salary amount in Offer letter all the amounts (Please refer to the table image from attachment) we need to make the Total Cost to company … -
SQL query or Table for Double Opt In Management in Fusion ORCSummary: Hi, Which table is having the information of the task "Double Opt In Management" or please provide query Content (please ensure you mask any confidential inform…
-
Required table for component group rules setupSummary: Hi Team, Could ypu please provide us the table where payroll component group rules stored in oracle fusion Payroll module Setiup name > Component Group Rule. fo…