BI Publisher
Discussion List
-
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 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
-
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 243 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 474 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 175 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 -
Need help to find the oracle table name of columns in Payroll Employee deduction report using BISummary: In the BI report, I have the requirement to add these Columns in my report Columns 1) Period 2) Pay Period Start Date 3) Pay Period End Date 4) Deduction Amount…Deepak Bhatt 33 views 7 comments 0 points Most recent by Sharon Harper Reporting and Analytics for HCM
-
E-Mail Notifications in Learning (for Learners & managers)Content Hi all, we are struggling with e-mail notifications for Learners. We need to notify Learners via e-Mail, as soon as certain events occur. E.g.: The learner is as…
-
Need help of running Element Entries - Real Time report for Workers Element entriesSummary: Hi Experts, We need to report on payroll elements for Employees. We have tried to use the subject area Payroll - Element Entries Real time. Whenever we are addi…Silpi 41 views 4 comments 0 points Most recent by Dannielle Dellucci Reporting and Analytics for HCM -
Generate Employment Letter after approvalSummary: Employment letter can be generated using BI Reports but client wants certain letters to generated once manager/hr approves Content (required): Is it possible to…VivekHCM 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Query to extract ExternalWorkerDataId by Start/End Date and Person NumberSummary: Hello experts, I should update external worker data. However, ExternalWorkerDataId information is not available in OTBI analysis. Is there a query available to …Valerio Curzi 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM