Reporting and Analytics for HCM
Discussion List
-
HCM Extract Delivery Options - WebCenter ContentSummary HCM Extract Delivery Options - WebCenter ContentContent Hello Experts, I am working on HCM Extract delivery options - WebCenter Content! Does anyone aware of the… -
How can I get the absence entries for the next month to my query?I am preparing a report that will be sent to employee in the form of notification for the absence in the status of Saved for the next month. So how should I restrict my … -
I need an example of a sql query that returns person names and roles.I need to prepare a report that will list certain roles. So how can I write the query about the names of the people and what roles they have?
-
Table Details that stores all information about a Custom Quick ActionHi All, Please help know the table name that stores Quick Actions ,Eg: If there is a custom Quick Action created like "Colleague Details" under Me TAB,want to know when … -
OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbentsSummary: OTBI reports: 1. Users with 2 assignments 2. Positions with 2 incumbents Content (required): Hello, I'm building a data quality dashboard and would like to ask … -
How can I run the report when I select the required parameter field 'ALL'?Hi, I have 1 parameter that is mandatory in the report I prepared, assignment status, you can see it in the screenshot. It is true that the report should not be opened w…
-
How to pull data from Human Capital Management and Workforce Management subject areas?Summary: How can data from the Human Capital Management Approval Notification and Archive Real Time and Workforce Management Person Real Time subject areas be effectivel…
-
Time Card Approver DetailsSummary Time Card Approver DetailsContent Hi Experts, Which table holds the information of who approved the time card. #1.HWM_TM_REC is having time card details. Whether… -
Query to extract the last update date for document record fieldsSummary: Query to extract the last update date for document record fields Content (required): Hello experts, please, could you share the query to execute in order to fin…
-
How to deep link for employment info page for specific assignment?Summary Looking for a way to create a deep link to individual assignments on the employment info pageContent Hi! I've created an OTBI analysis that shows terminations sp… -
Is it possible to report on Alert History?Summary: Need to see alert history in easy to read format Content (required): We have quite a few alerts running and would like visibility to what is sent and when to he… -
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… -
Report Data PurgingSummary: How often your organisation request Oracle to purge the report job history? Content (required): We have reviewed the report job history and have noticed there a…
-
Oracle Analytics Cloud (OAC) - Briefing Books QuestionSummary: Briefing Books Update functionality Content (required): We are trying to create a briefing book that automatically updates itself whenever changes are made to t…
-
Options to include DFFs from Fusion to FAW only for Table Attributes knownSummary: What are the Options to include DFFs from Fusion to FAW only for Table Attributes known. Here we know the data attributes DFFs from certain tables but respectiv… -
Element HDL Template Generator ReportSummary OTBI report to generate sample files to create Payroll Elements using HDL Content Introduction: This report provides sample files to create Payroll Elem… -
Training forecast for next 12 monthsSummary: Do we have catalog file for this delivered/seeded learning Report : Training forecast for next 12 months ? Content (required): As we need to provide this standa…
-
Getting merged and blank rows while trying to fetch Performance rating and Salary together in OTBISummary: Hi Peers, I am trying to build an OTBI analysis to fetch both the Performance rating and the Salary. I'm using Compensation - Salary Details Real Time and Workf…
-
Using 2 different subject areas (Salary and Performance Rating) - Getting split/merged cellsSummary: Hi Experts, I'm pretty much a beginner with reporting. My client wants an OTBI report that can pull salary details as well as latest performance ratings (overal…
-
BIP query for Public Holiday assigned based on asg work location and showing in Calendar eventSummary: BIP query for Public Holiday assigned based on assignment work location and showing in View Calendar event in work Schedual. Content (required): -- AND PCEC.TRE…
-
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" -
How to use an OTBI analysis to create a data model with a parameter (prompted?)Summary: I am trying to use an OTBI analysis to create a data model. My data model will be refrenced by Oracle Journeys so there is a requirement that I attach a specifi… -
BIP Report for batch monitoring of Scheduled HCM ExtractsSummary: Feasibility of BI Report for batch monitoring of Scheduled HCM Extracts. Content (required): Would like to know if it's possible to pull Scheduled HCM extracts …
-
Error Codes: OAMP2OPY:U9KP7Q94 - OTBI AnalysisSummary: We have a weekly Analysis that runs via Agent. After running many times without issue each week, we are getting these errors: OAMP2OPY:U9KP7Q94 - "An Unexpected…
-
OTBI Report in Workforce Goals - Goal Status Overview Real Time, Unable to add Organization LevelsI am building an OTBI report in a single subject area (Workforce Goals - Goal Status Overview Real Time). I am able to add Development Goals details from the "Developmen…
-
Bursting body and pdf attachmentHello, I want the message body of an e-mail I prepared with bursting to appear as follows, and I also want to add a pdf to this e-mail. How can I do that?
-
Recruitment Requisitions in Draft Not Displayed in AnalyticSummary In OTBI Answers, when querying recruitment requisitions that are in draft in Fusion, they aren't not returned.Content Recruitment requisitions that are in draft …
-
Employee Roster Report using subject area-Compensation Real TimeSummary: We are in need of an employee roster report built off of the Compensation-Real Time subject area, but to pull the grade and range from the Job Details area, ins… -
OTBI Report: 360 feedback: details of the questionnaire answers + overall ratingSummary: Hello, Has anyone create an OTBI Report regarding 360 feedback: details of the questionnaire answers + overall rating? Can you please share a catalog for this? …
-
Impossible to get report output for only some usersSummary: Impossible to get report output for only some users when launching them Content (required): Hello experts, we have been having problems since November 2022 for …