BI Publisher
Discussion List
-
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 41 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 41 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 27 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 111 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 11 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 21 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 121 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 21 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 11 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 121 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 21 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 21 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 11 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 101 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 21 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 3.1K views 5 comments 0 points Most recent by Cesar Saveedra Reporting and Analytics for HCM
-
Report data not displaying in tab delimited formatSummary: I am trying to extract data in CSV format. I need the data to show in tab delimited format. Content (required): I am trying to extract data in CSV format. I nee… -
BI Publisher versionSummary: Need inputs to find the BI Publisher version in Fusion. Content (required): Need steps/sql query to find the BI Publisher version in Fusion. Version (include th…
-
Incorrectly formatted phone number in OTBI tableSummary: Content (required): Hello! I have noticed a situation in our Fusion tables that I'm curious about resolving. We are currently seeing two phone numbers for two d… -
Is there any way to automatically download the data and upload to FusionSummary: Is there any way to automatically download the data using BI Report and upload it back to Fusion Content (required): We have a requirement to generate some data…Dharmendra Shukla 51 views 2 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Need help on Payroll Pension Summary BI reportSummary: These are the columns that I am not able to find the exact table name from Oracle fusion Plan Annual Pension Pension Date Pension Year % Vested Fiscal YTD Conte…