Global HR
Discussion List
-
Get Journal Entries Details For An EmployeeSummary: Team We would need to fetch Accounting Date & Transaction Number From Journal Entries. (GL) For An Employee Columns are: Accounting Date Transaction Number Payr…Manoharan 541 views 1 comment 0 points Most recent by Raluca.S - Fusion GL Oracle-Oracle Reporting and Analytics for ERP -
need sample query with time card submission statusSummary: need sample query with time card submission status (Saved,Submitted, Approved etc) Content (required): need sample query with time card submission status (Saved…Ishtiaque AHmed 112 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Reporting and Analytics for HCM
-
Unable to Join Multiple Subject AreasSummary: Unable to join "Workforce Management - Absence Real Time" Subject Area with "Workforce Management - Worker Assignment Real Time" Content (required): Our require…Jyothi Gorantla 31 views 4 comments 0 points Most recent by Jyothi Gorantla Reporting and Analytics for HCM
-
EEO Reporting for Federal, State and LocalHi all, Is there any document which tells us more about "Submit EEO-4 State and Local Government Report for US". Thanks, Sathish -
HR Action Original creation dateSummary Report on HR Action original creation dateContent Hello, Has anyone written a report of HR Actions history that includes original action entry (creation) date? I…User_2025-02-04-15-06-22-759 81 views 5 comments 0 points Most recent by Scott Conaway Reporting and Analytics for HCM -
Filter Person Number Using Copy PasteSummary: In an OTBI Analysis, is there a way to filter a column based on a copied list of values? For example a column from an excel file or a comma separated list. For …
-
Hire Date, Start Dates and Seniority DatesContent We are frequently asked about hire dates, start dates and seniority dates. Please find the relevant help topics below: Seniority Dates Explained Seniority and Se…Julian Challenger-Oracle 368 views 6 comments 2 points Most recent by Matty S Reporting and Analytics for HCM -
Associate Roles with the FUNCTIONAL modules.Hi Experts, I have a question on the Roles defined in a Fusion Instance. Is there a way to associate a role with the module where it actually comes into play? I'm trying…Aloka Bhattacharya 21 views 0 comments 0 points Started by Aloka Bhattacharya Reporting and Analytics for HCM -
Need inputs to use all secure views in the reportSummary: Need inputs to use all secure views in the report Content (required): If we want to display Core HR data like Person, Assignment, Position, Job, Department..etc…
-
How to get list of roles from systemSummary: Content (required): Hi Expert, We have a requirement to get all the roles we have in the system. So we just wanted to know how to get all the roles. Please sugg…Faizan Rashid 41 views 9 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Headcount for last day of previous monthSummary: Headcount for the last day of the previous month. Content (required): I would like to create a report that lists the Headcount for the last day of the previous …
-
how to add a manager email as cc in a bursting report sqlSummary: I have a report which i'm trying to schedule, but i'm stuck at the cc part. i need to add the manager in the cc field. below is my sql, how do get the manager v…
-
ODBC Error - ADFService11g on OTBI AnalysisSummary: After 22B went into our Test environment, a report built on a few subject areas no longer works. It is giving us the following error: State: HY000. Code: 77031.…
-
Hourly Rate FormulaSummary: I have a report using the subject area Compensation – Salary Details Real Time and need to add a formula that calculates a base hourly rate. Here is what I'm lo…JHaden3 121 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Date Match Formula ErrorSummary: Date match formula errors when I run the report. CASE WHEN "Work Relationship Details"."PER_PPS_LEG_DDF_ST_BS_SR_STRT_T_" = "Workforce Management - Worker Assig…
-
OTBI Report Performance IssueSummary: OTBI Report Performance Issue Content (required): Hi Team, We have developed the turnover dashboard using "Workforce Management - Workforce Trend Real Time" sub…Vasanthakumar Ravi 81 views 1 comment 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
HCM Extract xsl template to generate formatted XML Output that almost replicate original xml outputSummary: HCM Extract xsl template to generate formatted XML Output that almost replicate original xml output. We just need to get rid of the duplicate output that is usu…
-
OTBI filter to compare two attributesHello, We're building an OTBI Analysis that compares, for each employee, the competency’s rating given by his/her line manager in a Performance Document and the minimum …gguittini 61 views 4 comments 0 points Most recent by Jahnavi-Oracle Reporting and Analytics for HCM -
Most recent salary record (Active and Termed)Summary: I have a report using the subject area Compensation – Salary History Details Real Time. I need the report to display only the most recent salary record for both…
-
Need inputs to display Dependent and other information side by side in OTBISummary: Need inputs to display Dependent and other information side by side in OTBI Content (required): We developed Benefit OTBI report. Currently if an employee is ha…
-
Adding People Group to Workforce Trends/Payroll Run Results Subject AreasSummary: Adding People Group to Workforce Trends/Payroll Run Results Subject Areas Content (required): Version (include the version you are using, if applicable): Code S…
-
Need to report on how long is it taking for managers to approve their tasks in a particular workflowSummary: We need a report from the workflow side of things to give us insight into how much is each manager taking to approve their tasks. Content (required): This is a …
-
XLA_TRANSACTION_ENTITIESSummary: Team, How to join XLA_TRANSACTION_ENTITIES with Payroll / Assignment Tables and Get Person Related Transactions. Any idea would be highly appreciated. Thanks in…
-
Assignment DFF - Approval/FYI NotificationHi all If a manager changes DFF's in an assignment, it is sent for approval to a specific role. Some of the people receiving the notification don't see the changed DFF's…Annelies Van Erom 31 views 1 comment 0 points Most recent by Rambabu Laveti-Support-Oracle Human Capital Management
-
how to create extract such that it should only give the record for which department has changed.Summary: how to create extract such that it should only give the record for which department has changed. Content (required): This is change only extract. I have created…
-
Need Employee wise data where Checklist Response Text and Response answer in same row using OTBITrying to create an OTBI report from a survey which consists of both Response answer type and Text answer type questions. The report should show employee details, checkl…
-
BIP: How to create 'Year' parameter?We have a requirement to provide Year parameter as a dropdown in BIP report. It should default to current year, and allow users to select any other year from the drop do…Anshul Rai 71 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
How to avoid overlap labels in BI Pie chart?Summary: Our customer is using HCM cloud and developed some dashboards and it has some pie chart and labels are overlapping each as shown in the attachment. How to fix t…Peoplesoft 51 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM