Reports
Discussion List
-
Does anyone know in which table 'Domicile state other than the District of Columbia' field is storedSummary: I am not able to find in which table the State card component 'Domicile state other than the District of Columbia' field from calculation card (Tax withholding …SowmyaSk 41 views 1 comment 0 points Most recent by Raju Sandepogu-Oracle Reporting and Analytics for HCM -
How do I show all completions for same Course Title in OTBI report?Summary: OTBI report to show completions only shows first completion if title is the same. Need to get OTBI report to show the same data as the View Transcript (which ca…Aaron Reynolds 82 views 6 comments 0 points Most recent by Aaron Reynolds Reporting and Analytics for HCM -
Reporting on count of incomplete/complete Journeys in OTBI?Summary: For OTBI analyses - our organization needs to be able to report on the following in the Workforce Management - Checklist Real Time subject area: 1) Total number…William_Johnson 491 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
EPM Budget Revisions - Reporting ideasSummary: How are Budget Revisions users reporting on the revisions? Content (required): I have had many requests to build EPM reports that show various revision data aft… -
Impact Rating Model column filter breaks analysisSummary: Subject Area: Workforce Profiles - Person Profiles Real Time Column: Impact Rating Model Content (required): Hi All, We run into an error under the Workforce Pr…William_Johnson 21 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
What is the best way to implement ECC200 data matrix in oracle reports?Summary: Need to add a 2d data matrix to report letters that will store a string of numbers. The ECC200 data matrix does not seem to be currently supported by Oracle so …KevinCochran 42 views 1 comment 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
End Dated values no longer appear in OTBI reportsSummary: We have end dated a number of Sickness Reasons (sub reasons), which used to pull through on OTBI reporting, these no longer appear after being end dated Content…Luke Harrison-126889 42 views 1 comment 1 point Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Subject Area for Workflows & Approvals?Summary: I need to do a review of all of the Workflows & Approvals, and would like to be able to export them all, as is to avoid going through each one, one-by-one. Is t…Jessica D 363 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Is it possible to customize AbsenceApprovalEmailNotification report to get Absence Balance included?Summary: We need to somehow modify the data model so that the absence balance of the absence type from the absence request gets displayed on the report. Content (require…bervin13 51 views 2 comments 1 point Most recent by Michelle Juergens Reporting and Analytics for HCM -
sFTP connection is failing with 503 error after whitelisting Oracle given IPsSummary: sFTP connection is failing with 503 error after whitelisting Oracle given IPs Content (required): Our system was upgraded with 23A over the weekend and after th…
-
Is there a query for fetching LinkedIn profile details in BIP report? Which is the table for that?Summary: To fetch linkedin profile details in BIP SQL report. Which table needs to used to achieve this requirement? Content (required): Version (include the version you…Hemanth Kumar Muthyala 31 views 1 comment 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How would we restrict the access of Hiring Manager to the other reports in a Dashboard?We have Dashboard A where Hiring Managers has access to. Inside the Dashboard A, we have a couple of reports (eg. Requisitions, Candidates, Hiring Manager requisitions).…
-
Showing supporting details for a row or cell in MR reportSummary While showing data from EPBCS/FCCS for some accounts have supporting details to show in reportContent We are having data sources from EPBCS and FCCS. There are s…
-
How to make a drop down Prompt, in a Report based on an Analysis, work?Content (required): I've created the Analysis. Which is used as the Datasource for a Dataset in a Datamodell. The Datamodell is used in a Report. I want to create a Prom…
-
Area of Responsibility ReportSummary: Wondering if anyone has a working Area of Responsibility Report they can share? Content (required): We're struggling to get our AoR report working, created as a…
-
How do I suppress trailing zeros in my RTF template for comp statementSummary: How do I suppress trailing zeros in my RTF template for comp statement Content (required): I have tried both ’999.999999’ and ’D999999’. If a number has 6 decim…TerryM01 51 views 2 comments 0 points Most recent by Indra Sardana-Oracle Reporting and Analytics for HCM -
How can we get the Ess job 'Approval Groups Report' output files as attachments on email?Summary: We were trying to run the ess job on ERP cloud called 'Approval Groups Report' and get the output files on mail as attachments. But we were not able to see the …sunny.k.singh 95 views 2 comments 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Values appearing in alternate lines when exported to excelSummary How to have just one line of valuesContent Hi, The Risk of Loss and Impact of Loss fields are not aligned on a single line of data, instead there is a NULL inclu…User_2025-02-05-22-44-35-842 36 views 4 comments 2 points Most recent by William_Johnson Reporting and Analytics for HCM -
HCM Extract: No Output when Fast formula is added to ExtractHi Team, I need to get the Assignment Effective Start Date based on some conditions using a Fast Formula. My fast formula is working fine because I wrote logs for each f…Chaitra Lakshmi Krishna 34 views 2 comments 0 points Most recent by Chaitra Lakshmi Krishna HCM Extract
-
Conditional Columns based on ParameterSummary Report Layout change based on ParameterContent Hi , I am using the "Receivables - Payment Schedules Real Time" subject area I want to have a parameter of Entered…Soumya Prakash Parhi 44 views 3 comments 4 points Most recent by Soumya Prakash Parhi Reporting and Analytics for ERP -
Restrict POV Members Based on User SecuritySummary: Restrict POV Members Based on User Security Content (required): Is there a way in Reports (MR, not FR) to filter the list of members displayed to be based off o… -
Allocated Checklist Status Code in Workforce Management - Checklist Real TimeSummary: Hi All, Is anyone aware of what/where information in this column would pull from in the system? What would value "WAI" represent? Subject Area: Workforce Manage…William_Johnson 62 views 4 comments 1 point Most recent by William_Johnson Reporting and Analytics for HCM
-
Access to tables which holds FCC Audit dataSummary: Hi All, Do we have access to tables which holds the FCCS Audit data in relational database? if yes, can you please share the name and tables structure of the ta…
-
Data Source Name in the Narrative ReportingSummary: Content (required): Hi Experts, In the Narrative Reporting, we are getting data from multiple sources e.g. PBCS, FCCS and, ERP. It's difficult for the client to…
-
Division showing blank for Performance task status real time subject area in OTBISummary: Org tree columns showing blank value in OTBI due to new org tree version Content (required): We have activated our new tree version from 1st jan 2023, since the…
-
Salary Range Report ALL Jobs (Active and Inactive)Summary: I have a requirement to produce the below OTBI report but if I use the Compensation Salary Detail Real Time, it only shows data if an employee is assigned to th…JHaden3 105 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
What is the equivalent of EBS Request Group in FusionSummary: I would like to know the equivalent of EBS Request Group in Fusion. For Example, I have a project accountant who needs to have access to run and view AP custom …Navaneeth TechM 61 views 1 comment 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
Report on Job Openings as of Last MonthSummary: I need to report on how many job openings there were as of last month. When I use the sql for last day of last month, the numbers aren't accurate as it is live …Jessica D 31 views 3 comments 0 points Most recent by Dawn C-Support-Oracle Reporting and Analytics for HCM