BI Publisher
Discussion List
-
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 -
Does Invoice Imaging support Payable Invoice coming in Chinese Language?Summary Does Invoice Imaging support Payable Invoice coming in Chinese Language?Content Does Invoice Imaging support Payable Invoice coming in Chinese Language? Apprecia…Sam Samaddar 63 views 4 comments 1 point Most recent by Raj Bhakta Payables, Payments & Cash Management -
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
-
invoice attachments downloadingDear All Whenever we are checking an invoice and we want to see the attachment of that invoice once we click on it the system will automatically download it. Is there a …Mickel.Rmeily 21 views 1 comment 2 points Most recent by David Mckenna Payables, Payments & Cash Management -
Query or the table that contains financial catogory for manage value UISummary: Hello all, We have a report in which we need to pick the financial category code we put against an account in manage value UI.please advise! BR, Sushan Peiris C…Sushan Peiris 281 views 13 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
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 -
How to Translate the BI Publisher Catalog Report Name and parameter to multiple languages.Summary How to Translate the BI Publisher Catalog Report Name and parameter to multiple languages.Content How to Translate the BI Publisher Catalog Report Name and param… -
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 102 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
-
Can we use decode or if-else in excel templateSummary: Hi Team, Can we use decode or if-else in excel template for BI report. If yes. can you please share sample example. Regards Nidhi... Content (required): Version…Nidhi Chhajed 245 views 1 comment 0 points Most recent by Sahil_Makhiza Reporting and Analytics for SCM
-
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.2K 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…
-
Is there any sql query for pulling BIP reports location/path?Summary: Is there any sql query for pulling BIP reports location/path? Content (required): BIP Report properties Version (include the version you are using, if applicabl…User_2025-02-05-14-11-28-072 475 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM -
General Ledger Transaction Listing ReportSummary Lists down all Journal Entries along with corresponding subledger detailsContent This is one single consolidated view of all the transactions in ERP. This report… -
Unauthorized Access: Either you do not have the privilege, or you have not signed inAfter latest upgrade from Oracle fusion to version 22A and 22B - OTBI users are experiencing this error - intermittently. Everytime they refresh it connects back - but i…Dhruvjoshi23 177 views 5 comments 2 points Most recent by User_CUA6U Reporting and Analytics for ERP -
Request to share solution to display SO Header attachment URL on BIP report output and download itSummary: We have a requirement to build a custom BIP report in Oracle Cloud ERP (SCM Module). If there is any attachment at Sales Order Header Level, then we want to get…Amit Sutar 51 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
Best practice to re-use same query in the same BIP data modelSummary: I have a common query say for selecting business unit based on certain user based login. Now I have a main data model query with multiple sub-queries in it. And…Ashu Raj-Oracle 31 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP