Reports
Discussion List
-
Mail Merge TemplateSummary Create a document that will populate certain fields directly into the documentContent Looking to create a document i.e. VOE that will grab and populate the data … -
Calculating Month difference between DatesContent Hi, I have Data looks like bellow . Emp No. Occurrence Partnership Level Partnership Level Date Months Difference 1 1 Level1 1/1/2006 Months (12/1/2007-1/1/2006)…User_2025-02-07-19-03-14-525 38 views 6 comments 0 points Most recent by Ellen Manthei Reporting and Analytics for HCM -
Report Recipient's list ReportContent Hi All, Is there any way to get Report for all recipients list. Recipient Name Report Name Frequency abc Report1 Daily xyz Report 12 Monthly Thanks, VijayUser_2025-02-07-19-03-14-525 30 views 1 comment 0 points Most recent by Prudence K Reporting and Analytics for HCM
-
Do we have any report to see configured Approval Rules?Content Hello, We need a list of all HCM related processes for which approvals are configured in system. Do we have any report or query through which it can be extracted…Devanshi Fulvani 28 views 2 comments 0 points Most recent by Devanshi Fulvani Reporting and Analytics for HCM -
Candidate and questionnaire JOIN BIP reportContent Hi,How to join the questionnaire and answers to a specific candidate in BIP.does anyone have a working SQL that can share ? Thank YouAwadhendra Tripathi 33 views 1 comment 0 points Most recent by Juan Rendon Reporting and Analytics for HCM
-
Workers Compensation wage reports neededSummary Looking for recommendations and examples of reports related to Workers CompensationContent Our team that administers our Workers Compensation programs has not fo…
-
Need help with BI publisher reportSummary Need help with SQL for BI publisher ReportContent Hello, I have a BI publisher report that is run at the end of every pay period to provide payroll information o…GauravGupta39 51 views 3 comments 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
How to schedule BI report only when it has dataContent Hi All, Can some please help me if its possible to schedule BI Report when there is data. I know we do it in OTBI in condition tab. Thanks, VijayUser_2025-02-07-19-03-14-525 37 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Simple Math on a Pivot TableSummary I need some help with some math that I might be overcomplicating.Content I have created a pivot table that groups employees into temporary, seasonal and regular …
-
Reporting Error with Worker.AssignmentNumber fieldSummary OTBI error being generated when user attempts to access report - specifically states user does not have access to Worker.AssignmentNumber fieldContent Hi all, We…
-
How to stop dashboard auto runSummary How to stop dashboard auto runContent Hi Team, Greetings of the day!!. Dashboard is getting auto run even the parameter was not passed in oracle fusion. Is there…Vasanthakumar Ravi 238 views 4 comments 0 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
How to identify position of Nth occurance of a character or string similar to INSTR functionalitySummary Objective is to display one of the segment values from People Group Flexfied Structure in OTBI ReportContent I have requirement to show a segment value from Peop…
-
Unwanted grouping of data in OTBI AnalysisSummary OTBI analysis giving multiple data against employee instead of one rowContent I have created an analysis with a custom column to interpret employee's adoption of…User_2025-02-11-13-38-56-242 39 views 5 comments 0 points Most recent by User_2025-02-11-13-38-56-242 Reporting and Analytics for HCM
-
Detail vs Summary flagContent I have a report that prompts the user for a beginning and ending check date. Is there a way to add a flag to an OTBI parameter that when selected, the report wil…Annette M 29 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Is it possible to have conditional Display of report parameters on the basis of value in other paramSummary Is it possible to have conditional Display of report parameters on the basis of value in other parameter ?Content Hi Experts, Is it possible to have conditional …Abhishek Sood HCM 182 views 6 comments 1 point Most recent by Abhishek Sood HCM Reporting and Analytics for HCM -
BI Pub folder/object security reportContent Hello, Are the catalog folder/object level permissions stored in a DB table? Can we report on what users/roles have been applied to folders/items to secure them?…JBlain 25 views 1 comment 1 point Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
What is Talent Rating Subject areaContent Hi Team, We have the talent rating where we have, Performance rating, Risk of loss etc. Is there any possibility to get the from OTBI? I know, We can get through…User_2025-02-11-13-25-48-351 28 views 2 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Query to return employees related to a particular Representative type for a given AoR and scope of rSummary Query to return employees related to a particular Representative type for a given AoR and scope of responsibilityContent Hi All, Please share Query to return emp… -
HCM Cloud - OSHA ReportsSummary Looking for documentation (HCM Cloud) on 300, 300a and 301Content I cannot find any configuration documentation related to these reports. Can someone please dire…David Zajac 41 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
BI publisher SQL for finding users who are active in the security console but terminated in the applContent Hi experts, We have found an issue where sometimes when an employee is terminated in HCM they are still showing as an active user in the security console. To res… -
RTF TemplateContent Scenario: I have created two data sets in my data model: G1 and G2 G2(Parent) G1(Child) Parent will always have one row and its corresponding child can have a ro…
-
OTBI Agent to send one email for each recordSummary OTBI Agent is sending the entire report to the recipientsContent Hello Everyone, I need some help. We are trying to implement a mail merge that will be triggered…Alvaro Couto 153 views 12 comments 0 points Most recent by User_2025-01-31-00-25-12-234 Reporting and Analytics for HCM -
Issue with Views in HCM cloud Learning Management (WLF_LRNR_COMPLETION_DETAILS_V) in SpecializationSummary Joins are missing in the Specialization item type part in the Views WLF_LRNR_COMPLETION_DETAILS_V and WLF_LRNR_COMPLETION_SUMMARY_VContent In the code of the vie…Rajesh Ravikumar 48 views 2 comments 1 point Most recent by Rajesh Ravikumar Reporting and Analytics for HCM
-
How many columns can report based on Excel Template have?Summary How many columns can report based on Excel Template have?Content Hello. I am busy creating a data migration extract (BI Report) that contains a lot of fields. I …IanDeKoker 25 views 4 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM -
Unable to Create Cross Subject Area Report for Succession - Incumbent Plans x Candidate DetailsSummary Unable to Create Cross Subject Area Report for Succession - Incumbent Plans x Candidate DetailsContent As we are preparing for Talent Reviews, I have been trying…User_2025-02-08-03-57-26-191 31 views 8 comments 0 points Most recent by User_2025-02-08-03-57-26-191 Reporting and Analytics for HCM
-
Report jobs how can we view BI Publisher reports scheduled by OTHER users ?Summary Report jobs how can we view BI Publisher reports scheduled by OTHER users ?Content Hello , We enter with an admin user the “reports and analysis “-> report jobs.…Revital Mefano 154 views 10 comments 0 points Most recent by Revital Mefano Reporting and Analytics for HCM -
Base Salary and Payroll elements tablesContent Hello experts, I need to extract by SQL compensation data for a specific employee. Do you know in which table I can find the following information: -Base Salary …Valerio Curzi 43 views 5 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
Need query to pull finalised or processed pay period namesSummary Need query to pull finalised or processed pay period namesContent Need query to pull only finalised or processed pay period details?ViswanathaReddyKetireddy 30 views 2 comments 0 points Most recent by ViswanathaReddyKetireddy Reporting and Analytics for HCM
-
call Dashboard from HCM page -how to keep BIP paramsContent MY BIP report has two params (one dependent on another). I need to create a dashboard and display the dashboard under 'My Client Groups'. I did it all. However, …
-
Last Update Date in OTBIContent Hi, Can someone help me to find where to get Last Update Date for "About This Record" in Person tab for "Extra Information". Flow will be go to Person=> Extra In…User_2025-02-07-19-03-14-525 42 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM