BI Publisher
Discussion List
-
Adding a BI Publisher Report to a Flow - parameter questionSummary: Hi, I have a BI Publisher report that I want to add to a flow. I have followed the steps described under https://docs.oracle.com/en/cloud/saas/human-resources/2… -
Deep Link for Employee detailsSummary: Content (required): We have a use-case to send workflow notification BIP Report to the HR Team/Head in case of Termination or Re-hire. Oracle provides the stand…Vinay Gharge 21 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
Report integration on a pageDear all I integrated a dashboard on a custom page. There are two open points fr which I can't find an answer at the moment: 1. The report is not fully shown. There is a…Annelies Van Erom 13 views 4 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How can I exctract Work Terms Number field in OTBI?Summary: Content (required): Hello experts, I need to extract in some way the Work Term Number field to update employee managers by HDL. Is it possible to find this fiel…Valerio Curzi 426 views 14 comments 1 point Most recent by Girish Singh-Oracle Reporting and Analytics for HCM -
What is the Table that stores Oraganization EFF details.Summary: What is the Table that stores Oraganization EFF details. Content (required): What is the Table that stores Oraganization EFF details. Version (include the versi…User_2025-02-12-17-19-33-738 12 views 2 comments 0 points Most recent by User_2025-02-12-17-19-33-738 Reporting and Analytics for HCM -
Maximum number of columns for Excel/RTF TemplateHello! We are solutioning an HCM Extract report and we are planning to use Excel/RTF Template as delivery option. Is there a maximum number of columns for Excel or RTF T…
-
Maximum number of columns for Excel/RTF TemplateHello! We are solutioning an HCM Extract report and we are planning to use Excel/RTF Template as delivery option. Is there a maximum number of columns for Excel or RTF T…ZenG 27 views 1 comment 0 points Most recent by Aaron Hager Associated Bank Reporting and Analytics for HCM
-
when we using full name column, we are missing the middle name of employee any another column ?Summary: Hi Team, when we using full name column, we are missing the middle name of employee but when we try to using first name , middle name, last name but it is takin…AjayKumar Maddipati 31 views 3 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM -
Active Profile QuerySummary: Looking for help on how to build a query that checks for active profiles within different environments Content (required): Hi all, I'm looking to see if anyone …
-
Font size is different for different fields after removing HTML tags in OTBI reportSummary Font size is different for different fields after removing HTML tags in OTBI reportContent Hello Everyone, Can you please help me regarding this issue? Created a…User_1OXJZ 42 views 3 comments 1 point Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
Is there a way for an Analysis to retrieve the results of a data model?Content Hi, I currently have a data model but I need its results to get displayed via OTBI. Any way to achieve that? Thanks, IsaacICO 28 views 10 comments 2 points Most recent by Rajasekhar Bandaru-Oracle Reporting and Analytics for HCM
-
BIP Bursting - getting duplicate outputsSummary: I have BIP bursting working and delivering an e-mail to my "Split By" value (managers email) and "Delivery By" value (Person Number) successfully. However, it i…Scott Conaway 106 views 0 comments 0 points Started by Scott Conaway Reporting and Analytics for HCM
-
Hiding Output TAB in Schedule Page of ReportSummary: Hiding Output TAB in Schedule Page of Report Content (required): Can we hide via Personalization or Role Duties and Privileges restriction hide the Output TAB i…C.R.Balaji 12 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Need to schedule a BI Publisher report to run on interval of 15 daysSummary: Need to schedule a BI Publisher report to run on interval of 15 days. Content (required): Version (include the version you are using, if applicable): Code Snipp…Abhimanyu Kumar27 22 views 2 comments 0 points Most recent by Abhimanyu Kumar27 Reporting and Analytics for HCM
-
Include/Exclude column based on the ParameterSummary: We have requirement to Include/Exclude the column based on the parameter Content (required): We have a requirement to hide a column in the report output based o…Vasanthakumar Ravi 114 views 0 comments 0 points Started by Vasanthakumar Ravi Reporting and Analytics for HCM -
How to get multiple value from table in Array format in Oracle BISummary: How can get Multiple value for the same data in Array format in one single row Content (required): Get the value in Array format in oracle need sql query Versio…
-
How to change date format in 30-06-2022 to 30-June-2022Summary: Hi Team, we have developed date as of now 30-06-2022 but business wants this format 30-June-2022. to_char(CURRENT_DATE,'DD-MM-YYYY'), -- 30-06-2022 May I know t…AjayKumar Maddipati 22 views 4 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
Scheduling Dashboard with BIP ReportSummary: Content (required): I am trying to schedule a dashboard which contains a tab with a BIP Report. When I schedule or export the dashboard, all other tabs (that co…Riti Malhotra 12 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Unable to fetch the data for Calculation card in HCM Payroll Employee Deduction BI reportSummary: Hi all I am not able to get these data from the backend for Element Name, Value, Effective Start date inside the Calculation Card : Benefit and Pension in HCM. …Deepak Bhatt 114 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Employees Performance goal BI report not showing properly in excel outputSummary Employees Performance goal BI report not showing properly in excel outputContent Hi , We have requirement to create bi reports to fetch the below goal columns fo…nitin Sharma 23 views 3 comments 0 points Most recent by User_2025-02-11-22-13-57-078 Reporting and Analytics for HCM
-
Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla versSummary OTBI Report on Structure (Quick Actions, Apps) with default seeded Expression Languages from Vanilla version as old value and new value as custom expression lang… -
Need to find the oracle table name in BI reportSummary: Hi all I am not able to find the Oracle table name for "TID Upgrade Job" Can anyone help me to find the table name for "TID Upgrade Job" and see the data from t…Deepak Bhatt 22 views 2 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM
-
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…Parag Hiremath 21 views 1 comment 1 point Most recent by Andrew_Schmitz Reporting and Analytics for HCM -
BI publisher not working as expected after 22B upgradeSummary: We are facing issues with BI publisher delivery options after 22B upgrade Content (required): We are running BI publisher from Oracle SOA and delivery options a…
-
Event Triggers in Data ModelSummary: Can someone explain how to use the event triggers in the Data Model Content (required): Can someone explain how to use the event triggers in the Data Model Vers…Mark kristan De los Reyes 22 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Event Triggers in Data ModelSummary: Can someone explain how to use the event triggers in the Data Model Content (required): Can someone explain how to use the event triggers in the Data Model Vers…Mark kristan De los Reyes 11 views 1 comment 0 points Most recent by Jbgood Reporting and Analytics for HCM
-
Has anyone created a dashboard page similar to a website using HTML CSS Coding?Summary: Has anyone created a dashboard page similar to a website using HTML CSS Coding? Can you please send a screenshot of your work. Content (required): Dashboard Pag…Mark kristan De los Reyes 12 views 0 comments 0 points Started by Mark kristan De los Reyes Reporting and Analytics for HCM
-
Reusable Data Model SQL QueriesSummary: Reusable Data Model SQL Queries Content (required): Hi Team, Greetings! Does any have Reusable Data Model SQL Queries for HCM modules (HR, Payroll , Benefits, O…Parag Hiremath 93 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM
-
Need help to Payroll Employee Deduction BI reportSummary: Report Parameter 1) Person Number 2) Element Name 3) Period 4) Pay Period Start Date 5) Pay Period End Date Report Column · Person Number · Person Name · Elemen…Deepak Bhatt 23 views 7 comments 0 points Most recent by Deepak Bhatt Reporting and Analytics for HCM
-
Query to Display the employee and the supervisor chain bottom upSummary: Does someone have a query for the employment and Supervisor/Manager hierarchy ? Content (required): Hello , I have very little experience in HCM tables, hence I…Cesar Saveedra 2.8K views 5 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for HCM