BI Publisher
Discussion List
-
BIP excel template to enhance pivot chartsContent We are trying to build a BIP report and include analytics (pivot charts) on one of the tabs. is there a way to not have to repeat the filters? For instance, Stat…User_2025-02-10-08-27-16-805 33 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Scheduling/Automation software available to support Oracle Fusion.Summary Scheduling/Automation software available to support Oracle Fusion.Content Hi Experts, We have a requirement to automate and schedule process in oracle cloud. Exa…User_2025-03-10-23-59-44-230 47 views 4 comments 2 points Most recent by User_2025-03-10-23-59-44-230 Reporting and Analytics for ERP -
Vendor name not available at source lines for assets in FAContent Hi all, I face an issue where I don't get the vendor name for the table FA_ASSET_INVOICES where I take invoice no, PO no for source lines of an asset. When I add…Sushan Peiris 48 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP -
What is the best way to identify whether the current Fusion instance is PROD or Non-PRODSummary What is the best way to identify whether the current Fusion instance is PROD or Non-PRODContent As we need to transfer BIP Reports to different FTP file servers …Umamaheswara Reddy Karri 51 views 9 comments 1 point Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
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 63 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 666 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 511 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 29 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 118 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 23 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 351 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