Reports
Discussion List
-
Issue with Bins and Case StatementSummary Issuing a CASE statement against hire and term bins from Action Name fieldContent Due to our decentralization I cannot utilize the assignment event measures when…User_2025-01-28-08-47-04-905 34 views 1 comment 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM
-
Unable to use Organization field with person profileSummary Trying to use organization field with person profile data (education) in OTBIContent Hello I want to include Organization details (Organization Level 02 Name) in…Mohit Gupta-45440 54 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Employee Record in OTBI?Summary Which SA has Empl RCD?Content Hello All, Which Subject Area contains the Employee Record (Empl RCD) attribute? Thanks, Nikhil NelluriNikhil Nelluri-71478 37 views 7 comments 0 points Most recent by Nikhil Nelluri-71478 Reporting and Analytics for HCM
-
HR Manager Name & Person Number in OTBI SA's?Summary HR Manager Name & Person Number in OTBI SA's?Content Hi All, I am trying to report the name of HR Manager & Person Number for a Worker. Is the HR Manager & Perso…Nikhil Nelluri-71478 43 views 2 comments 0 points Most recent by Nikhil Nelluri-71478 Reporting and Analytics for HCM
-
OTBI Performance Tile Filter : How to get difference between 2 datesSummary OTBI Performance Tile Filter : How to get difference between 2 datesContent Hi, Currently, when I try to put a OTBI filter to get difference between 2 dates, it …
-
Do we have a separate 'Worker Number' field in any of the subject areas in Oracle Fusion HCM Cloud OSummary Do we have a separate 'Worker Number' field in any of the subject areas in Oracle Fusion HCM Cloud OTBI AnalysisContent Hi, Do we have a separate 'Worker Number'…User_MC37Q 156 views 16 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Special caracter not displaying as expectedSummary In standard reports of notifications, the special caracter are not well displaying.Content Hello, Any ideas please how to display the caracter correctly in the s…User_I6AXL 42 views 2 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Contacts ReportSummary I would like to create a reports with contacts detailsContent Hi, I tried to create a report via OTBI that includes all the contacts with the following details -…
-
FILTER in the OTBI Analysis--> Performance Tile does not work, throws formula syntax error.Summary FILTER in the OTBI Analysis--> Performance Tile does not work, throws formula syntax error.Content Hi All, I have formed the below query in BI Publisher Data Mod…
-
Fetching Gross Pay YTD for a terminated employee in BI ReportSummary Fetching Gross Pay YTD for a terminated employeeContent Hi, I am able to fetch Gross Pay YTD till last payroll process date but not after that. I require to fetc…User_2025-01-30-01-54-56-980 113 views 3 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Run report on OBIEE on specific user\permissionsContent Hello, Is someone familiar with a way to run specific analysis in OBIEE catalog without consider the permissions of the user? I explain: we have users the shoul…User_2025-01-22-19-54-45-915 71 views 3 comments 0 points Most recent by Gal Shani Reporting and Analytics for HCM
-
Duplicate RowsSummary When bring multiple emails / phones, it brings them in on one line and then creates an additional line with one of the attributesContent UPDATE: With everyone's …
-
Benefit CreditsSummary We need a report that would display Benefit CreditsContent We need a report that would display Benefit Credits by Person Number on the left access and each benef…User_2025-01-29-19-59-40-005 44 views 1 comment 0 points Most recent by User_2025-01-29-19-59-40-005 Reporting and Analytics for HCM
-
Need to get count of employees as of date and as of first day of fiscal year i.e. 01-apr-20XXSummary Need to get count of employees as of date and as of first day of fiscal year i.e. 01-apr-20XXContent Hi, We have a requirement as below: ========================…Preethi Vadirajan 72 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Does anyone have a report that gives the rate of pay at the time someone is paid?Summary Looking for pay rate reportContent Does anyone have a report that is able to show what rate someone was paid based off of the payroll run results? For instance, …
-
Is there a way to sort a date field by month only?Summary Field format shows MM/DD but sorts by Year. Is there a way to sort/filter by just the month?Content I have created a Birthday report and the date field format re…User_2025-01-28-20-43-56-568 70 views 3 comments 1 point Most recent by User_2025-01-28-20-43-56-568 Reporting and Analytics for HCM
-
Historical Audit Report for Assignment dataSummary Looking for existing report, or direction on how to construction report for historical Assignment dataContent Hi, Can you please suggest if there is an existing …User_2025-01-28-18-06-33-368 93 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Max cell count reached when exporting analysis to ExcelSummary Max cell count reached when exporting analysis to Excel truncating dataContent Good afternoon. We have begun seeing the following error when running some of our …
-
Last full time equivalent salary for leaversSummary Looking to report on the last full time equivalent salary for leaversContent Hi, I have created an absence report to show absences for a set period. I'm looking …Gary Miller-39965 29 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Printing details on a single row using a XSL Fixed Position TemplateSummary Need help in printing both parent and child XML details in the same rowContent Hi All, Need your suggestions on how to solve the below requirement: 1. Applicatio…Brendon Charles-24581 29 views 8 comments 2 points Most recent by Mark Johnson Reporting and Analytics for HCM
-
Hierarchical prompt for org tree strucutre in BI Data Model ReportContent Is it possible to create a prompt in BI data model report that will give us the whole org tree structure in a cascading way according to different levels as we h…Amrit 80 views 2 comments 2 points Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for HCM
-
link dashboard to a page entrySummary how the get the dashboard URL in order to make a new page entryContent hi all, ive created a Dashboard which include an absence analysis and a general prompts in…User_2025-01-30-04-14-21-127 93 views 19 comments 0 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
Maximum job proficiency in job profile competency in BI PublisherSummary where can I find the target level of competency job profile in BI publisherContent Hello, Do you have an idea where can I find the maximum proficiency in job com…User_I6AXL 30 views 1 comment 0 points Most recent by Rebecca Emerson Reporting and Analytics for HCM
-
Is there a way to create a sql viewSummary Is there a way to create a sql viewContent We want to create a sql view (e.g. employee hierarchy) and use it in various reports rather than repeat the code in ev…User_2025-01-24-00-06-12-585 54 views 4 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM
-
Total Compensation StatementsSummary We don't use the comp module - but we do utilize the Payroll and Benefits modules. Has anyone created a OBTI report that would pull all gross payroll numbers, LT…User_2025-01-29-19-59-40-005 99 views 9 comments 0 points Most recent by User_2025-01-29-19-59-40-005 Reporting and Analytics for HCM
-
Amounts getting duplicated in OTBISummary Amounts getting duplicated in OTBIContent Hello - We build a custom OTBi report using 'Compensation - Workforce Compensation Real Time' SA. There are few columns…User_2025-01-25-04-02-13-126 138 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Measures and Multiple versions of Org HierarchySummary Issue with Org Fields introducing a multiplier of delivered measuresContent Hi community! Recently we have introduced a new organization structure into our appli…User_2025-01-22-19-43-38-766 43 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Two part question regarding CEO's manager and Assignment Manager (Unsecured)Summary Reporting with CEO and Assignment Manager (Unsecured)Content This is a two part question. 1.) Our CEO does not currently report to any manager in HCM. Is this co…User_2025-01-28-20-24-47-566 76 views 4 comments 0 points Most recent by Ashok S Raj Reporting and Analytics for HCM
-
Payroll - Element Entries Real Time SA not returning all Elements associated with personSummary Number of Element Name for a person returned by Payroll - Element Entries Real Time Subject Area is not matching with Fusion Data. Please suggest.Content Please …User_2025-01-30-20-59-13-989 71 views 6 comments 0 points Most recent by User_2025-01-30-20-59-13-989 Reporting and Analytics for HCM
-
Query related to Job Code and Position NameSummary Query related to Job Code and Position NameContent Hi I would like to know if we can fetch the job code and Position Name in one table. Can anybody share the que…User_2025-01-30-21-52-52-008 30 views 2 comments 1 point Most recent by Sricharan Monigari Reporting and Analytics for HCM