BI Publisher
Discussion List
-
How can we extract requisitions tied other locations data through BIP tables ?Content Hi All, PFA, screenshot and we have two tables available (IRC_REQUISITIONS_VL & IRC_REQ_LOCATIONS ) and the join is for tables is “IRL.REQUISITION_ID = IRV.REQUI…Janardhana Kondaveeti 43 views 4 comments 0 points Most recent by Janardhana Kondaveeti Reporting and Analytics for HCM -
Department Hierarchy and Department Changes reportingContent I have been working on rolling out a department hierarchy for my company. The hierarchy is complete and working but i am looking at how it interacts with things …User_2025-02-10-15-06-52-222 62 views 4 comments 1 point Most recent by MilanMohanty Reporting and Analytics for HCM -
.cvs output file is splitting in 2 columns I want it one column only.Content Hi Experts, I have BI Report and I want output as .csv Tab Delimited. I did all setup and when I schedule this report I see output in 2 columns (A & B). I want i…User_2025-02-07-19-03-14-525 21 views 5 comments 0 points Most recent by Dilpreet Kaur Reporting and Analytics for HCM
-
Oracle Fusion Financials, Bank Account > Business Unit Acess informationContent Hi all, I need to retrieve the accounting key linked to Business Unit Access information on the "Manage Bank Account" screen in Oracle Fusion. The path to get th…Paul Peter 669 views 2 comments 3 points Most recent by Paul Peter Payables, Payments & Cash Management -
Join AP payments (AP_CHECKS_ALL) with Bank statements (CE_STATEMENT_LINES)Content Hi all, I'm working on the financial module of ERP Cloud via BI publisher. In a report I need to cross Bank statement informations with AP payment information. M…Paul Peter 505 views 2 comments 1 point Most recent by Paul Peter Payables, Payments & Cash Management
-
Aggregate function on ValueSet is not workingSummary Aggregate function on ValueSet is not workingContent I have attached my query containing the where clause which is not working. Even the below value set is not w…Jaeyshree Kumaran 45 views 2 comments 0 points Most recent by Ashish Kumar Pandey Reporting and Analytics for HCM
-
Webservice to pull obiee reportSummary Webservice to pull obiee reportContent Hello all, Does anyone know how we can initiate a web service to pull a specific OBIEE report? Or is there a API that can …Nizar Kassam 28 views 2 comments 0 points Most recent by Nizar Kassam Reporting and Analytics for HCM -
Find maximum of 2 dates in different DGs in extract xml in BI Publisher Excel templateSummary Find maximum of 2 dates in different DGs in extract xml in BI Publisher Excel templateContent Hi experts, I have an excel template ( from a benefits extract) in …Aloka Bhattacharya 16 views 1 comment 0 points Most recent by Aloka Bhattacharya Reporting and Analytics for HCM -
User Manual for adding OTBI report to HR dashboardSummary User Manual for adding OTBI report to HR dashboardContent Hi Team, Can any share user manual/White paper for adding a OTBI report to HR dashboard. Appreciate you…Dinesh Neredu 39 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need Supplier Ledger Report with Debits and Credits(Posted/Unposted) to Supplier AccountSummary Need Supplier Ledger Report with Debits and Credits(Posted/Unposted) to Supplier AccountContent Hi Experts I am looking for a Supplier Ledger Report with Debits …Dharmendra Shukla 114 views 2 comments 2 points Most recent by Dharmendra Shukla Payables, Payments & Cash Management -
Analytics Dashboard section header and report link font formattingContent Hi All, I have embedded dashboard on homepage, which has report hyperlinks and section header displayed. I have managed to change the background color same as ho…Punam Roy Karmokar 21 views 2 comments 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM -
Duplicate Learning ActivitySummary Duplicate Learning ActivityContent Hi All, We have issue when user trying to complete activities in a Course/Offering. When trying to complete activities are get…
-
BI Publisher Bursting Real Time Notification/TriggerSummary BI Publisher Bursting Real Time Notification/TriggerContent Hi experts! I need to create and send an email notification whenever a person has enrolled or complet…Raymund Jerome 348 views 2 comments 1 point Most recent by Raymund Jerome Reporting and Analytics for HCM
-
Need to create a report that will extract data which doesn't have costing options enabled at departmSummary Need to create a report that will extract data which doesn't have costing options enabled at departments, jobs, positionsContent Hello Everyone, We have requirem…Prudhvi Indukuri 20 views 2 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Bursting Report With Multiple AttachmentSummary Bursting Report With Multiple AttachmentContent Hi Team We have a requirement to attach multiple document using busting query, How to add multiple attachment in …[Deleted User] 38 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Timezone used by time parameter is always in GMT. How can I let user pick the timezone when enterinContent I have a BIP report with a parameter with a time component (It is a date type with a date string of" MM-dd-yyyy HH:mm:ss am"). What I am noticing is that date en…Joe Roberts-Oracle 34 views 1 comment 0 points Most recent by MilanMohanty Reporting and Analytics for HCM
-
BIP Report Output as Text MessageSummary BIP Report Output as Text MessageContent Hello, Do we have any option to send BIP Report output as Text SMS message. Please let me know if you know if this is po…Harish Gundre 23 views 2 comments 0 points Most recent by Arghyo Banerjee -Oracle Reporting and Analytics for SCM
-
FBDI - Hierarchy Error MessageContent Hi All, Attached is the screenshots of the FBDI I need to use, on validating the segment Hierarchies (GL_SEGMENT_HIER_INTERFACE), I am getting error messages lik…Kanika Mahajan 237 views 2 comments 2 points Most recent by Aishwarya Thapar-Oracle General Ledger & Intercompany
-
In which report Enterprise name along with organization structure is displayedContent Hi Team, Do we have any report which displays Enterprise name alone with org structure details like Enterprise, division and so on. Kind Regards, Rahul -
External Invoice Status for Project Expense in FusionContent I am looking to pull the External Invoice Status of project expense in Oracle Fusion for a BIP Report. There is a invoiced_flag and ic_invoiced_flag(Invoiced fla…
-
Reporting for Multiple Asset BooksContent Assets partitions transaction data by asset book. This could be a challenge on complex implementations with multiple asset books sharing the same ledger. Oracle …Gergana Radoutcheva-Oracle 47 views 1 comment 5 points Most recent by Subramanyam Tumarada-Oracle Assets -
Approval Remarks for Completed Bank Reconciliation in Oracle Cash ManagementContent Hi I would just like to inquire if there is a way to mark the completed bank reconciliation in oracle cash management as "Approved"? because currently, what i ca…User_2025-02-11-12-30-38-982 46 views 1 comment 1 point Most recent by Cristian Bilibou-Oracle Payables, Payments & Cash Management
-
Adding run_result_values for multiple element_names in OTBI analysisSummary Need help in OTBI analysis with adding the run_result_values for different element_namesContent Hello Everyone, I am new to OTBI analysis and I need help with co…GauravGupta39 25 views 3 comments 0 points Most recent by GauravGupta39 Reporting and Analytics for HCM
-
How to display embedded dashboard only on a custom page categoryContent Hi Team, I have embedded a dashboard on homepage springboard. Now that dashboard is embedded to all tabs of the springboard. 1) Is there a way to embed it only t…Punam Roy Karmokar 26 views 1 comment 0 points Most recent by Punam Roy Karmokar Reporting and Analytics for HCM
-
Payables Matching Hold Report is not picking any hold gains invoice not PO matchedSummary Payables Matching Hold Report is not picking any hold gains invoice not PO matchedContent do we have any hold report in AP module which will pull all invoices re…Sam Samaddar 70 views 2 comments 0 points Most recent by Sam Samaddar Payables, Payments & Cash Management