Reports
Discussion List
-
Workers Missing from Performance Document Eligibility Subject AreaSummary Population in Performance Document Eligibility Not the same as Assignment Real timeContent Hello, I'm trying to produce a simple report that shows the list of wo…Rob F 66 views 5 comments 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Outputting Dates (no timestamp) to Excel and keeping date formatSummary Outputting Dates (no timestamp) to Excel and keeping date formatContent Good afternoon. In our BIP reports, we have been removing the timestamp portion from date… -
Seeking Performance Management tables for specific data fieldsSummary Seeking Performance Management tables for specific data fieldsContent Hi. My team is building a Performance Management BIP report and is seeking to include the f…
-
How to use Pivot table in BI reportSummary Pivot table is not getting populated with dataContent Hello.. Can anybody please help on this. I am creating a BI report using Pivot table following below steps.…SUCHARITA DASH 84 views 3 comments 0 points Most recent by SUCHARITA DASH Reporting and Analytics for HCM -
Scheduled report doesn't have all rows. Stops at 25k rowsSummary Scheduled report doesn't have all rowsContent One of my OBTI report gives me 65k rows. IF i were to schedule this and deliver my excel2007+, it generates only to…Naveen Bitra 63 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Send a report to SFTP siteSummary How to send reports to a SFTP siteContent Very new to Oracle, but wondering how we can send reports to SFTP sites? Is there a good reference material on this? Th…Mike Borghoff 93 views 5 comments 1 point Most recent by Scott Gallup Reporting and Analytics for HCM
-
Base table for Compensation Component ColumnsSummary Not able to find the base table which holds data for Compensation component columnsContent I am writing a BI Publisher report to fetch Compensation worksheet dat…Mohammed Shameem-Oracle 104 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Show blob image in OTBI report.Summary Blob image in OTBI report.Content Hi I have a requirement in which I must show an image in a report found in the per_images table. When I am building my .rtf fil…Cesar Tepetla Corte 84 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Length of service - GroupsSummary How to group length of serviceContent Hi, I'm doing some reporting & dashboards and was looking for a way to group the years of service into groups. i.e. number …Stuart Skene 65 views 8 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Third-Party Tax FilingSummary Validation of Payroll Transactions sent to Third Party in Oracle Fusion HCMContent In Peoplesoft, The Third Party Periodic Interface sweep identifies payroll tra…Surya Muralidharan-78192 57 views 1 comment 0 points Most recent by Mary Nell Mclaurine-Oracle Reporting and Analytics for HCM
-
Report failing when using 3 subject areasContent Hi I have a report pulling data from 3 different subject areas, which is failing despite they all include a fact from each, they all contain a common dimension (…Linda Stelling-61686 32 views 2 comments 0 points Most recent by Linda Stelling-61686 Reporting and Analytics for HCM
-
InfoletSummary The duplicate column is appering once click on the one of the column in the Trigger Report ( Expanded View)Content Hi All, I am facing the below issue can any on…Swaroopa Chenagarapu-130214 58 views 7 comments 1 point Most recent by Thiru Ch Reporting and Analytics for HCM
-
Report to track payroll entries transferred to SLAContent Hi, Is there a way to track the payroll costing entries which are transferred to SLA. We have a situation here where finance has confirmed that the totals in the…Lalith C 46 views 1 comment 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
How to find Standard Working Hours for a DepartmentSummary Need to report the Standard Working Hours for a department on employee reportContent On an existing report that contains the employee's standard working hours, I…Greg Wissler 78 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Employees with Work NumbersSummary Return report for all employees and just list work numberContent Trying to build a report that lists all employees and in the phone type column only return Work …Mike Borghoff 34 views 3 comments 2 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
OTBI Date DifferenceSummary Attempting to determine the number of days between record update and record effective dateContent I have reviewed other posts related to date difference within C…Ryan Davis-43690 122 views 10 comments 0 points Most recent by Joey Domhof Reporting and Analytics for HCM
-
Custom Report Running Error After Release 18CSummary Custom Report Running Error After Release 18CContent Hi Team, After Release 18C custom report we created is giving below Error. oracle.xdo.servlet.data.DataExcep…Vamshi Krishna 30 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
"Approval Delegate to others" table nameSummary "Approval Delegate to others" table nameContent Hi All, i have an requirement to get report of all the "Approval delegate to others" in oracle fusion .i am unabl…nitin Sharma 69 views 2 comments 0 points Most recent by nitin Sharma Reporting and Analytics for HCM
-
Report for Missing TimecardsSummary Employees without time card associationContent Hi All, We have a requirement to identify and report those employees that are missing time card association. I am …Sowdha Murugan 196 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Report for fields using in systemSummary Report for fields using in systemContent Hi Everyone , Do we have any standard report or SQL query ,which will identify all the fields in table which is linked w…nitin Sharma 41 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Pay Cost Allocation in OTBISummary Department Costing information in OTBIContent Hello Guys, Do you know which Subject Area I can find Pay Cost Allocation details? More specifically, I need to bui…Alvaro Couto 122 views 4 comments 0 points Most recent by Alvaro Couto Reporting and Analytics for HCM -
Improving Performance with Hierarchy ColumnsSummary Is there anything to speed up the performance of Hierarchy ColumnsContent Hello, I love the idea of the hierarchy columns. Having an easily expandable hierarchy …Rob F 48 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
URL to LSQL Analysis with ParameterSummary How to prompt on LSQL column so that assignment_id can be passed in URL?Content Hi guys, We have a Logical SQL analysis which we'd like to embed on the app scree…Pavel Kartuz 51 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need to display current year as default value of a date parameter in BI publisher data modelSummary Need to display current year as default value of a date parameter in BI publisher data modelContent Hi, We need to display current year as default value of a dat…User_MC37Q 707 views 6 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Count the number of employees per FTESummary Report which present the number of the employees per FTEContent Hi, We tried to create an analysis that count the number of the employees per FTE (Full-Time Equi…Yaniv 123 views 6 comments 2 points Most recent by Caroline Gladwin-Oracle Reporting and Analytics for HCM
-
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…Aravind Ragul-4349 33 views 1 comment 0 points Most recent by Aravind Ragul-4349 Reporting and Analytics for HCM
-
Overall Manager Rating Bar Graph - Display All ValuesContent We've drafted a performance related analysis from the Workforce Performance - Performance Rating Real Time subject area to capture overall manager rating distrib… -
Unable to query data in PER_ACCRUAL_PLANS_B and PER_ACCRUAL_PLANS_TL tablesContent Hi All, We entered Accrual data in the application. When we tries to query in BIP side we are not getting data from the tables (PER_ACCRUAL_PLANS_B and PER_ACCRU…Visu 28 views 4 comments 0 points Most recent by Bhagirath Raj Miryalkar Reporting and Analytics for HCM
-
Absences ReportSummary get the working dates between start_date and end_dateContent we have requiremnet to generate absences report, need help on sql query, If any empployee having abs… -
BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a singlSummary BIP Publisher Bursting:Can we burst a consolidated pdf file (having all employee records) to a single email idContent Hi, In BI Publisher bursting, we usually bu…User_MC37Q 105 views 6 comments 1 point Most recent by SantoshKumarBhairi Reporting and Analytics for HCM