Reports
Discussion List
-
How to have the report names show when embedded on the left side bar?Summary: Hi there, We are embedding reports as pages/tabs to the left side of certain pages I'm not sure how to get the name of the tab to show. Is there a setting that …Ruby Hui 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Run Payroll Costing Results - load column into FDI?Hello, Is there a way to take a column from the seeded Run Payroll Costing Results report and move that into FDI for reporting use? The need for it is stemming from payr…Sean-B-01 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP | SFTP filenames with .XLS or .XLSX extensions are not readable in SFTPSummary: Hi Experts, My requirement is to place the SFTP file in .XLSX format. SFTP filename with .XLS or .XLSX extensions are not readable in SFTP, but filenames with .…Arti_Priya 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
ANC_PER_ABS_DAILY_DTLS - Issues with Overnight Shifts / Absence BreakdownSummary: We want to report on absences related to a shift, however the table seems to store the hourly breakdown per day rather than per shift start date. Example; 25/06…
-
Numbering Adjustment in RTF TemplatesCustomer have multiple paragraphs in a report built using RTF template which are numbered and some of them have conditions so if the condition is met the paragraph is di…Sonal_Lalwani 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
Rolling Average Wage ReportHi Does anyone have a sql query or a report that provides the average weekly wage over a 52-week period based on a specific date? We are trying to provide our Workers Co… -
How to return specified run result values on one row in Payroll Run ResultsSummary: Without using a pivot table, how can I get payroll run results to show input value names as the column headers, then the relevant run result values horizontally…
-
Impact in the reports/dashboards after enabling RedwoodHave you encountered any issues with Reports/Dashboards after enabling Redwood across the HCM modules? Is there any documentation or impact analysis available for this? -
How to get the Job offer Approval history in a BIP report?Summary: Hello, We have a requirement to fetch the approvers, their approval comments and the date of approval in a report. How do we get this via BIP report? Version (i…Shreya Datir 42 views 3 comments 0 points Most recent by LakshmiCharitha Cherukuri-Support-Oracle Reporting and Analytics for HCM
-
Get list of all BI Publisher reports that use a specific data modelSummary: Is there a way in BI Publisher to get a list of all BI reports that are using xyz data model as the DM, in order to understand the impact of making changes to a…Shant_Sarkissian_WJG 595 views 7 comments 0 points Most recent by ManavM Reporting and Analytics for HCM -
Filters on evaluation deep linkSummary: Filters on evaluation deep link Content (please ensure you mask any confidential information): I have the following deep links: Evaluate Performance (EVALUATE_P…Stefano_Mazzocca 11 views 2 comments 0 points Most recent by reneechapa Reporting and Analytics for HCM -
SQL to list all customized OTBI and BI Publisher reportsSummary How to list all OTBI and BI Publisher reports in Shared Folders?Content Hi Team, Does anyone have the SQL that we can run to list all OTBI and BI Publisher repor… -
How to encrypt and decrypt images in Oracle fusionSummary: How to encrypt and decrypt images in Oracle fusion Content (please ensure you mask any confidential information): Hi All, We got a requirement to encrypt and de…
-
Can you help me to adding the name of the employee in this SQL query?Summary: Hello team! I have this code, but I don't know how to add the name of the employee. Could you please help me with that? Content (please ensure you mask any conf…Claudia Linares L 21 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Query to get Vacation Rules informationSummary: Query to get Vacation Rules information Hi, We need to create a report for vacation rules for all employees in the system and I know that there is a seeded repo…Kiran345 548 views 14 comments 0 points Most recent by Deepak Kumar Dev-Oracle Fusion Applications Administration -
Send automatic birthday wishes to employees via mail from organization.Summary: Send automatic birthday wishes to employees via mail from organization. Content (required): Hello All, I have a requirement, need to send automatic birthday wis…
-
Busting with OTBI as DataSource in a DatamodelSummary Error on Busting with OTBI as DataSource in a DatamodelContent Hi All, I am trying to use a OTBI Analysis/OBIEE sql as a source in a BI Datamodel. The Bursting i…User_2025-01-22-19-45-49-284 43 views 2 comments 0 points Most recent by Asif_T Reporting and Analytics for HCM -
Emails with analysis tables are putting in extra spacingSummary: We have analysis that displays jobs that were posted in the past week. We send this report to users via email and have the data displayed in the body. The data …
-
Roles and Privileges ReportHi, Can you please help me to develop a report that lists all the privileges for all roles (including both predefined & custom roles) in Fusion? Something like this: Rol… -
Arabic Text in PDF Output Not Bold and Font Does Not ChangeSummary: Hello everyone, I am facing an issue with generating PDF output where the Arabic text does not appear in bold, and the font does not change as expected. • The b…
-
Subject area to pull checklist questionnaire in OTBISummary: We are trying to develop reports on questionnaires that have been configured for checklist. But when we are using "Workforce Management - Checklist Real Time", …Priyanka Ray 31 views 4 comments 0 points Most recent by Priyanka Ray Reporting and Analytics for HCM -
Date parameter is throwing an errorSummary: A date value is stored in the screen_entry_value field. I created two date parameters (p_week_start, p_week_end). I am trying to use the screen_entry_value in m…Consultant Ian 32 views 7 comments 0 points Most recent by Consultant Ian Reporting and Analytics for HCM -
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type …
-
SQL to get number of Grades in a Grade laddersSummary: I need SQL to get number of grades contains in all the grade ladders that organization is having. If anyone having it please share Content (please ensure you ma…Smitashree Pradhan 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Facing issue in RTF template(This exists with maximum width.)Summary: Trying to add two new extra fields in the existing RTF template is giving an error. (Error: This exceeds the maximum width.) Content (please ensure you mask any…Gunal Baskar 771 views 4 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
Analytics for scmSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…john.hutchinson 11 views 2 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
For Performance documents, is there a report area available to show completion date for tasksSummary: We need a report to identify the date each of the tasks within the process flow of our performance documents are completed. If they are not complete, we would e…
-
make etext template Tab delimitedSummary I need to make a report tab delimited, however I cannot seem to accomplish with etext template.Content I found this, but can't seem to apply it. I guess I am not…
-
Looking for advice regarding creation of a report to load details into Costing for PersonsSummary: We currently have a report in place which gets run daily to load information via HDL to load into the Costing for Persons. It has been made aware the report is …
-
Can conditional formatting be applied to the total cell in BIP pivot layout?Summary: Can conditional formatting be applied to the total cell in BIP pivot layout? Content (please ensure you mask any confidential information): Hi Experts, I could …Volodymyr Faranosov 1 view 1 comment 0 points Most recent by Volodymyr Faranosov Reporting and Analytics for HCM