Reporting and Analytics for HCM
Discussion List
-
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr… -
Dashboard Prompt Not Working on Logical SQL AnalysisSummary Dashboard Prompt Not Working on Logical SQL AnalysisContent Hi experts, - I have created a report using Logical SQL. Please see attached. - I created a dashboard… -
How do you include inactive requisitions in an analysis?Summary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
Query to get the Job Requisition Approver details in BIP ReportSummary: we are trying to get the details of Job Requisition approval flow. precisely we wanted to get the details:::: with whom the Requisition is pending with? Content…
-
Level 02 Organization Name (Business Area) Not Showing UpSummary: We are currently in the process of implementing ORC and we are trying to create some dashboards that we can use for requisition/candidate data. When we run the …
-
Schedule Report to Run Prior Month/QuarterSummary: Currently, only a few HR members can run reports, no one outside of HR can. If they need a headcount roster or turnover, I would run the report for them. There …
-
How to report on Date Paid in last 12 monthsSummary: I have a report using the Payroll Balances Real Time subject area. The requirement is that when the report runs on the first day of every month, the output is f…
-
Restricting Data for Direct reports of a Line ManagerSummary: Hi All, How do we restrict Line manager access to only his/her direct reportees Learning Items in OTBI Report. Can you let me know the steps ? Content (required…
-
Reporting on ICD/Manage Personal Contribution Requests that have been SavedSummary: Content (required): We use Individual Compensation Distributions for our employees to claim for irregular payments (overtime worked etc.) as we are not yet usin…
-
Can the Performance Review, Comments section font be made uniform when using custom font?Summary: When creating a custom version of the employee and manager printed performance review document in BI, we are unable to force the font in an open text comment se…
-
report of all list of ESS jobs which are Running more than 24 hrsSummary: report of all list of ESS jobs which are Running more than 24 hrs Content (required): report of all list of ESS jobs which are Running more than 24 hrs Version …
-
Need query to get scheduled process details such as process name, scheduled time, parameters.Summary: Need query to get scheduled process details such as process name, scheduled time, parameters. Content (required): I need query where I can get count of active s…
-
Annualized TurnoverSummary Want to incorporate an annualized turnover in my Turnover DashboardContent Is there currently anything with annualized turnover, or do I need to formulate someth… -
How to apply a 'Custom Theme' to OTBI reports/dashboards.Summary: How to apply a Custom Style Theme to dashboard and reports to align to Company standard. Content (required): is it possible within OTBI to generate and apply a … -
Embedded Reports not loading 1st time opening the screensSummary: Embedded Reports not loading 1st time opening the screens Content (required): Hello We have 2 embedded reports in the absence screens which are not loading on t…
-
How are users interacting with systemSummary: Content (required): Hello We would like to know how our users are interacting with our system. The ASE_USER_LOGIN_INFO table shows the date of the last login, b…
-
Use of dynamic URL to run the report on Home page linkWe have created a BIP report and used that URL to create a page link on the Fusion Home page. At present, configured using Static URL on the link and it works fine. The … -
Timecard status reportSummary Trying to retrieve a report in Fsuion which gives timecard at its different status of its lifecycle.Content Does anyone know of a report that would give the time…
-
The promt does not affect the analysis report on the Dashboard screen.I have an analysis report that I use on the dashboard screen and parameters that I expect to affect this report, and one of these parameters does not affect the report, … -
Tables relating to NotificationsSummary Question to assist in building a BI Publisher report on Time Card notificationsContent I need to create a BI Publisher report on notifications for time card appr… -
How to use FND Archive tables to get all HCM Transaction details of WorkflowSummary Need to report, both active , recent completed and histroical Workflow transaction details.Content Hi I am currently using this tables to get Active and recently…
-
Which table stores the "Assign as" information for initiativeSummary: Hello All, I am trying to build a report to fetch learning initiative details but i am not finding any information regarding the assign as column in the UI.Plea…
-
How can i query the "Active" Organization Tree version description?Summary: How can i query the "Active" Organization Tree version description? Content (required): I'd like to be able to return the value / name of the Version ID tied to…
-
Need function condition to exclude any character other than numbers and alphabets for address in BISummary: Need function condition to exclude any character other than numbers and alphabets for address in BI Content (required): Address should not have any characters o…
-
Syntax for comparing numeric plain text value with number valueSummary: Requirement is to build analysis to identify employees whose payroll run result of a particular element does not match a corresponding value held in assignment …
-
Query to extract Mail address Effective start dateSummary: Content (required): Hello experts, please, could you share the SQL query to extract employees effective start date? Thanks in advance for your time! Kind Regard… -
Unable to find the Subject area/SQL query to get the Final close date value in the PayrollRelationUISummary: In the Payroll Relationship UI we have final close date value at the Element duration dates as well as Assignment level. I am unable to find any subject area/SQ…
-
Table and field references for compensation manager hierarchySummary: Content (required): Hello experts, for this compensation campaign we should change the manager hierarchy workflow and we set the primary hierarchy as in the att…
-
Need query to get the list of all privileges for a given roleSummary: Need query to get the list of all privileges for a given role Content (required): Navigation: Tools > SecurityConsole > Roles If I query a role name, I am getti…
-
Understanding Actual Termination Date and Per_Periods_Of_ServiceSummary: Looking for SQL to pull in an accurate termination date given a point in time. And if that point in time is BEFORE the termination, then the business is wanting…