Reports
Discussion List
-
Sql query is not workinkgContent Hi, trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1 Select * from per_assignment_supervisors_f sup, per_all_people_f p…Gal Shani 69 views 8 comments 0 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
How to create a report to pick address fields which have invalid charactersSummary How to create a report to pick address fields which have invalid charactersContent Hi I am working on a requirement to create a report which would pick invalid c…User_2025-01-30-21-52-52-008 41 views 9 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM -
Max Coverage Date for Enrollment Results in OTBISummary Looking for the max coverage date by employee and benefit plan/optionContent Hello, I want to report the details of an employee's current enrollment (as of today…Susan Anderson 51 views 2 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsSummary Performance Management tables: Need to capture evaluations, performance documents, tasks, sectionsContent Hi, We need information about how to capture the evalua…User_MC37Q 355 views 3 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM -
OTBI - Field to show max effective_start_date by action_codeSummary In OTBI workforce assignments I'd like to show the max effective_start_date of assignment based on action_codeContent Hi all, While working on "Workforce Managem…Pavel Kartuz 116 views 4 comments 0 points Most recent by Pavel Kartuz Reporting and Analytics for HCM -
OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaSummary OTBI: Need to get details present in database table: HRQ_QSTNR_SECTIONS in Learning Subject areaContent Hi, We are creating a Dashboard for plotting the average …User_MC37Q 75 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
how to get seniority date of a person from Oracle Fusion HCM tablesSummary how to get seniority date of a person from Oracle Fusion HCM tablesContent Hi, We are creating a BIP report to fetch seniority date of a person onto a Terminatio…User_MC37Q 1.1K views 1 comment 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Turnover ReportSummary Looking for help creating a turnover reportContent Hi, We have set-up turnover reports but when I checked the data the report is not pulling the correct informat…User_2025-01-30-01-37-19-048 115 views 8 comments 0 points Most recent by User_2025-02-03-23-33-26-899 Reporting and Analytics for HCM
-
What's New in 18.11?Summary #EPMNerdContent Another new month on our doorstep, so here we go again! I’m sure you have been waiting with bated breath for my “What’s New” post, so here it is.… -
Need inputs to fetch PBL batch start time and End timeContent Hi All, Please suggest in which table holds the when the PBL process started and end dated (i.e. completion time). Ex: If we submit PBL batch, we need to know co…
-
Workflow table Fusion HCMSummary Need to extract notification historyContent Hi, Being saas customer do i have option to extract workflow data from Fusion HCM Br Azfar.Azfar.128 98 views 2 comments 0 points Most recent by User_2025-01-25-04-02-13-126 Reporting and Analytics for HCM
-
Personal Payment Methods Processing OrderContent HI All, In the Manage person payment method UI is having processing order as 1,2,3 and corresponding column in DB as “pay_person_pay_methods_f” and “priority”. T…Visu 334 views 11 comments 0 points Most recent by Sricharan Monigari Reporting and Analytics for HCM
-
Need a report to get calculation card Override details along with maximum allowence for fedral andSummary we have a requirement to pull the override rate, override amount, override suplemental rate for fedaral and state from manage calculation cardsUser_2025-02-04-07-00-18-658 90 views 4 comments 1 point Most recent by User_2025-02-04-07-00-18-658 Reporting and Analytics for HCM
-
Job Requisition Current Status FieldSummary Trying to locate this fieldContent Anyone know what subject area and folder the current job req status is stored? I'm having trouble locating it.User_2025-01-28-08-47-04-905 28 views 1 comment 0 points Most recent by User_2025-01-28-08-47-04-905 Reporting and Analytics for HCM
-
Best option to generate HR change letters in Oracle HCM CloudSummary Our HR department would like to generate letters (on demand) for employees upon data changes in HCM Cloud such as department changes, employment changes, etc. Wh…User_2025-01-30-03-25-05-093 146 views 5 comments 0 points Most recent by User_2025-01-30-03-25-05-093 Reporting and Analytics for HCM
-
New Hire Notifications to Manager, Payroll, HR Business Partner, EmployeeSummary Creating Individualized New Hire NotificationsContent Hello, We are currently transitioning to HCM Fusion and we need a New Hire alert that sends out to their Ma…User_2025-01-31-00-25-12-234 179 views 7 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What's New in 18.10?Summary Do you love these posts?Content Hello, Here we are again with another "What's New" post that is totally unnecessary since you have already read the information w…
-
Active\Inactive Employees with assigned Line ManagersSummary A requirement for a BIP report to show all employees and their Line ManagersContent Hi All, I have a requirement to create a BIP report to display all Active and…User_2025-01-30-03-54-32-528 493 views 12 comments 0 points Most recent by User_2025-01-30-03-54-32-528 Reporting and Analytics for HCM
-
Identifying if an assignment change was done with a future, retro or current dateSummary Having trouble finding a way to identify if an assignment change was done with a future date or retro date after the fact.Content Hello, My team is in the proces…Mak-Moose 198 views 4 comments 0 points Most recent by User_2025-01-29-21-12-23-173 Reporting and Analytics for HCM
-
OTBI report writing access model to users outside HRISSummary Need a model to allow users outside of HRIS to write and save reports in BI CatalogContent We implemented HCM Fusion this year and are looking for ideas as how t…Paola Rodrigo 29 views 2 comments 0 points Most recent by Paola Rodrigo Reporting and Analytics for HCM
-
report errors with multiple subject areasSummary error getting information when using more than one subject areaContent When logged in as someone with lots of roles, I am able to create and view an analysis usi…User_2025-01-30-03-29-08-639 50 views 3 comments 0 points Most recent by User_2025-01-30-03-29-08-639 Reporting and Analytics for HCM
-
Creating an Analysis from Multiple Subject Areas - Using Measures Column from each subject area?Summary Creating an Analysis from Multiple Subject Areas - Using Measures Column from each subject areaContent I don't understand the logic of when creating an OTBI Anal…Ruzwan Akram 375 views 12 comments 2 points Most recent by User_2025-01-29-19-59-51-150 Reporting and Analytics for HCM
-
Deleted Cloud User Still Shows in PBCS Provisioning ReportSummary Deleted Cloud User Still Shows in PBCS Provisioning ReportContent Has anyone noticed that when you delete a User from Cloud My Services that they still appear in…
-
Which table stores value set details used in fast formulaContent Hello everyone, Which table stores the information about the value set which is used in fast formula. if anyone knows which tabe defines the relationship between…
-
Historical promotions and assignment for terminated recordsSummary Trying to pull trending data on promotions and transfersContent When using an assignment history report I notice that the history is not included for terminated …User_2025-01-30-03-28-08-030 50 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
HCM infolets - include HC measures from records excluded from data role?Summary HCM infolets - can you include HC measures from records excluded from data role?Content We've put together a number of infolets showing basic HCM measures eg hea…User_0HYZ2 245 views 7 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM