Category 81-2
Discussion List
-
Need Help with Permissions Required for HCM Subject AreasSummary: I've got a service account that we use to pull extracts into Casabase. We are getting access to all of the ERP and accounting subject areas. However, we are now… -
Monthly scheduled hoursSummary: Content (required): Is there a way in HCM to find the monthly scheduled hours for an employee? Does anyone how if this information is stored in a table? For exa…Nicolas Vahman 11 views 2 comments 0 points Most recent by Nicolas Vahman Reporting and Analytics for HCM -
Possible to report on which Succession Plans are associated with Review Content of Talent Review?Summary: We would like to be able to report on which Succession Plans have been associated with which Talent Reviews. Content (required): We would like to be able to rep…Vis Perera 1 view 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Filter Talent Review 9-Box to Most Recent RatingSummary: Measures calculating percentage of employees by 9-box rating are including old ratings that have been filtered out of the analysis. Content (required): We have …
-
Prepare Review Content example reportsSummary: Prepare Review Content Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to better engage our e…William_Johnson 22 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Workforce Talent Review - Talent Review Tasks Real Time reporting bug?Summary: How can we pull a report using this subject area to provide an administrative overview of all existing tasks in a Talent Reviews within the system? Content (req…William_Johnson 11 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Load the data into the custom content sectionSummary: Content (required): Hi Expert, We have created a custom content section ABC and there are some fields where we want to load the values in it. Please suggest if …Faizan Rashid 11 views 1 comment 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Query for Plans without Incumbents and/or candidatesSummary: Need assistance wtih querying plans that have no incumbent and/or candidates. Including Incumbent or Candidate counts appears to exclude plans that do not have …
-
Team Time Card BIP Query for Team information and approval status and Overtime Information.Summary: Need SQL Query for the Manager can view his team information of time and overtime information. Content (required): Version (include the version you are using, i…Ketan Prajapati 1 view 1 comment 0 points Most recent by Asmit Piyush Reporting and Analytics for HCM
-
Is it possible to report on time worked?Summary: Is it possible to create a report that list the hours worked for an employee? Content (required): We are trying to create a report to show if an employee is eli…Brandon Roberts 81 views 12 comments 0 points Most recent by Lisa Ellis Reporting and Analytics for HCM -
What table is the values in "Payroll Transfer Status" and "Payroll Processing Status" stored?The screenshot below is accessible in Team Time Cards: I was looking for how could I get the values for "Payroll Transfer Status" and "Payroll Processing Status" -
Getting duplicate record in OTBI reportSummary: Content (required): Hi Expert, We have built an OTBI report for talent meetings and when we are running the report there is a record that is coming multiple tim…Faizan Rashid 31 views 2 comments 0 points Most recent by Faizan Rashid Reporting and Analytics for HCM
-
Database Table name for Approval DelegationsSummary: We have a requirement to build a report for approval delegations, thus need the database table name for Approval Delegations. Navigation: Person Management > Se…JainSamyak 11 views 2 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM
-
Time Entry Audit Report for Reported timecards.Hi Team, I am trying to build a report, where we will show the Time audit details like Person Number, Time Type before change, Time Type after change , Timecard start ti…Khush Tiwari 11 views 1 comment 0 points Most recent by Khush Tiwari Reporting and Analytics for HCM
-
Parameter not working when embedding OTBI AnalysisSummary: Embedded an analysis on HCM page but it seems that the binding variable is not being received by the analysis because the report is not being filtered Content (…Jezreel Furagganan 31 views 0 comments 0 points Started by Jezreel Furagganan Reporting and Analytics for HCM
-
Generate Report with Timecard ApproverSummary: We need to generate a report with the time card approved date and who approved it. Content (required): I've seen this question asked a few times, but it doesn't… -
Time Entries SQL HelpHi Experts, we need to fetch all the time entries including Absences.SO for Absences we need to have a column for Absence Type.But i am not sure how can we find the abse…minati_behera-Oracle 31 views 4 comments 0 points Most recent by Rajdip Chavada Reporting and Analytics for HCM
-
I'm looking below columns in otbi or any reference reportSummary: Hi , I'm looking below columns in otbi or any reference report ,any help me on below columns. Thanks, Ajay Content (required): Opening EL leave balance /DOJ (Da…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Talent Profile: How can I make CLOB fields visible in a report?Summary: Talent Profile: How to make Job responsibility, - description and - qualifications visible in an analysis? Content (required): Dear all I need to create a repor…Matthias Essrich 21 views 3 comments 0 points Most recent by Mandeep Gupta Reporting and Analytics for HCM -
Need SQL for data model list of values for Time Card Time TypeSummary: I need to add a parameter to a BI Publisher Report that has the values from the Time Type field from the Time Card. I have the following SQL written for the lis…A.J. Wilkins 31 views 2 comments 0 points Most recent by Rajdip Chavada Reporting and Analytics for HCM
-
SQL or table to get the PAY_PAYROLL_TIME_TYPE ID of time and tasksgood morning experts We are working on a time and tasks report and we did not find the PAY_PAYROLL_TIME_TYPE ID, only the code and the name, could you help us with the S…
-
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 61 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Degree Reporting - Item Code not available in Subject AreaSummary: Hello there, I'm trying to create a simple analysis that provides a full list of Degrees and the Item Code. There doesn't seem to be a "Item Code" option to sel…
-
Display Performance OTBI Analysis to a user Without Giving AccessHello All, Appreciate the help in advance! We have a new office assistant who will be reviewing information like evaluation tracking, performance status, sick leave, etc…Gail Wilmoth 41 views 9 comments 0 points Most recent by Gail Wilmoth Reporting and Analytics for HCM -
BI Publisher RTF Template - Repeating GroupSummary: Team, we have a requirement to print the timecard details For each employee the header should be same and the Last Row Should Be Repeated. It would be really he…
-
Get Time Card Period (Employee Time Card Details)Summary: We have a requirement to get employee's timecard (timeentry details) ... daywise. We have got the measure (days) from the table hwm_tm_rec using the resource_id…
-
Formula for Data Submission Status in Talent ReviewsSummary: Subject Area: Workforce Talent Review - Talent Review Meeting Real Time Content (required): Hi All, We are looking to create an analysis that could be used to m…William_Johnson 31 views 4 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
Plan Balance query - Carryover, Accrual etc ?Summary:I need to create a report that replicates the data from the Plan Balance screen - which tables? Content (required):I need to create a BI Publisher report that ha…ScottHillier 51 views 8 comments 0 points Most recent by ScottHillier Reporting and Analytics for HCM
-
Formula for most recent grade name on current assignment?Summary: Subject Area: Workforce Management - Person Profiles Real Time Column: "Grade"."Grade Name" Content (required): Does anyone have a formula to pull in an employe…William_Johnson 21 views 6 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM
-
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 11 views 2 comments 0 points Most recent by William_Johnson Reporting and Analytics for HCM