Reports
Discussion List
-
Show Field Data in Column instead of in RowsSummary Working on this in OTBIContent Hi All, I am trying to pull in the last 2 dates an employee was paid. Currently the data appears as 2 separate rows. I am using ra…tiffnyc 28 views 5 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Access control reportsSummary Looking for a way to extract the group to group linksContent The User Group report gives the links of each user to the various security groups, and in CSV format… -
Line Manager Dashboard PromptsSummary AsOfDate not working in my customised versionContent Hi, I have been trying to copy and then customise the Line Manager Dashboard to suit our organisation which …User_2025-02-05-22-44-35-842 67 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Need to Use Result of One Column in Formula for Next ColumnContent Hello there Reporting and Analytics experts. I am hoping one of you can help me out with an analysis I am working on. I am trying to get our FTE reports up and g… -
Required Report for Identify New Join Employee and Rates definition In ProjectsSummary Required Report for Identify New Join Employee and Rates definition In ProjectsContent Hi Team, As per the Business Requirement, We need to Identify the New Join…User_2025-02-05-00-13-31-186 42 views 8 comments 0 points Most recent by User_XH9NS Project Management
-
Double Alias in Reporting Web StudioSummary Double Alias in Reporting Web StudioContent Hi All, I have a FCCS Application with double Alias (English and Italian). I created a set of reports with options "A…Antonio Barbaro 45 views 2 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
Recruiting - Reporting on a candidate source when added by a recruiterContent HI experts, I need your help if possible. We haven't been using agency recruiting in ORC because of a system functionality issue so have had to resort to a worka…User_2025-01-25-04-04-47-442 77 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
Historic Position, Dept, job detailContent I have opened an idea ticket, but just checking to see if anyone has figured our how to create a assignment history report that brings in the position, job, dept…
-
Error in OTBI Analysis Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PContent Hi All, I have a OTBI analysis with Graph. When I move my cursor over the graph I see Hand means it's clickable. When i click I get following error, Can someone …User_2025-02-07-19-03-14-525 277 views 4 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Custom Dashboard HeadcountContent Hi, I have created custom Dashboard and created 3 different Headcount Analysis for 3 BU head count. When I run my dashboard first time it shows correct count for…User_2025-02-07-19-03-14-525 57 views 5 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
What date format do I need to use in order to calculate the days between one date and another?Summary What date format do I need to use in order to calculate the days between one date and another?Content Hello I am busy creating a data model for a BI report. In t… -
SQL Code to Extract Setup Grade Rates with Grade NameSummary SQL Code to Extract Setup Grade Rates with Grade NameContent Team, I have a similar requirement. I am trying to fetch the setup data of Grade Rates with Grade na…User_2025-02-01-03-43-13-079 156 views 3 comments 0 points Most recent by Rajeev Nayan Reporting and Analytics for HCM
-
Changes Report - What are your practices?Content Currently we are modifying the changes report that we had using BIP and we stumble this difficulty How's your company show changes in the changes report? We have…Rick Jason 38 views 7 comments 2 points Most recent by Shanna Oppenheim Reporting and Analytics for HCM -
Save file directly to oracle import and export folderSummary Save file directly to oracle import and export folderContent There is the possibility to save the file generated by Otbi in the Oracle import and export file pat…Leandro Vasconcelos 24 views 1 comment 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to create a formula row for Grand Total in Financial Reporting Web StudioContent Hello everyone, Need some help with a report build in FRWS. We have a report where we have on Pages the children of entity, in this way we get, let say a P&L for…
-
BIP Bursting to email: how to embed a link to the application in the emailContent Hi, we created a bi publisher report with an RTF template. in the report we created a form field and in the bi publisher property we set: View the column NEW_L…Alberto Boccato 288 views 9 comments 0 points Most recent by Alberto Boccato Reporting and Analytics for HCM -
Resignation Submitted dateContent Hi All, We had a predefined report which use to give Resignation Submission date along with the Employee last working date. Few days back the report stopped work…Kiran Kancherla 38 views 4 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Raw data extraction from Oracle Fusion to Datalake/SFTP serverSummary Exporting data from Oracle Fusion to SFTP Server - Unable to handle systematic deletesContent Hi All, We have a requirement where we need to push raw data into a…Kalyan Reddy 58 views 1 comment 0 points Most recent by User_2025-01-28-08-43-27-760 Reporting and Analytics for ERP
-
OTBI - prefix for current date minus daysSummary How can I define prompt for an OTBI report which is the current date minus variable of daysContent Hi, I'm trying to create a prompt of number, so if the user wi…
-
Analysis Total is Rounding to ThousandContent Hi Champions, I have created Headcount Analysis in my Custom Dashbaord ( Like Count(worker.person_number) to get exact number of employees working in a particula…User_2025-02-07-19-03-14-525 8 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Custom Job running concurrently & seeded program running sequentiallySummary Custom Job running concurrently & seeded program running sequentiallyContent We have developed the custom program basing on seeded program. Where we noticed cust… -
Compound sort in OTBIContent Hi All, Is it possible to do Sort on 2 columns in OTBI? Ex. First Sort on BU and second sort on LE in same report. Thanks, VijayUser_2025-02-07-19-03-14-525 39 views 2 comments 1 point Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Table name and column for Accounting Period of Project CostSummary Table name and column for Accounting Period of Project CostContent Hi Experts, What could be Table name and column for Accounting Period of Project Cost (under M…
-
Getting Error When Click "Drill to Transaction Detail"Content Hi Experts, When I'm clicking on link "Drill to Transaction Detail" from HeadCount Analysis ( I copied it in my custom Dashbaord) I'm getting following error. Er…User_2025-02-07-19-03-14-525 32 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM
-
Learning -> How to achieve Fusion Security into Custom BIP Reports through SQL?Summary Apply fusion security into custom-sql reportsContent Hi, Can anyone please help? I am in the process of developing a few custom reports using sql/bip option and …SantoshKumarBhairi 109 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
Removing Nulls from Limited Dashboard PromptsSummary Limiting dashboard prompt by other values while removing the null optionContent Hello, I've created a dashboard prompt where we're trying to limit the values of …Rob F 37 views 3 comments 0 points Most recent by User_2025-02-07-19-03-14-525 Reporting and Analytics for HCM -
Archive Versions vs Archive ScenariosContent I was talking with an old colleague about archive version/scenarios and wanted to get a broader opinion. The requirement is to archive off the forecast every mon… -
What's New in 20.12?Summary Wrap-up for a Strange YearContent Well, this concludes a strange year (to say the least) but one with lots of new features. We've snuck several more for this mon…Mark Rinaldi-Oracle 244 views 5 comments 6 points Most recent by User_2025-02-08-03-53-41-891 Planning