BI Publisher
Discussion List
-
SQL to get the 9 box ratingSummary SQL to get the 9 box ratingContent Can someone help with the physical SQL for this logical SQL Basically i want the 9 box rating value for the employees. SELECT …Jagdish Varadraj 296 views 4 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting and Analytics for HCM -
Function for getting leave balance prior to execution of monthly leave accrualSummary Function for getting leave balance prior to execution of monthly leave accrualContent Hi, Please share function name or logic in order to get the leave balance o…Ghouseuddin Mohammed 44 views 6 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Vacation Rules - table where data is stored???Summary Need to know if anyone has identified the table(s) where Vacation Rules are storedContent Wanting to know if anyone has identified where the Vacation Rules are s…Jeff Hare CPA CISA CIA 151 views 4 comments 1 point Most recent by Sreeni Devireddy-Oracle Reporting and Analytics for ERP -
Need to be able to identify all BIP Reports and Analyses that use particular field as filterSummary Need to be able to identify all BIP Reports and Analyses that use particular field as filterContent Does anyone know if there is an Oracle program that will iden…Rich R 46 views 3 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for HCM -
How to hide data model and edit access for BI ReportsContent Hi Export, We have a requirement to give only view access for BI Report and nothing other than. So we are planning to hide the data model so that a user can not …MohammadAfghanul Khair 293 views 4 comments 0 points Most recent by MohammadAfghanul Khair Reporting and Analytics for HCM -
OTBI - unable to extract catalog request justificationSummary Tried to pull a report in OTBI with the justifications that our employees submitted when they requested for catalog items, but did not manage to do so.Content He… -
R13 20A - How to extract BPM approval Configurations task details via SQLSummary Need to extract BPM approval configurationsContent We have a need to extract all the BPM approval configuration task details via SQL. All things BPM related (the…Suganthi Srinivasan 104 views 4 comments 5 points Most recent by Venkatraman G Reporting and Analytics for HCM -
ESS Access to Custom BI Publisher ReportSummary Access to a Custom BI Publisher Report as Employee Self ServiceContent Hi Friends We have a custom BI Report and one of the parameters is the name. Right now thi…Mansur Khalil 79 views 15 comments 1 point Most recent by AshishERPCloud Reporting and Analytics for HCM -
Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodSummary Benefits Rates and Coverages - Report for Newly added and Dropped Coverages during a pay periodContent Hi Experts Please let me know if there is a report for all…Mansur Khalil 53 views 3 comments 1 point Most recent by Adam Gates-Oracle Reporting and Analytics for HCM -
WRS best practice for Financial reports or Oracle BI publisher is more stable?Summary WRS vs BI PublisherContent Where is it recommended to develop a complicated financial report with compairsons Oracle BI Publsiher will be better as best practice…Umer.Farooq 39 views 1 comment 1 point Most recent by Neil Ramsay-Oracle Reporting and Analytics for ERP -
The report cannot be rendered because of an errorSummary The report cannot be rendered because of an error BI ReportContent Hi All, I have a BI Report with custom RTF template. Report runs fine for few users and for fe…Jagdish Varadraj 58 views 5 comments 0 points Most recent by Jagdish Varadraj Reporting and Analytics for HCM -
Check-In Performance Template BIP table Joins.Summary Can anyone please explain how goals and its feedback are tied/joined to check-in peformance template for reporting purpose using BI Publisher.Content We have a B…User_0REWN 88 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Requisition approval notificationSummary Can we use seeded BIP Requisition approval notification as a FYI notification for submitter?Content Hello, We have a requirement to send a FYI notification for t… -
How to Print the attachment in PO ReportSummary We have a requirement to get the attachment from a PO should get displayed on the View PDF document. Kindly SuggestVersion 11.13.20.04.0Yogesh Kumar-234569 136 views 3 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for SCM -
Usage TrackingSummary OTBI Usage TrackingContent Is Usage Tracking available for OTBI Reports? Something like in 20A for BI Publisher reports? Or even that which is available for OBIE…User_2025-02-05-23-02-10-916 97 views 6 comments 2 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM -
How to retrieve attachment file of expense item in a BI ReportContent Hi everyone, Is it possible to get the attachment of an expense item through a BI report? So far I have only found the tables from fnd_documents and fnd_document… -
Is it possible to fetch Hire Date changes of employees through HCM Extract or OTBI?Summary Is it possible to fetch Hire Date changes of employees through HCM Extract or OTBI?Content Hi Experts, We are looking for a requirement to fetch Hire date change…Harish Kumar Kovi 54 views 4 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM -
Trace Transaction Creation Rule Name from External Transaction ID on Bank Statement LineSummary Trace Transaction Creation Rule Name from External Transaction ID on Bank Statement LineContent All, I have a report that I built which provides all of the bank …Bobby Choate 50 views 1 comment 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Multiple attachments through BIP BurstingContent Hi All, Can we send multiple attachments (PDF, Excel) for an employee through BIP bursting in a single mail? Thanks, Visu -
PER_JOBS_F.APPROVAL_AUTHORITY Translate ValuesSummary Trying to pull in the Name (translate value) for the Approval Authority code on JobVersion 20B -
Page background image not appearing in BI Publisher previewsSummary Page background image not appearing in BI Publisher previewsContent I have created a background image to be included on every correspondence page (invoices, dunn…RichardChan 114 views 2 comments 1 point Most recent by Kondaiah Mandadi-Oracle Receivables & Collections -
Payment Reference Number field subject Area in OTBI for PayrollSummary Payment Reference Number field subject Area in OTBI for PayrollContent Hi All, We are trying to create payroll reconciliation report and we are almost completed … -
Hiding prompt while exporting data from dashboardSummary Hiding prompt while exporting data from dashboardContent Hi Team, Can you please let me know how to hide the dashboard prompt while exporting data to excel. Than… -
Can we lock the column order in the report outputSummary Can we lock the column order in the report outputContent Hi Team, Can we lock the column order in the dashboard output so that customer will not change the order… -
Reports got failed when scheduled in DEV3 completed in DEV2Summary Reports got failed when scheduled in DEV3 completed in DEV2Content Some of our reports got failed when scheduled in DEV3. On analysis we could see that the Data …User_2025-02-06-15-04-02-124 16 views 3 comments 1 point Most recent by Visu Reporting and Analytics for HCM