Reports
Discussion List
-
sql to get the HCM extract failure list for specific datesSummary: Need to create report which gives extract failure details. Code Snippet (add any code snippets that support your topic, if applicable): Im trying below sql to g… -
Excel Template error 'Maximum active cells allowed in a template is 100000'Summary: Hi Team, We are trying to create a report using the Excel template since there are a lot of tabs expected in the Excel output. We are getting the error 'oracle.…Tanu Shri Patel 231 views 6 comments 0 points Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
Submitting Extract with Parameter Date for output file name not working as expected.Summary: Submitting Extract with Parameter + Date for output file name not working as expected. Please see attached for detail screenshots. It should have file name with…
-
Is there any way to control displayed size for name of DFF not input column?Summary: Is there any way to control displayed size for name of DFF not input column? I set DFF in Project Billing Event and I would like to displayed DFF without line b…
-
Report post migration from Financial Reports - how to evaluate difference 2 text values in Reports?Summary: We have started the migration process from Financial Reports to Reports for PBCS Planning. One issue we have discovered post migration is a common formula that …
-
Would it be possible to further understand the HR Dashboard - Birthday Reminders tab?Can we have support on the following for this Birthday Reminders tab in the HR Dashboard? https://fa-eups-saasfaprod1.fa.ocs.oraclecloud.com/analytics/saw.dll?Dashboard …
-
HR Dashboard - Compensation Tab - Where to find where data is coming from and how to hide data?On the out-of-the-box HR Dashboard (Reporting > HR Dashboard tile), is it possible to know where this data is being pulled and if there can be an extract of the data? Th…
-
OTBI - recruiting - recruiting real time > Job Application issueSummary: Hi everyone, I'm customizing the 'Applications by Requisition' standard OTBI analysis. Trying to add the candidate Interview feedback field in the current analy…Saher 21 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
OTBI report only showing an individual's supervisor and managerSummary: I have a requirement to create a report showing each workers named supervisor and line manager (mostly these are the same person, but in some cases they're diff…Rich M 41 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dashbord prompt issueSummary: Hi, I need assistance concerning the OTBI Prompt. I created a recruiting OTBI dashboard by combining two subject area subject areas in my report, 'Recruiting - …
-
Assigned Performance Document Manager not showing Assigned Indirect DocumentsSummary: I have created a dashboard that includes an OTBI report showing Performance Documents by When I run the report I can see all the Performance Documents assigned …Aaron Reynolds 21 views 1 comment 0 points Most recent by Andrew Gillibrand-Oracle Reporting and Analytics for HCM -
How to add Analytics section to homepageWe've been trying to embed some infolets on our Oracle Cloud homepage, however it appears that most users (at least it seems that way based on Cloud Connect posts, YouTu… -
SQL query to extract employee CVHow can I extract the employees with a CV, in a BI Publisher report? Which is the SQL query that can I use? Thanks in advance!Gian Luca Triglia 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Burst Report By Managers and Email to Individual ManagersSummary Burst Report By Managers and Email to Individual ManagersContent Hello everyone, I have a requirement where I want to create a BI Publisher report that groups em…Daniel McMillian 487 views 9 comments 0 points Most recent by Karthick_Sathasivam Reporting and Analytics for HCM
-
Benefit:Certifications and Action Items tables informationContent Hi All, We have a requirement to fetch "Certifications" and "Action Items" tab related data in the BIP report. May I know in which tables holds this information …
-
In (Fusion HCM)Seniority Date Page How to hide custom field based on selected Rule from Drop DownREQURIMENT: When we select the Rule Is Job Seniority Date section from the drop-down list then the custom field is Seniority Date report needs to be visible under Senior…Ravindr-Oracle 72 views 1 comment 0 points Most recent by Aliasgar Khambhaty-Oracle Human Capital Management
-
Trouble converting Double to Decimal/Numerichttps://us.v-cdn.net/6034893/uploads/9VSYBPB2KHPU/deduction-conf-layout-template.docx Summary: Attempting to create a BI report which creates a file for sending via SFTP… -
Can we implement e-sign on the offer letters through offer letter DM in Oracle HCM?We are looking to implement the E-Signs for offer letters while they are mapped to the Job Offer Letter Data Model. Please guide on the feasibility of this question on w…Jaivanti Dhokey 31 views 3 comments 0 points Most recent by Shikha Agarwal Reporting and Analytics for HCM
-
How to get the actual Effective Start Date of the Grade assigned to the employee?I'd like to fetch the effective start date of the person's Grades. The actual date when the Grade was assigned to that person. Because currently I'm using the following … -
How should I define all parameters as multiple selection in sql report?Parameters are defined in this way in the SQL report I prepared.In this way, I can make more than one selection in the location with the parameters.But for example, when…Cansel Karasoy 41 views 12 comments 0 points Most recent by Stephan Steup - ITUP Reporting and Analytics for HCM -
Seniroty Dates in BIP querySummary: We are fetching seniority date from the record per_seniority_dates_f record for continuous Service Date . We have observed that for one of the person Number the…Debarun Baidya 21 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Is there a way to restrict the data visible to users based on their Area of Responsibility (AOR)?Summary: A report has been created that includes positions, and users with access to it are able to see all positions when opening the report. Is there a possibility to …Christian Suarez 112 views 4 comments 0 points Most recent by Adam Jory Reporting and Analytics for HCM -
Case when statements to evaluate values based on a groupSummary: Content (please ensure you mask any confidential information): I am working on an OTBI report based on the Workforce Management - Checklist Real Time subject ar…Giuseppe Cannova 41 views 7 comments 0 points Most recent by Giuseppe Cannova Reporting and Analytics for HCM -
Duplicate element entry report with entry detailsSummary: I have a requirement where I need to report on more than one element entry for a person where the input values differ. Attached is the OTBI analysis details on …Vibha Pandey - Oracle 31 views 3 comments 0 points Most recent by Anca Andronic-Oracle Reporting and Analytics for HCM
-
Filter Inactive Requisitions in ReportsSummary: Inactive requisitions can be filtered on application by selecting the check box filter. What is the corresponding column (OTBI or BIP) which can help to filter …
-
Dhajani Perera 1 view 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM
-
Need a Sample SQL to fetch Benefits Enrollment Data using a Batch Name from HSDLSummary: I have loaded the Benefits Enrollment using HSDL where we provide Batch Name. My requirement is that using the Batch Name as a parameter, I need to fetch the lo…Sujeeth Chinta 1K views 1 comment 0 points Most recent by Andreea_Nuck-Oracle Reporting and Analytics for HCM -
How To Add A New Column With Custom Date FieldSummary: I have an OTBI report where I need to add a column (see expected date column below) that when there is a Termination Date it shows the Termination Date BUT when…
-
Details of employees who are having the access of respective modules.Hi Everyone, For audit reason We have received an requirement where our need to is to get details of employees who all are having an access for respective modules and al…Jebarsan Thangam John Durai Raj 11 views 0 comments 0 points Most recent by Jebarsan Thangam John Durai Raj Reporting and Analytics for HCM