Fusion Financial reporting
Discussion List
-
Is there any formula to calculate the number of days in a financial year in FRS?Summary: We have a requirement where we need to apply a formula as [(Row 1)+(Row2)]/Number of days in a FY, so for that we need to automatically get no.of days calculate…Srishti Kedia-Oracle 52 views 1 comment 1 point Most recent by Rana Junaid Reporting and Analytics for ERP -
Procurement OTBI DashboardsSummary ERP Procurement OTBI Reports and Dashboards uploaded for the CommunityContent Sharing a procurement to pay dashboard with multiple tabs containing example report…user799189-Oracle 501 views 13 comments 15 points Most recent by Remigious Reporting and Analytics for ERP -
Query to get hash codes in case of Fusion APISummary: In max of the REST API for Fusion, we need to pass hash keys like for example in case of Invoice attachment (https://docs.oracle.com/en/cloud/saas/financials/23…sailesh_cloudare 32 views 3 comments 1 point Most recent by Lee Eslick-Huff Reporting and Analytics for ERP -
Need to know how much longer the ESS/Scheduled jobs logs can keep in the system.Summary: Need to know how much longer the ESS/Scheduled jobs logs keep in the system. Content (required): How much longer we can pertain the logs of the ESS/Scheduled jo…Jhansi.nallani 32 views 5 comments 0 points Most recent by Jhansi.nallani Reporting and Analytics for ERP -
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21BDevendra Thota 134 views 3 comments 3 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Viewing USD AmountSummary Viewing USD AmountContent Hi, We have many companies in different countries that have different currency. We designed an pivot table using OTBI for Purchase Orde…Eren Göktepe-155015 40 views 6 comments 0 points Most recent by Zehra M Reporting and Analytics for ERP -
how can we schedule the archive processhow can we schedule the archive process Content (required): how can we schedule the archive process for custom reports Version (include the version you are using, if app…
-
Ctreating a report for my PPM moduleDear all I am creating a report for my PPM module I just want to list the project name - task name and number - Cost and Resource I found all the above except the Resour…mickel rmeily 12 views 1 comment 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP -
Why the condition row value is not able to sum up as expected.Summary: We have got a requirement where either of one value is nonzero consider that value for result row. Row values are Account 400000 Department 555015,Account 40000…Monika Gnanavallal-Oracle 12 views 1 comment 0 points Most recent by Monika Gnanavallal-Oracle Reporting and Analytics for ERP
-
Page is not available after Click Launch Financial Reporting Web StudioSummary: Page is not available after clicking Launch Financial Reporting Web Studio Content (required): I Went through the following path to do and adjustment in Grids a…Mohamed Ramees 12 views 3 comments 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP -
FRS scheduler how to pass current month or Date to PromptSummary FRS scheduler how to pass current month or Date to PromptContent We are scheduling FRS reports. When we create batch it requests to enter the prompt values. Thes…saravana maneeian subhramaniun 88 views 3 comments 0 points Most recent by Kannan_Ra Reporting and Analytics for ERP
-
Sorting in eText templateSummary: We have a requirement to sort data based on a tag from XML using eText template Content (required): In eText we can sort based on tags but here we have to sort …
-
Is there a mapping document from eBS to Fusion CloudSummary: We are moving one of existing eBS customer to Cloud and while moving existing reports for customer, we are facing many challenges to map eBS fields to Fusion Cl…Sanjaykuamar Varma-Oracle 296 views 4 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP -
How to enable external directory in Oracle FRS schedulerSummary: How to enable external directory in Oracle FRS scheduler Content (required): We want to be able to send the output of FRS using a batch scheduler on an external…
-
I cannot see bursting enabled in batch scheduler in FRSSummary: I cannot see bursting enabled in batch scheduler in FRS Content (required): I created a batch and added two reports. Next I created a batch scheduler and added …
-
Receivables Aging by General Ledger Account Report - Group by Natural Account segmentRequirement is to group Receivables transactions in "Receivables Aging by General Ledger Account Report" by Natural Account segment only, not by alll Chart of Account di…
-
Print Preview can not be customized to show approverSummary: When I try to modify the "Printable Expense Report Template" as described here: https://docs.oracle.com/en/cloud/saas/financials/23c/faiex/modify-the-printable-…Anders W. Langholm 2 views 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP -
Populate DFF value in Journal Screen based on another field in JournalSummary: Define a DFF at the journal line level and default the parent level COA segment value in this DFF based on the child level COA segment in the journal line COA.…Abhilash K - Deloitte USI 22 views 4 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Bold Style is missing for Arabic text in PDF output of rtf templateSummary: We have a check template (.rtf) developed with Payment Date, Payee Name, Payment Amount and Payment Amount in Words . In these fields, Payee name and Payment Am…SireeshaJaladi 104 views 11 comments 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Deeplink to GL Journals from OTBISummary: Hi All, Trying to implement the deeplink in OTBI to GL Journals. No Subject area in OTBI has jeBatchId column. Validate this in Fusion OTBI Data Lineage Mapping…ArunKumarDammalli 52 views 3 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
How t get login detail report in oracle fusionSummary: Content (required): Dear All How we can generate login report in oracle fusion for all the users , with Date , Time , user Name etc.. Version (include the versi…Shameer Muhammed P M 52 views 2 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
Cannot connect to URL in FRS ReportSummary: Hello, When trying to edit my FRS report or even adding a member, like Aug-23 in the Accounting Period, the system gives me a white screen with an error of 'htt…
-
How can a User view scheduled OTBI reports monthly?Summary: I removed the BI Author & BI Administrator role from a custom role for a user - leaving only the BI Consumer role within this custom role. User is not able to v…Akbar Ahmed 42 views 2 comments 0 points Most recent by Gayatri Chappalli-Oracle Reporting and Analytics for ERP
-
Procure to Pay DashboardsSummary: Procure to Pay Dashboards Content (required): How can these be added to the home dashboard once the user is login, instead of going to reports and analytics and…CraigX 42 views 5 comments 0 points Most recent by Prasanth Senthivel-Oracle Reporting and Analytics for ERP
-
SmartView Duplicate name Error from sharded driveSummary: Smartview Spreadsheets are kept in a shared drive (OneDrive). After a hierarchy change (A single value added or moved)we continually see errors like : Essbase E…Service Desk Claremont 12 views 0 comments 0 points Started by Service Desk Claremont Reporting and Analytics for ERP
-
How to encode etext output file from UTF-8 to ANSI in OracleSummary: We have custom etext payment file for Citi Bank EFT. the output of Etext file is .txt and it is encoded in UTF-8 by default. how can i convert this text file fr…SireeshaJaladi 22 views 0 comments 0 points Started by SireeshaJaladi Reporting and Analytics for ERP
-
How to get output character set in ANSI for etext templateSummary: In Oracle etext template is set to "iso-8859-1", what value we need to provide to change it to ASCI. Content (required): Version (include the version you are u…SireeshaJaladi 32 views 1 comment 1 point Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
Getting remittance message columns in OTBI before payment is madeWe want to create a report which we can use to check whether all payment details are filled correctly for large batches of payments before creating them, to prevent down… -
Rest API to GET reports from BIP in Fusion Financials SAASSummary Is there a Rest API to get BI Publisher reportsContent Hi All Is there a Rest API to call BI Publisher reports from Fusion Cloud Financials within SAAS financial…
-
REST API to run FRS reports in FusionSummary: Need to know REST API details if any to run FRS reports in Fusion Content (required): REST API to run FRS reports in Fusion Version (include the version you are…Sudha KOVURU 122 views 3 comments 0 points Most recent by Sukanya Mukherjee Reporting and Analytics for ERP