Reports
Discussion List
-
Converting BI Analysis to BIP (Easily)Summary Need to convert existing analysis to BIPContent Is there an easy way, if any, to do this? -
Need to use 2 stand-alone data groups in an extract without any connect clauseSummary Need to use 2 stand-alone data groups in an extract without any connect clauseAloka Bhattacharya 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Crossing Subject AreasSummary Certain dimensions will not populate even though I have linked by measures.Content I have created this report and I have been having the hardest time populating …Deb Luisi 123 views 6 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisSummary BI Publisher: Can I have Action Links on the BI Publisher Report just like in OTBI AnalysisContent Hi, BI Publisher: Can I have Action Links on the BI Publisher … -
In BI Publisher Data Model, how do I fetch the OFFER ISSUED DATE for an employee.Summary In BI Publisher Data Model, how do I fetch the OFFER ISSUED DATE for an employee.Content Hi All, In BI Publisher Data Model, how do I fetch the OFFER ISSUED DATE…
-
BI Publisher Bursting: Need to display report content in the e-mail body, instead of as an attachmenSummary BI Publisher Bursting: Need to display report content in the e-mail body, instead of as an attachment.Content Hi All, I have a requirement where I need to send a…
-
Some Users cannot see Leavers despite Correct RolesContent Hi all, got a weird one! I developed some leavers reports a few months ago and they worked perfectly for me and for users when they tested them. The report is no…Aaron Leggett 38 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
BI Report job outputsSummary Downloading all outputs in one goContent Hi guys, Do you know if there is any way to download all outputs at once? I have downloaded each sheet only separately. …Alvaro Couto 30 views 5 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Find all workers which are missing emergency contactSummary How to create a report which present the employees that missing an emergency contactContent Hi, Someone has an idea how to create a report in OTBI of all the emp… -
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 38 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 154 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 43 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 70 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 87 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 78 views 2 comments 2 points Most recent by Farooq Syed, CPA, PMP, CISA Reporting and Analytics for HCM