BI Publisher
Discussion List
-
Fixed Asset Summary ReportSummary FA Balance Summary Report for QTD and YTD by Asset CategoryContent Hello, We have a requirement of a Fixed Asset Summary report which shows the trial balances by… -
need query to get link between grants-->awards-->projects to gl_code_combination tableSummary need query to get link between grants-->awards-->projects -->project budgets-->working versions-->period accounts to gl_code_combination tableContent need query …User_2025-02-11-22-16-56-998 1.5K views 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for SCM -
Is it possbile to extract the SQL's wirtten in BI Publisher?Summary Is it possbile to extract the SQL's wirtten in BI Publisher?Content We would like to know if there is any option to export all the custom sql's written in BIP. T…GTS Narayanen 44 views 3 comments 1 point Most recent by MandeepGupta Reporting and Analytics for HCM -
SETSTAT is something that isn’t supported by AWS. How to solve?Summary Trying to deposit a file on a FTP but getting errorContent Hello, we need to deposit a file on an FTP of our partner. I'm using Oracle HCM BI. The configuration …Nicola Petri 26 views 1 comment 0 points Most recent by Hari Arumugam Reporting and Analytics for HCM
-
Source Safe - Oracle Fusion BIPSummary Source Safe - Oracle Fusion BIPContent Hi, Can you please guide me on how to and best tools for setting up Source Safe for Oracle Fusion BIP (ERP/HCM), as we wou…Rakesh Sreenivasa 26 views 0 comments 0 points Most recent by Rakesh Sreenivasa Reporting and Analytics for ERP -
Facing a error while fetching the balance Results from Payroll. Error : ORA-20001: An error occurredContent I'm fetching the different balance results from payroll custom balance groups & getting an error ORA-20001: An error occurred. An assertion failure was detected …Akshat Rajpurohit 29 views 1 comment 0 points Most recent by user526585-Oracle Reporting and Analytics for HCM -
CSV output being generated in a different layoutSummary BI Publisher report tab is not working properly when CVS output is selected.Content Hi Team, Maybe this is a known issue and I getting late aboard. I've added a …Alvaro Couto 30 views 3 comments 1 point Most recent by Alvaro Couto Reporting and Analytics for HCM -
in Hyperlink translated as %3c?EVALUATION_ID?%3eSummary in Hyperlink translated as %3c?EVALUATION_ID?%3eContent Hi, We are trying to add a hyperlink on BIP report with a EVALUATION_ID. EVAlUATION_ID is translated per…Salman 14 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Not able to print pdf output after setting pdf security to true in report propertiesSummary Not able to print pdf output after setting pdf security to true in report propertiesContent Hi All, In order to avoid document modification we have set report le…User_XT9HW 8 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 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 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 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 115 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…