Reports
Discussion List
-
Arrears report with Current Deduction And Total ArrearsSummary: Hi, I am trying to create a report that will show current deduction taken for Med, Dental, Vision Arrears along with how much the total is and if the full amoun… -
How do you get the effective date based on the action reason value?Summary: I want to get the parental leave start date which is the effective start date based on the action reason = 'On parental leave' Content (required): I have the co…Ed Sevilleja 32 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Gross Pay - Previous Week and YTDSummary Would like to be able to report out on the previous weeks' gross pay along with the year to date balanceContent Currently we have two reports. One to pull the pr…Kyle Norris 149 views 6 comments 0 points Most recent by Deekshith Kalluri Reporting and Analytics for HCM
-
Need a list of all the BPM Approval Workflows from oracle fusionSummary: Content (required): Do we have any report or query or any front end screen which exports the list of all the BPM Approval Workflows from Oracle Fusion? Version …Vinay Gharge 473 views 5 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
What table to query for Individual Balance adjustments in PayrollSummary: Hi, I am looking for the table in OTBI that can be used to query any manually keyed Individual Balance Adjustments. If anyone has an SQL, it would also be great…Bonnie Lafferty 291 views 2 comments 0 points Most recent by Bonnie Lafferty Reporting and Analytics for HCM -
Issue with Report Edit for Bursting QuerySummary: Issue with Report Edit for Bursting Query Content (required): Hi All Greetings! This is an issue as observed when we tried to open the data model- When we try t…Parag Hiremath 62 views 11 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
Weird output behavior when reporting learn ItemsContent Hello, How can i change the export of reports so Each learning Item has it's own row? I can't figure this out for the life of me. This is the export now in excel…User_2025-02-06-13-23-44-898 30 views 3 comments 0 points Most recent by MichelleWard Reporting and Analytics for HCM -
Could not able to search BI Consumer in PermissionSummary: Hi Experts, I have removed the BI Consumer role from a folder and when I try to add back the BI Consumer role, I could not able to search in "Add Application Ro…Harish Vummidi 51 views 1 comment 1 point Most recent by Harish Vummidi Reporting and Analytics for HCM -
BIP jobs are getting stuckSummary: BIP jobs are getting stuck Content (required): Hi Team, Greetings! We have been observing that multiple BIP jobs ( manual or scheduled) are getting stuck and re…Parag Hiremath 162 views 5 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Report Error - PGA limit (MB) exceededSummary: Report Error - PGA limit (MB) exceeded Content (required): Hi Team, Greetings! We have been getting the error as per the attached file for the report in Product…Parag Hiremath 21 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Failed to log into BI Publisher: invalid username or passwordSummary: Failed to log into BI Publisher: invalid username or password Content (required): Hello experts, we have done the P2T in oracle HCM, but after it, the connectio… -
we need annual accural and carry over columns in biSummary: Hi Team, we looking above two columns from BI reports . any one can help me on. Thanks, Ajay Content (required): Version (include the version you are using, if …AjayKumar Maddipati 61 views 9 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Can we use 2 tabs one will show count and other with names as showed in(attached screenshot) in OTBISummary: Can we use 2 tabs one will show count and other with names as showed in(attached screenshot) in OTBI Content (required): Version (include the version you are us…Swati U 71 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Unable to get the OldValue and NewValue by using per_bipntf_utilitySummary: Unable to get the OldValue and NewValue if any change on the Employeement level by using per_bipntf_utility Content (required): We did few changes on the Emplom…
-
Layer filters?Summary: Looking to be able to layer filters. An example would be that I want to only pull department names that start with a specific sequence of numbers AND have/don't…Jessica D 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Ethnicity values question in Recruiting Subject AreaSummary: Asking for assistance in understanding the difference between 2 Ethnicity fields Content (required): Hello. Can anyone advise on the difference between the 2 fi… -
OTBI - Calculate Tenure using Presentation VariableSummary: I need show Tenure calculation by subtracting the Work Relation Start Date of a person from the Date passed by the user against the presentation variable (Promp…Harpreet Shergill Oracle 92 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Delegation Approval Query /TableSummary Delegation Approval Query /TableContent HI , i have a requirement to create BI/OTBI report for delegation approvals. Can any one please share the table/query whi…
-
To avoid Oracle Repository external accessHi team, I need your precious support! Cause of notifying the candidate, we created a BI report adding a "link" to make the recipient able to download a .zip file. We us…tommasodicesare 31 views 0 comments 0 points Started by tommasodicesare Reporting and Analytics for HCM -
Need the field from the table to use the alternate email for internal cand to build the customBI repSummary: Need the field from the table to use the alternate email for internal candidate to build the custom BI report and i am not able to find this field in IRC_CANDID…
-
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr…Parag Hiremath 72 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
How do you include inactive requisitions in an analysis?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Ed Sevilleja 51 views 4 comments 0 points Most recent by Ed Sevilleja Reporting and Analytics for HCM
-
How to report on Date Paid in last 12 monthsSummary: I have a report using the Payroll Balances Real Time subject area. The requirement is that when the report runs on the first day of every month, the output is f…
-
Reporting on ICD/Manage Personal Contribution Requests that have been SavedSummary: Content (required): We use Individual Compensation Distributions for our employees to claim for irregular payments (overtime worked etc.) as we are not yet usin…Leanne W 41 views 5 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
report of all list of ESS jobs which are Running more than 24 hrsSummary: report of all list of ESS jobs which are Running more than 24 hrs Content (required): report of all list of ESS jobs which are Running more than 24 hrs Version …Swati U 31 views 2 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…Swati U 432 views 10 comments 0 points Most recent by Amol Patil HCM-Oracle Reporting and Analytics for HCM
-
Annualized TurnoverSummary Want to incorporate an annualized turnover in my Turnover DashboardContent Is there currently anything with annualized turnover, or do I need to formulate someth… -
How are users interacting with systemSummary: Content (required): Hello We would like to know how our users are interacting with our system. The ASE_USER_LOGIN_INFO table shows the date of the last login, b…Helen Thomas 41 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Oracle Fusion HCM Extract getting fails when we select Delivery Type as FTPSummary: Hi, Delivery option getting failed when we select delivery type as "FTP" along with bursting in BI data model. if I select Delivery type as "None" extract getti…
-
The promt does not affect the analysis report on the Dashboard screen.I have an analysis report that I use on the dashboard screen and parameters that I expect to affect this report, and one of these parameters does not affect the report, …Cansel Karasoy 62 views 10 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM