Fusion Financial reporting
Discussion List
-
Customizing the Accrual Reconciliation report to a more usable excel sheetSummary: Business is using the Accrual reconciliation report to reconcile the accrual account with the PO details. Currently business has huge data in this report for ce… -
FRS - To get the end date of the period selected at the report running parameterSummary: Content (please ensure you mask any confidential information): Hi All, Do we have any option to get the end date of the period which is selected while running t…Vipusha Chandrakumaran 7 views 0 comments 0 points Started by Vipusha Chandrakumaran Reporting and Analytics for ERP
-
Are there out of the box reports for financial reporting studioSummary: We wanted to see the capabilities/use case for Financial Reporting Studio. When you browse through the catalogue there it appears to use the same catalogue as O… -
NEW REPORT: Journal and Transaction Details ReportSummary: The Journal and Transaction Details report lists general ledger journals and subledger transactions activity along with header, line, and distribution-level det…Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle 268 views 6 comments 4 points Most recent by David Bryden Reporting and Analytics for ERP -
How to restrict users from using direct base tables in Data ModelWe have to provide certain users with Create Data Model access in BIP, but need to restrict them to usage of only certain tables or certain data in the tables. Do we hav…
-
How to create a parent schedule for multiple schedule of one BI Publisher reportClient has created multiple schedule of one one BI Publisher report using different parameters ex-cost centres and different recipient in each schedule. Is it possible t…Saikat1 22 views 1 comment 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
Do we really need the ESS Administrator Role to run the Approval Groups Report ESS Job?Summary: We figured out two levels of security are required to run the "Approval Groups Report": Enable the user to Submit the Scheduled Process /oracle/apps/ess/financi…Thomas De Leeuw 22 views 2 comments 1 point Most recent by Thomas De Leeuw Reporting and Analytics for ERP
-
Restricting Data retrieved by BIP report queryHi, We have requirement to restrict the data returned by BIP query based on Data Access Security setup on ERP Cloud. We find that we have concept of Secured List Views (…AbdulBasith 26 views 3 comments 1 point Most recent by James McBride Reporting and Analytics for ERP
-
Drill Down To Fusion Financial Applications from OTBI ERP ReportsSummary The purpose of this White Paper is to demonstrate how users can drill from Oracle Transactional Business Intelligence (OTBI) adhoc reports to transaction details…Veronica Dumitriu 7.9K views 161 comments 44 points Most recent by Anandita Biswas-Oracle Reporting and Analytics for ERP -
BIP internal bank account table?Hi Guys When I search online I get told to use view CE_INTERNAL_BANK_ACCOUNTS_V to lookup field INTERNAL_BANK_ACCOUNT_ID out of table iby_pay_service_requests. However w…
-
How to unmerge the cells when the rtf template is exported to Excel ?Summary: We have a report requirement that rtf template is exported as an excel output report, but the issues are the rows are getting merged in excel Output. Content (r…Abhhishek42 133 views 7 comments 0 points Most recent by Ralph Aldrich Magno Reporting and Analytics for ERP
-
PO Column for Receipt Accounting Source in Oracle Fusion. Which role or privilege needs to be added?Summary: PO Column for Receipt Accounting Source in Custom Account Analysis Report in Oracle Fusion. Which role or privilege needs to be added? Content (please ensure yo…
-
Why do scheduled reports with a daily frequency cannot be received on a weekend (Saturday & Sunday)?Summary: The business users created a schedule for the daily backup of a report, but the backup mail is being received only from Monday to Friday. Mail for Saturday and …Czarina Morales 29 views 3 comments 1 point Most recent by Czarina Morales Reporting and Analytics for ERP
-
How can I configure "All" prompts in BI PublisherSummary: Content (please ensure you mask any confidential information): I have a report with some parameters, I would like them to come with the default value "All" and,…
-
How to add 2 columns in group by in Excel templateSummary: Need to add 2 columns in Group by expression in EXCEL template Content (please ensure you mask any confidential information): below condition is working for 1 c…Thanigainathan R 26 views 2 comments 0 points Most recent by User_6NK6Y Reporting and Analytics for ERP
-
Inquiry AP ReportSummary: Is there a Payables report that I can run that provides a clean listing of invoices as of a specific date that make up the balances shown on the Payables Trial …
-
Receivables Concatenated Segment is not showing updated account in OTBI report.Summary: Hi, We have an OTBI report using Receivables - Transactions Real Time wherein we have added 'Receivables Concatenated Segment' column but it is showing the Reve…Rahul Kumar Gupta.-Oracle 3 views 0 comments 1 point Started by Rahul Kumar Gupta.-Oracle Reporting and Analytics for ERP -
can not find new option under file menu in FRS to create a batch in BI cataloguecan not find new option under file menu in FRS to create a batch in BI catalogue
-
Not able to add Budget Values(amount) column in FRS Report.We have an FRS Report for Profit & Loss Account where the accounted values are reflected. We have a requirement to add Budget Values also in the FRS, but we have tried e…Jagjit Singh Arora 35 views 4 comments 0 points Most recent by Jagjit Singh Arora Reporting and Analytics for ERP
-
How to extract attachments for Journals and Payables Invoices for a given period of timeOur company is being sold and we need an extract of journal and payables invoice attachments for a given period of time for audit purposes. We would like the attachment …
-
No Data Found when Other Users run BIPSummary: I created a simple vendor report with BIP. I can run it fine and see the data such as vendor name, number, address, etc. I have another user, Employee B, who on…
-
ORA-06512: at "SYS.XMLTYPE", line 169Summary: Hi, i have created the AR Invoice Auto Mail by taken the reference of "Print receivable transactions", if i schedule the report the report should send the invoi…Siva BVP-Oracle 12 views 0 comments 1 point Started by Siva BVP-Oracle Reporting and Analytics for ERP
-
Automatically create a prepayment invoice from POSummary: Is there a way to automate the creation of prepayment invoices in AP from a PO? We would like to be able to create a PO and somehow specify the PO is expected t…AndresGlz2109 32 views 2 comments 0 points Most recent by AndresGlz2109 Reporting and Analytics for ERP -
OTBI Report for AP Invoice HoldsSummary Sample OTBI Report for ERP Cloud: AP Invoices on HoldContent This is an update on Andy Gough's Topic using the new subject area. I have also enhanced Andy's repo…SimonTomey 597 views 12 comments 10 points Most recent by Melissa Goodrich Reporting and Analytics for ERP -
Inconsistent running time of BIP reportsHello Everyone, We have an existing Custom BI Report that we are monitoring, running this report thru Scheduled Jobs 10 times to check how long this report run. Sometime…Michael_B 34 views 3 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
OTBI AP invoice report for approver, approval action date, payment dateSummary: We tried to build one, but the payment date is coming in incorrectly where it says it was paid before the invoice was even created. Anyone successfully build su…Alex Glose 5 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management -
FRS YTD HTD instead of Month/QuarterSummary: We are designing a new report with BU Assets and its balance. We see the dimension as Year, Quarter and Month. Is there any way we could use the option HTD (His…
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter Deve…Rashmi M-Oracle 40.7K views 126 comments 28 points Most recent by Dave Kekish Reporting and Analytics for ERP
-
Connect GL Location Segment to Location AddressHi, we have Locations in Oracle we need to associate with the Location Segment in the GL Account String. Scenario: We have Account Aliases we are using to decrement our …Becca Edwards 31 views 1 comment 1 point Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Deeps links for payable invoicei want to create a payable report when i click on invoice number open a new windows have the invoice deatils i want a deeps link for the payable infoices