BI Publisher
Discussion List
-
DATA_CACHE column deprecation from HRC_TXN_DATA tableContent We are currently on Oracle HCM Cloud 20D. We have a scenario where we need your suggestion/feedback. Oracle is deprecating DATA_CAHE column from HRC_TXN_DATA tab…Abhishek_Jain 92 views 2 comments 2 points Most recent by Hari Arumugam Reporting and Analytics for HCM -
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 … -
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 31 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 29 views 2 comments 0 points Most recent by Devanshi Fulvani Reporting and Analytics for HCM
-
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 52 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 38 views 3 comments 0 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
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 241 views 4 comments 0 points Most recent by Seiichiro Yasui Reporting and Analytics for HCM -
questionnaire joins to the candidate in BIPSummary how to join the questionnaire and answers to a specific candidate in BIPContent Hi, I am developing a report in BIP which displays the questions from the questio…Iann hick 43 views 5 comments 0 points Most recent by Awadhendra Tripathi Reporting and Analytics for HCM
-
Drill down report not showing up for a specific userSummary Drill down report not showing up for a specific userContent For viewing the Drill down report does the user need any special security? The user can able to see t…Prabhu Krishnamoorthy 7 views 2 comments 0 points Most recent by Prabhu Krishnamoorthy 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 188 views 6 comments 1 point Most recent by Abhishek Sood HCM Reporting and Analytics for HCM -
Excel based Template Report- Does not provide PDF export optionSummary Excel based Template Report- Does not provide PDF export optionContent One of our BI Report, The Report was created using an Excel based template (Means: Created…Prabhu Krishnamoorthy 19 views 2 comments 1 point Most recent by Sricharan Monigari 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 30 views 2 comments 0 points Most recent by Dilpreet Kaur 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… -
Create Custom Subject AreaContent Hello experts We need to do a dashboard with an easier layout to deal with. and better UX then Publisher native Is it possible to use a query and create the subj…Pedro Teixeira 26 views 3 comments 0 points Most recent by Julian Challenger-Oracle 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 47 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 26 views 4 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM -
Oracle Documents of Records linkContent Hi Guys, Is there a OBIEE BIP SQL CODE code that can turn the column value into a clickable link, please see image for reference. Here's my current sql code. tha…User_2025-02-05-11-53-59-507 33 views 2 comments 1 point Most recent by Seiichiro Yasui 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 44 views 5 comments 1 point Most recent by Dharmendra Shukla Reporting and Analytics for HCM -
E-Sign Policy documentSummary E-Sign Policy documentContent Hi All, We have a requirement to create BIP template using provided Onboarding Policy template(.RTF). In the Template we need to ad…Prabhu Krishnamoorthy 41 views 2 comments 0 points Most recent by Dilpreet Kaur 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, …
-
BIP SQL to show the Emplid, Name and Today's date of the Login userSummary BIP SQL to show the Emplid, Name and Today's date of the Login userContent I am creating template report which should automatically show Emplid and name based on…Prabhu Krishnamoorthy 91 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
per_addresses not having dataSummary per_addresses not having dataContent I don't see PER_ADDRESSES TABLE GETTING POPULATED, Instead the tables like per_addresses_f is having data but the per_addres…Prabhu Krishnamoorthy 534 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
List of Core HR Audit Tables - For Building Audit report in BIPSummary List of Core HR Audit Tables - For Building Audit report in BIPContent Can anyone provide me the List of Core HR Audit Tables - For Building Audit report in BIPPrabhu Krishnamoorthy 48 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need help in restricting infolet in Legal Employer Transfer PageContent Dear All, I have created an OTBI infolet on Legal Employer Transfer UI in Assignment section. Now this infolet is visible in all the pages where Assignment secti…User_2025-02-06-14-37-05-233 44 views 4 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM
-
BI Publisher - tracking of an email notificationSummary Schedule Report JobContent Hi All, One of users has complained about some of their scheduled processes not sending email notification even though she filled up t…Alvaro Couto 80 views 6 comments 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM -
Log for emails sent through scheduled Reports jobContent Hi, We have scheduled a report job. So some are going under failed. Can i know how to fetch log daily how many reports are successfully sent and how many were fa…User_2025-02-10-17-13-07-021 40 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for HCM
-
Issue with "Workforce Management - Absence Real Time"Content Hi Team, We have designed a specific report using the OTBI "Issue with Workforce Management - Absence Real Time". This was working fine till last month and now w…Kiran Kancherla 26 views 3 comments 0 points Most recent by Kiran Kancherla Reporting and Analytics for HCM
-
Additional Information from Accrual Plan BalanceSummary Require Table and column name for additional information fieldContent Hi Team, I need to extract the additional information field description for the Absence Pla…User_2025-02-04-13-27-19-123 126 views 4 comments 0 points Most recent by User_2025-02-04-13-27-19-123 Reporting and Analytics for HCM
-
Ho Do I Call a BI Publisher Report from a Tile on the SpringboardSummary Ho Do I Call a BI Publisher Report from a Tile on the SpringboardContent Hello, We would like to call a BI Publisher report from a tile on the springboard. Does …Daniel McMillian 38 views 8 comments 1 point Most recent by Daniel McMillian Reporting and Analytics for HCM
-
Getting Error "the User request exceeded the maximum query governing Execution time" while running tSummary Getting Error "the User request exceeded the maximum query governing Execution time" while running the OTBI reportContent Hi All, I have created one OTBI analysi…User_2025-02-06-15-04-02-124 93 views 5 comments 0 points Most recent by Ninja Reporting and Analytics for HCM