Reports
Discussion List
-
Line Manager Dashboard - Wrong head count displayedSummary: Our current head count is 15000, but in the Line Manager dashboard it is showing only 1200 Content (required): Version (include the version you are using, if ap… -
Report showing employees not enrolled in benefitsSummary: Identify active employees not enrolled in medical that can be run at any time. This is not related to Open Enrollment. Content (required): Does anyone have a re…JHaden3 21 views 1 comment 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Using SUM function in Table Type Value set using FFSummary: Unable to get the sum function in table value set and how we need to get these values in query? Content (required): Here i am facing multiple rows for each diff…Janardhan ACS-Oracle 910 views 2 comments 0 points Most recent by Peeyush Chandel Reporting and Analytics for HCM
-
Edit in Oracle standard absence approval notificationsHi, I want to make edits to the standard notifications in Oracle, such as changing the mail's to and cc information or the title of the mail.and I don't know how and whe…Cansel Karasoy 41 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Formula for NOT Current Year ("Worker"."Employee Hire Date")Summary: OTBI report - Filtering on YEAR for field name "Worker"."Employee Hire Date" Content (required): I have an OTBI report where the data returned should be for emp…
-
management reportsSummary: Page concept in managment Reports Content (required): I need to select multiple location in my report, if the report is a FRS then I will use page concept but i…
-
Extracting data using BIP Publisher Report for REST API Load (Creating Timecard)Team, We have a requirement to create bulk time entries for employees (Copying previous timecard and creating the same timecard for current week - Dates differs) and we …
-
Is there a report/subject area/table/view that pulls all role/data access auto-provisioning rules?Summary: I am in search of a way to pull in all of the active auto-provisioning role/data access rules (rule name, conditions, assignments (associated roles, associated …
-
Web Reports or Narrative reportingHello Community - we are currently on PBCS for budgeting and forecasting for P&L. Business are using custom report on excel which uses excel add in and get essbase value…
-
Can we restrict otbi reports such that only manager can be able to see direct reportees?Summary: Manager should be able to see complete details of an employee who is reportee to him/her? Can we use any restrictions in otbi reports such that only manager can…Kurva Paramesh 11 views 2 comments 0 points Most recent by ROOPESH MADAN-Oracle Reporting and Analytics for HCM
-
Query bursting combined with Union AllI prepared a report using more than one UNION ALL and I want to send it as a notification, for this I prepared bursting and used it from the FROM condition of the first …Cansel Karasoy 192 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Calculating Past Experience of employees in HCM BISummary Calculating Past Experience of employees in HCM BIContent Hi; I was trying to calculate the total past experience of the employee in BI with the below formula bu…User_2025-01-22-18-29-47-758 126 views 3 comments 0 points Most recent by Vishnupriya Reporting and Analytics for HCM -
Reporting on approval transaction commentsSummary Reporting on approval transaction commentsContent Is it possible to report on the comments submitted under Attachments and Comments section for approvals not yet…Emily R 193 views 17 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
BIP - Organization HierarchySummary: Hello, Does anyone tried creating report in BIP with organization hierarchy details? For example: Enterprise Division Business Unit Department Level 1 Departmen…
-
Query to get time card approver name and approved dateSummary: I need query to get time card approver name. Content (required): I need query to get time card approver name. Version (include the version you are using, if app…Swati U 2.3K views 4 comments 0 points Most recent by Durgadevi-Oracle Reporting and Analytics for HCM
-
New hires are not showing in SQL reportSummary: New hires are not showing in SQL report. We created report by using Data model. When we export the report, there are not some new hires in it. Content (required…
-
Static/Reference Variable does not work for embedded reference doclet reportI have a Report Package which has a management report as an embedded reference doclet. I want to use static/reference variables in this embedded reference doclet but I'm…
-
Report for Equal Pay Registration Certificate in IllinoisSummary: Has anyone built a report for the Equal Pay Registration Certificate now required in Illinois? Attached is the template we were provided, which is missing quite…Melissa Gettman 12 views 1 comment 0 points Most recent by Jeremy Miller-Oracle Payroll and Global Payroll Interface (GPI)
-
produce cost centres from 2 area onto one reportSummary: extracting table tables onto one report Content (required): I'd like to be able to validate the date between cost centres show in "Departments" in HCM vs " Cost…Jeanette.Spalding 2 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Custom report to see who is listed as Read Only AccessSummary: Hi, Our Audit team would like a security report that lists everyone we have setup for READ ONLY access under Manage Administrator Profile Options Content (requi…Darrin N 11 views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
Financial Reporting Report failing after dimension uipdateSummary: Hi everybody, i have a quite complex P&L report with a lot of aggregation that takes 20 seconds to open. After a db refresh due to dimension update (about 6 dim…
-
Core HR Seeded report.Summary: Hi Expert, Does anyone one have core hr seeded report path, where I can see all seeded report. If possible, please share the document. Thank you! Content (requi…Mohammad Afghan 52 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Learning item access group -BIP table to fetch Person Number List details for Learning access groupSummary: I am working on one BIP report where I am fetching one column to learning access group members using Person Number List options. In which table the person numbe…Kamini Kaushik-Oracle 41 views 1 comment 0 points Most recent by Erika B-Oracle Reporting and Analytics for HCM
-
Can we change sign of accounts based on rules in EPRCS?Summary: Need crete a report with base level accounts where signage change required based on Account Number . Account starting with 1 Series -> + Ve 2 Series -> - ve and…AlokPriyadarshi-Oracle 21 views 3 comments 0 points Most recent by AlokPriyadarshi-Oracle Narrative Reporting
-
User ID impersonation to Data sourceSummary: User ID impersonation to Data source Content (required): When we are creating NR reports, we are giving Datasource connection hardcoded with Administrator Crede… -
Display multiple selected Prompt Members in Report Text HeaderOur report is set up to allow a user to run a report for one or multiple members of an Attribute dimension (the "Section" attribute dimension.) This is accomplished usin…
-
Change alias on the sender email IDContent Currently, when scheduled reports are received, they come from planning-test-[zone name] . Is it possible to change the alias (planning-test-[zone name]) to some…
-
there are a function or conditional that allow merge names to don't repeat?Summary: Guys, I'm creating a table where the intercompany dimension must be in a column and I'm using the level 0 function. The point is that I don't want the name of t… -
Change of Owner in Catalog FoldersSummary: What are all the actions that trigger the change of ownership for folder, sub folder and reports under it? Please explain in what all cases "System Account" is …