BI Publisher
Discussion List
-
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 248 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 53 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 485 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 184 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 53 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 52 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 31 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 25 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Strange SQL results, can't explain causeHi, I am comparing the use of SQL via Analytics between instances used by 2 different customers, both on version 22A. Example URL: example.fa.ocs.oraclecloud.com/analyti…
-
Talent Score - deep link in BIPSummary: Does anyone know if you can deep link from BIP to the Talent Score screen? I think it is here: My Team > Career and Performance path, page titled “Goals and Per…Andrew_Schmitz 11 views 0 comments 0 points Started by Andrew_Schmitz Reporting and Analytics for HCM -
Links with BI Publisher when using With ClauseSummary: Data sets using the With Clause lose the ability to create links between datasets Content (required): I'm trying to leverage the powerful WITH clause in a bi pu… -
How to get data in 2 fields for Payroll Relationship -> 'Time Card Required' ?Summary: There are two fields for 'Time Card Required' on the Payroll Relationship responsive page. One is at the Payroll Association level and other at Payroll Assignme…Vinay Hardas 146 views 4 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for HCM