BI Publisher
Discussion List
-
BI Publishing: bursting without attachmentsSummary Bursting to selected people, without attachmentContent Hi all, I am trying to use BI Publishing to burst an email to colleagues who have handed in their notice. …User_2025-01-31-17-49-32-187 1.4K views 10 comments 4 points Most recent by Satyam Roy Reporting and Analytics for HCM -
Payroll Data to Transaction DetailsHello I am looking to create a report that shows pay element details linked to the transaction data. We issue Special Payment to several of our employees. When it is ent… -
VBC HCM tables available for BI Query in lab pod? POCSummary: Are the Value By Criteria tables available for BI Query Data Model? Content (please ensure you mask any confidential information): Hello: I'm performing a Proof… -
Federal Tax Withholding Filing Status - Pulling Data from TablesSummary: The Federal Tax Withholding Filing Status seen from the front end of the application is displaying a status that does not correspond with the Filing Status seen…ChicagoConsultant 15 views 1 comment 0 points Most recent by RWMATTHE-Oracle Reporting and Analytics for HCM
-
Table that Stores Fields on Tax Withholding Calculation Card- Filing StatusSummary Looking for table that stores filing status on Tax withholding calculation card when you select Federal Income Tax, Calculation Coponent DetailsContent Hi All, L…User_2025-01-30-00-53-42-934 970 views 5 comments 0 points Most recent by Sydney_Flahive Reporting and Analytics for HCM
-
Absence Plan Balance (as of Date) in ReportSummary Absence Plan Balance (as of Date) in ReportContent Hi All I need to display the Absence plan balance of an employee as of certain date in Report. For example whe…Shabrawi 285 views 6 comments 1 point Most recent by Catherine Abi Samra Reporting and Analytics for HCM -
extract best-fit results from the HRT_PROFILE_BESTFIT_RESULTSummary: I access the HRT_PROFILE_BESTFIT_RESULT table to extract the values in the following columns (COMPETENCY_SCORE,WEIGHTED_SCORE), I can't find the plain text desc…Emanuele De Marchi 11 views 2 comments 0 points Most recent by Emanuele De Marchi Reporting and Analytics for HCM
-
Reporting on a Managers Direct Reporting LineHiya, I went on a workshop recently in Reading and Julian kindly told me how I should be able to report on direct employees under a manager instead of direct and indirec…MikeW 283 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to Specify Multiple People in Cc While Bursting in Custom BI AlertsSummary: Content (required): There is a requirement of having multiple people in Cc while bursting. How to configure PARAMETER 2 for multiple recipients? Version (includ…Shashank Singh 977 views 3 comments 0 points Most recent by jahanavi metta Reporting and Analytics for HCM
-
Way to fetch Value By Criteria Definitions in custom payroll fast formulaSummary: Way to fetch Value By Criteria Definitions in custom payroll fast formula select * from PAY_VBC_VALUE_IDENTS? I'm not seeing my records in HCM BI query Thank yo…jtwhit_hcm 25 views 0 comments 0 points Started by jtwhit_hcm Payroll and Global Payroll Interface (GPI)
-
Vinay Prasad 34 views 3 comments 0 points Most recent by Rajdeep Chavda Reporting and Analytics for HCM -
Assignment Status in BI ReportSummary Assignment Status in BI ReportContent Hi, I want to find out table field in BI Report which hold value Assignment Status = "Active Payroll Eligible" or "Inactive…User_2025-02-07-19-03-14-525 176 views 12 comments 1 point Most recent by Aurobindo Ghosh Reporting and Analytics for HCM
-
Custom Font on OTBI Dashboard?Is it possible to use a custom font with OTBI Dashboards/Analyses? We would like to develop a "theme" for our Dashboards and use our company's font. The only information…
-
Payroll Flow Pattern ReportSummary: Payroll Flow Pattern Report Content (please ensure you mask any confidential information): Hi Team, Greetings! Is there a way to find out the programs which are…Parag Hiremath 43 views 1 comment 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Calculated Eligibility fieldSummary: Hello, We're trying to extract the Calculated Eligibilty column in SQL, as we need to know the value if it's Forced Eligible or Eligible. However, we cannot fin…
-
Payroll - Personal Payment Details Real Time gives an errorSummary: Hi Everyone, Currently, I'm working on the "Payroll - Personal Payment Details Real Time" Subject Area. when I'm trying to add employee bank details, it gives m…
-
Need SQL to extract the amount and periodicity of worker element entriesSummary: Hi Experts, Could you please provide SQL code that extracts the amount and periodicity of worker element entries? I need help with this requirement. Written thi…Hiba Ghoualmia 75 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Call a bi publisher report from redwood pageSummary: Hello, Recently we have transformed absence standard page in fusion to redwood, can I call a custom BI Publisher report from this page and pass specific paramet…
-
Need example for Bursting Query in case of Multiple data setsContent Hi, Can anyone explain how to write Bursting query in case of Multiple Data Sets? Thanks in advance. JyotiUser_2025-02-06-14-37-05-233 255 views 11 comments 0 points Most recent by Darshan K N Reporting and Analytics for HCM
-
Where can we report on Employee's LDAP Manager?Summary: We need to write a report where we can pull the Employee Manager data stored in LDAP. Content (please ensure you mask any confidential information): We need to …Dianne_W 32 views 2 comments 0 points Most recent by Catalin Constantin-Support-Oracle Reporting and Analytics for HCM -
Report for PC log in vs Mobile log in on browser vs Mobile log in on the appHi there, Is there a report, or which tables could we use to build a report, that identifies whether a user log in to HCM is from a PC or mobile. We found "Device_Type" …
-
Table name for pending workerSummary Table name where pending worker details are storedContent Hi Oracle experts, I have created a Pending worker from Taleo to Fusion using the delivered integration…
-
Need a query that combines both termination transaction details with the employee details.Hi I need to create a custom query that combines both the transaction console details for terminations with the employee details (i.e. job name, department and pay) for …
-
Timecard Layout ReportTeam, We have a requirement to build many timecard reports and would like to understand the table structure to develop the same. We are using hwm_tm_rpt_entry_v view to …
-
Positions report with no open requisitions or current incumbentsHello, Currently we are looking for a report regarding Position details where there is no Open requisition linked or no current incumbents mapped. Many thanks,Bala Krishna B 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How to confirm the normal transmission of the bursting.Summary: How to check if a bursting has been successfully sent. Content (please ensure you mask any confidential information): Nice to meet you. My name is Keishi. Now I…
-
SQL query for linking between life event and benefits plansSummary: Need sql query or back end table for the linking of add life event(BEN_LER_F) and benefits plans(BEN_PL_F) Content (please ensure you mask any confidential info…
-
Number of active/Inactive users in Oracle HCMSummary: Hi All, Do we have any standard report to see the number of active/inactive users in the system? If someone has this report please share. Thank you.Saher 25 views 1 comment 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Query to retrieve the employee seniority dateSummary: Content (please ensure you mask any confidential information): Hello experts, I should retrieve Seniority Date for employee person number 1775. In case of Rehir…Valerio Curzi 27 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
state unemployment wages by jurisdiction reportSummary: I am trying to create a report that shows state unemployment wages by state jurisdictions. I created one in OTBI using the Payroll - Payroll balances real time …JDCal 11 views 1 comment 0 points Most recent by Rakesh Ghosh-Oracle Reporting and Analytics for HCM