Reports
Discussion List
-
CBCR automation configuration issueSummary: Could not configure CBCR automation to populate data in CBCR report Content (required): Our TRCS gets data from FCCS. We tried following approach with Oracle su…User_2025-02-11-20-21-37-906 1 view 2 comments 0 points Most recent by User_2025-02-11-20-21-37-906 Tax Reporting (Direct Tax) -
Latest Assignment Row in OTBISummary: How to get the latest assignment row in OTBI Report Content (required): I am looking to develop a OTBI report to fetch the latest effective row in assignment. C…Manoj B. Cheruvathoor 328 views 4 comments 0 points Most recent by Manoj B. Cheruvathoor Reporting and Analytics for HCM -
OTBI Report to identify the populationSummary: Our client has asked that I share a report that identifies the population. Is there anyone who knows how I'll be able to do it? Could you please send me a sampl…Hazel De Castro 12 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Audit FRS report usage in PBCS?Summary: Audit FRS report usage in PBCS? Content (required): Is there any means to get a last run date by report name in PBCS for the FRS reports? Version (include the v…
-
Does BI Consumer role has data access to reports?Summary: Content (required): Does BI Consumer role has data access to reports? If a user has BI consumer role, he can access reports, but how to control reports data sec…
-
OTBI report to Fetch Details of learning items assigned based on learning user groupsSummary: Hi Team, I am working on one OTBI report requirement - to fetch the details of learning course completion eg. learning item name, course completion date e.tc. T…Kamini Kaushik-Oracle 163 views 0 comments 1 point Started by Kamini Kaushik-Oracle Reporting and Analytics for HCM
-
OTBI Report filter using Date of BirthSummary: Unable to filter data based on a specific DOB Content (required): Hi All I have a requirement to filter contingent workers whose DOB is equivalent to 01/06/1960…Ridma Karunanathan 21 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Issue with project task hierarchy on BIP reportSummary: The same report is displaying the task hierarchy differently in test and prod environments Content (required): The same report, migrated from one environment to… -
Additional Criteria Dropping out International EmployeesSummary: I have a report built that is supposed to show everyone that is Active as of a certain date along with their job information and some personal information (phon…Kyle Norris 11 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Phone Number Format in OTBI outputSummary: We created an agent to send employee data from HCM to Service Now twice daily. This includes phone number. However, the requirement is to not include the countr… -
How to control data security on the catalog reports for a custom HR specialist role?Summary: Content (required): What controls catalog reports data access? Should a custom 'Human Resource Analyst' be assigned to a security criteria? If I add access to a…Mostafaaa 31 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Reporting on FCCS cube in EPBCSSummary: Hi all, Is it possible to draw up a report (or rather a grid in a report) in EPBCS with FCCS as the selected data source? I know it is possible to do so in Narr…
-
Can you change the date format in all the columns that have dates so that it filters by year/MonthSummary: we are using excel template to generate the excel output.Can you change the date format in all the columns that have dates so that it filters by year/Month? Thi…minati_behera-Oracle 31 views 2 comments 0 points Most recent by Abhishek Premchandra-Oracle Reporting and Analytics for HCM
-
Restrict Report Folder movements in the BI catalog areaSummary: Hi Experts, How do we restrict Folder Movement (Drag and Drop option) of BI Catalog Custom Shared Folders? Is anyone can advise on this? Recently we had a bad e…Mithun Abhisheka 101 views 2 comments 0 points Most recent by User_2025-03-07-21-51-04-421 Reporting and Analytics for HCM -
Sub query in Case Statement in OTBISummary: Hello , I would like to know if we can use subquery in case statement using OTBI Reporting subject areas . For Input Value , 'Payout Date 3' , I need to get the…User_C36BE 771 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Import Project Budget error message-A budget Version in Submitted status already existsSummary: Hello I am trying to upload a Budget through FBDI template, however I got the following error message. Will you please let me know how the remove the budget ver…
-
'Check' Function in Data Management giving error if we use alternate hierarchy for Entity in FCCSSummary: Im using 'Check' feature in Data Management (4th fish in Import-Validate-Export-Check ) 'Check' is giving me error if I use alternate hierarchy for entity dimen…Srinivas Hindupur-Oracle 54 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Border Display Issue in HTML Preview of ReportSummary: In HTML Preview Border doesn't show Properly. But in PDF it shows correctly. Content (required): In HTML Preview Border doesn't show Properly. But in PDF it sho…Ayush Khandelwal 31 views 1 comment 2 points Most recent by Dave Roberts_-Oracle Narrative Reporting
-
HCM Extract for Payroll ProcessHi We have requirement to get employee details who are processed in a payroll based on the given period start and period end date , so we are planning to create extract …
-
Filtering turned on for excel templateIs there a way to create an excel template so that filtering is automatically turned on when the excel report is generated? (I know you can set the 'freeze' view...so ma…
-
OTBI to fetch vacant and filled positionsSummary: We have a requirement to create an OTBI report which will fetch position details alongwith Employees present in those positions. Besides that, we also want to f…Sovan Mishra-Oracle 1.2K views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
OTBI report - export to Excel limitationSummary: We have OTBI reports that will exceed the 50,000 field limitation for exporting to Excel. Content (required): Can you "schedule" an OTBI report to get around th…User_2025-01-28-20-19-02-475 73 views 2 comments 0 points Most recent by Ghanshyam M-Oracle Reporting and Analytics for ERP
-
How to remove unwanted Folders on Catalog?Summary: Content (required): How to remove unwanted Folders on Catalog? Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
How to Fetch Employee level details from comp worksheet and budget details in an OTBI reportSummary: We have a requirement to fetch comp worksheet details (i.e. Manager Recommendation amount based on department VS Budget Amount allocated for the employee manage…User_EJ1U2 51 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM