Category 81
Discussion List
-
SQL to get Fast formula name that feeds (computed) value to input value of another elementSummary: Please share any SQL to get the name of the fast formula that feeds the computed value to input value of another element. Content (required): Version (include t… -
ORC fields mapping with HCM TablesSummary: We're looking for mapping documents to associate each ORC field to the correspondent item in the HCM tables (e.g. ATTRIBUTE_CHAR1 etc) Content (required): Hello…gguittini 32 views 1 comment 1 point Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM -
OTBI report logic to fetch Employees who were in current position as of 1st June,2019Summary: We have a requirement to create an OTBI report which will fetch all Employees who were in current position as of 6/1/2019. I was looking at the subject area - '…Sovan Mishra-Oracle 128 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report on all the comments that the enrolled users have done in Enrollee Self-service conversationSummary: Content (required): Hi there I want to run a report on all the comments that the enrolled users have done in Enrollee Self-service conversation in a course. Is …Bobby Jourdan 14 views 2 comments 0 points Most recent by Bobby Jourdan Reporting and Analytics for HCM -
How to find 'User Defined Column' within Compensation PlanSummary: Can anyone help locate this field within a Compensation Plan. I need to find "Numeric Column 18", preferably within a Subject Area or if it's only within a tabl…Andrew_Schmitz 38 views 5 comments 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
Join "Approval Notification Archive Real Time" & "Transaction Administration Real Time" subject areaSummary: How to join Human Capital Management - Approval Notification Archive Real Time & Human Capital Management -Transaction Administration Real Time subject area Con…Nikhil Bhandari 357 views 3 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Performance Task Next Step BIP ReportSummary: Creating a BIP report for Performance Tasks showing Step/Next Step Content (required): We have a BIP report for the Performance Task Steps which include Task St… -
Report to Audit object migrationsSummary: A report that shows who created/updated application objects (i.e. Fast Formulas). Content (required): Version (include the version you are using, if applicable)…Wayne Smith 34 views 2 comments 0 points Most recent by Paidiparthi Ravindra Reporting and Analytics for HCM
-
To develop a BI report with calendar functionality.Summary: Need to develop a BIP report which uses bursting functionality and when ever mail triggers, it gets automatically saved in the the calendar of the mail just lik… -
How to see multiple values in new line in Oracle SQLSummary: Content (required): I need to develop a BIP report for talent profiles. As per the business requirement, I need to display multiple values (Ex. Skills, Language…Prajna Hegde 25 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
Subject Area filtering - empty valuesSummary: Subject Area filtering - empty values Content (required): Subject Area filtering of Assignment Type filters out empty values as well. For example, if we have pe…User_2025-02-11-21-40-21-159 23 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need SQL to get Element Duration DatesSummary: Need SQL to get Element Duration Date, that is at assignment level. Content (required): Need SQL to get Element Duration Date, These dates are present in 3 leve…Raghavendra M 192 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Succession Planning BIP ReportSummary: Content (required): Hi All, As per the client requirement, I am trying to create a BIP report for listing the incumbent (person) specific and position specific …Prajna Hegde 26 views 8 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
Data StrategySummary: I am in need of running a report that pulls how many minorities in a certain grade were promoted to an officer status. Please help guide me to the correct subje…User_2025-02-11-00-58-38-371 23 views 2 comments 0 points Most recent by User_2025-02-11-00-58-38-371 Reporting and Analytics for HCM
-
How to embed Logo/Images in BI Publisher RTF Template in HTML Output formatSummary: How to embed Logo/Images in BI Publisher RTF Template in HTML Output format Need to Embed Logo in HTML output format for BI reports Template. Options Content (r…Kaustubh Deshmukh 12 views 7 comments 0 points Most recent by Rajesh.Vadlamani Reporting and Analytics for HCM
-
Need sample analysis/SQL to get various balance values for each assignment for EE with multiple GTSummary: When global transfer happens for any employee, we need to validate various balances to confirm if they are transferred to the new LE. During a year if an EE is …
-
Average Salary for Job over TimeSummary: Need average salary for a job code over time Content (required): Is it possible to look at average salary for a job code month over month? Version (include the …Riti Malhotra 23 views 12 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How to join 2 tables without common column in SQLSummary: Content (required): How to join 2 tables without common column in SQL and get the columns from both the tables side by side? I tried using the CROSS JOIN and UN…Prajna Hegde 34 views 2 comments 0 points Most recent by Prajna Hegde Reporting and Analytics for HCM
-
How to use the Min aggregate function along with group by clause in OTBI analysisSummary: I have a requirement to build analysis to fetch all the benefit enrollment data for a participant as well as dependent. I need to fetch the actual enrollment da…
-
Report to fetch Element with assignment number and name for employeesSummary: i am using the below SQL to fetch the details. But the SQL is taking time to fetch the details. Can anyone please let me know if my i am missing any join Conten…minati_behera-Oracle 22 views 1 comment 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Sum of Distinct/Unique values in Header for ETEXT templateSummary: Sum of Distinct/Unique values in Header for ETEXT template Content (required): I have 4 records for same person in my xml. All 4 records have same salary($2000)…Jaeyshree Kumaran 484 views 5 comments 0 points Most recent by Jaeyshree Kumaran Reporting and Analytics for HCM
-
Turnover for a Certain PeriodSummary: Is it possible to report on period start headcount and period end headcount for anytime period instead of month start and month end from the Workforce Trend Rea…Anita 13 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Seeded report to get every earning/deduction/taxes of any specific employee during a date rangeSummary: Need to know if any seeded report exist that we can leverage to get details of every earnings/deductions/taxes of any specific employee during a pay period or f…
-
SQL to get Fast formula name that feeds (computed) value to input value of another elementSummary: Please share any SQL to get the name of the fast formula that feeds the computed value to input value of another element. Content (required): Version (include t…
-
How to Burst a BIP report (Excel format)Summary: Hi All, I have a business requirement to send an attachment to each of our vp's with their employees I have created a SQL with my information that has a paramet…User_2025-02-04-08-51-08-912 1.2K views 6 comments 1 point Most recent by Kevin M-Oracle Reporting and Analytics for HCM
-
how to auto run an analysis with promptSummary: I have created an analysis with prompts. I want that when an analysis is run, it should display the output with default prompt option 'All Column Values'. Curre…Dilpreet Kaur 34 views 5 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Embedded Reports and the environmentSummary: Every time we take a release, I have to relink all of our embedded reports to point to our TEST environment. Content (required): Is there any way that we can ha…User_2025-02-04-08-51-08-912 3 views 2 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
Reporting Requisition Detail with Pending Worker DetailSummary: We have a requirement to report all Pending Workers which works fine, but we also need to include some basic Requisition detail such as Req Number and Title. Wh…Emily Robinson 33 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Back end table storing Costing type and Distribution groupSummary: Please share the back end table and column names storing costing type and distribution group name Content (required): HDL load fails with message A distribution…
-
Excel formula in BI reportSummary: Need to include excel formula like DATE and DATEIF based on hire date pulled in one column Content (required): Hi Our requirement is to calculate a date using e…Poornima Paliwal 35 views 4 comments 0 points Most recent by Poornima Paliwal Reporting and Analytics for HCM