Reporting and Analytics for HCM
Discussion List
-
HCM OTBI Workshop Session 1Summary: This following link allows you to download the recording of session 1 of HCM OTBI Workshop for beginners organized by JAPAC CS Org along with DEV and COE. Conte… -
OTBI Customer SurveyTo better understand Fusion customers' current use of and satisfaction with the current reporting capabilities available with OTBI, we would like your help in completing… -
HCM OTBI Workshop Session 2Summary: This following link allows you to download the recording of session 2 of HCM OTBI Workshop for beginners organized by JAPAC CS Org along with DEV and COE. Conte…Raghavendra Raghunath-Oracle 593 views 6 comments 13 points Most recent by Raghavendra Raghunath-Oracle
-
23A New Feature Summary and What’s NewSummary: 23A New Feature Summary and What’s New are now published to the Readiness site: https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/readiness/offeri… -
New Bite-Size Learning Videos Published for HCM AnalyticsSummary: Need to learn how to modify OTBI analytics? Please check out the new Bite Size Learning videos just published to the Oracle Help Center Bite-Size Library page: …
-
Report for getting list of all Customized objectsIS there a report which can list out all the objects on which either Page Customization or Customization via Designer Studio was done?
-
OTBI Export to Excel shows the blank values in the columnSummary: We have some reports in the payroll module. When users run the OTBI report (view results), they can correctly see the data in the output/viewer for all the colu…
-
How to get an analysis to show # of open Positions being recruited for each month over the past yearSummary: How to get an analysis to show how many positions were being recruiter for each month over the past year? We have a dashboard with the time dimensions of Month,…
-
Challenge with TIMESTAMPADD function not returning correct resultsSummary: When I add X number of years to a date field the formula produces a wrong date. Content (required): I build an OTBI analysis based on Workforce Management - Per…
-
Layout name in the report output file nameSummary: When report is exported to Excel, the report name is concatenated with the layout name, to arrive at the report file name. Content (required): What are my optio…
-
Need formula for Date Paid is in last calendar monthSummary: I have a report using Subject Area Payroll - Payroll Balances Real Time. The report will run on the first day of every month and will capture the number of hour…
-
Is it possible to track who changed user roles and when it happened in Security Console?Summary: Content (required): Hello experts, is there a way by OTBI or SQL to retrieve who changed user roles in security console and when it occured? Thanks in advance f… -
Which Role is required for column AsgRepresentativePEO.WORKER_ASSIGNMENT_ID?Summary: I have Created an OTBI report in which AsgRepresentativePEO.WORKER_ASSIGNMENT_ID is cloumn is there I am not bale to access the report , So I am assuming may be…
-
OTBI Report - Phone logicHi Team, I have one report have couple of assignment details, Now I have to add one column phone number. Criteria to fetch phone number is, If the work mobile number is …
-
Favourites window only fills half of screenSummary: In OTBI the favourites window only fills half of the screen Content (required): When entering OTBI the favourites window only fills half of the screen, bottom h… -
Headcounts not tieing up with active assignmentsSummary: When we check the headcount for a specific year, on the Line Manager dashboard, the number is far less when compared to the number of persons with active assign… -
How to cutomize a seeded Payroll register Report extractSummary: Which extract should we customize to add the new attributes to the extract. Can you provide us a document for the same. Content (required): We have a requiremen…
-
salary formatted in rtf templateSummary: Hi everyone, We are customizing compensation letters for a client. We are having problems formatting the amount field for a certain bonus that should be paid to…
-
How can we pull data in custom report for the field name "Action" on Termination page.Summary: I am trying to generate a custom report and want to know the column name for the field name “Actions” in the Termination page. We do get the data for the other …
-
How to view specific subject areasSummary: I can't seem to figure out how to access the vacancy numbers under Workforce Management - Vacancy Real Time Content (required): I'm attempting to view the vacan…
-
Available Methods to search for a keyword in ReportsSummary: Available Methods to search for a keyword in Reports Content (required): Hi Team, Greetings! We are planning to modify the payroll balance related setup and tha… -
Error with Next 90 Day SyntaxSummary: I'm getting an error when I use the below formula to get the next 90 days form a specific date field in my filter. Content (required): The error I'm getting bel…
-
Position DurationSummary Provides the duration of the workers in a specific positionContent This analysis provides the duration(in days) of the workers in all the positions that they hav…
-
Participant Feedback - Questionnaire Responses duplicationSummary: Dear Team, We have a Performance template which has the Participant feedback included and would like to capture the responses provided by the Participants in th…
-
Need BIP query for Sensitive Information in Job Application ORCSummary: Which is the source table for National Identifier and Date of Birth under Sensitive Information? Navigation: My CLient Group >> Hirings >> Search Req Number>> C…
-
Dear Experts I want to check do we able to get the translated report in OTBI ScenerioSummary: We have built questionnaires with a translation of the language and prepared the report to see who attended the evaluation and their responses. Currently, we ca…
-
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…
-
HCM OTBI subject areas to database lineage mapping spreadsheetSummary This spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content Important Note: The subject area to database…
-
Change Dashboard Icon ColourSummary: Content (required): Recently, our client decided to change the background color of the application, and overall it looks fine but on the dashboard, the icon col…
-
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… -
Please help share SQL to extract all oracle fusion hcm setup configuration with dataHello All, We want to have a download of Config Workbook from the POD,but Configuration Package and Implementation Project setup isnt working as expected. Please help sh… -
Manager hierarchy in Recruitment using OTBISummary: Need guidance on which field or logic to be used to include manager hierarchy in an OTBI recruitment report Content (required): OTBI Manager Hierarchy Recruitme…
-
Agent Completed with Warnings - Details?Summary I need to find details on the warnings of an agent failingContent Hi all, We recently upgraded to 19C and a group of our agents are now Completed with Warnings. … -
California Pay Data Reporting UpdateSummary: The California pay data reporting requirement is getting updated. Is Oracle developing an update to the delivered report to account for this? Content: Existing …
-
Data security on BIP reportHi friends, We have developed a BIP data model/report using the below tables which touches across payables, supplier and hcm. Some of payroll users having the Payroll Ma…