Reports
Discussion List
-
FRS Report is opening in multiple tabs for some users and not for others. Is there a specific setup?Hello, We have created a consolidated FRS report for one of our clients and when the user downloads the report, it opens in multiple tabs in excel for one users. For oth…Shriya Srinivasan 11 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Fixed Assets Report Showing Data from Financial Book but Not from Tax BookWhen generating a Fixed Assets report, the output displays information from the Financial Book, but no data appears from the Tax Book. Could this issue be related to a m… -
BPM Approval Group tables to fetch the approval informationWe are trying to fetch the approval group for which an approval task is triggered. We are able to fetch the approver name and task details in the table - FA_FUSION_SOAIN…Anishka Agarwal 41 views 2 comments 0 points Most recent by Sreenivasulu Elluru Payables, Payments & Cash Management -
How to generate a BI Publisher URLI need to create a direct URL for the PayablesTrialBalance.xdo report in BI Publisher that will display the report with the correct parameters and formatting in the brow… -
To fetch all the approval group details for a journal.Hi, I am working on a GL workflow BIP report where I need to fetch ApprovalGroup Details like ApprovalGroupName, Approval Sequence, Approval Comments for a journal. Plea… -
FDI create a custom subject area using the PVO'sWe have a requirement to print the AP invoice attachment URL and the attachment file name in the FDI report. Currently ap invoice subject area don't have these attribute… -
PO PDF Report Showing Truncated “Text to Supplier” – Full Attachment Name/Text Not Printing CompleteHi all, We’re facing an issue with the PO PDF report where the Text to Supplier (or text from the URL attachment) is not printing completely. When we open the attachment… -
For the customized Print receivable transaction report, the ess job fails with errorSummary: As part of the Run , our Print Receivable Transaction Report job is failing and the ESS log message provides us the below error message AR_ESS_PLSQL_WRAPPER_PKG… -
Invoice Payments querySummary: Create New Invoice Payments Reports Content (please ensure you mask any confidential information):I would like to create a new report in Oracle Fusion ERP to qu…RAJAGANAPATHI 105 views 0 comments 0 points Started by RAJAGANAPATHI Payables, Payments & Cash Management -
Customize Report failed to generateSummary: Customize report in Report and Analytic fail to generate in this moth Content (please ensure you mask any confidential information): I have a customize report t… -
AP Account Coding Approver CommentsSummary: We have built an AP Account Coding workflow report which pulls in comments that are left by approvers of the account coding. However, we noticed that these comm… -
Balance Sheet is displaying 0 figures when selecting Accounting/quarter as parameter in FRCWe have configured the Balance Sheet with parameter as per below But the figures when selecting accounting/quarter in the parameters are not appearing.Kirtee Jeetah-Naran 1 view 0 comments 0 points Started by Kirtee Jeetah-Naran General Ledger & Intercompany -
Income Statement and Balance Sheet are returning error values for Net Income and Asset balancesWhat are the possible reasons for Net Income and Asset values showing error values in the Income Statement and Balance Sheet generated in FRS? Investigation performed so… -
Need the joining table for Manage contract types columns buyer role and seller roleSummary: I need the joining for OKC_CONTRACT_TYPE_PARTIES for buyer role and seller role as I am getting whole data for the roles but I need to get only buyer and seller… -
Need to see supplier full account numberSummary: Is there any standard report in oracle we can leverage to see the full account number of Supplier. Could you please confirm? Content (please ensure you mask any… -
Find employee job application source in fusion hcmSummary: Find employee job application source in fusion hcm Content (please ensure you mask any confidential information): Our requirement is to get employee job applica…SUDIPTA KODALI 11 views 1 comment 0 points Most recent by Sunder.Velagala-Oracle Recruiting, Opportunity Marketplace -
Does Oracle Fusion Cloud have any standard report/Localization for FTA VAT Audit File, (FAF)Hi Experts, The United Arab Emirates tax authority, Federal Tax Authority (FTA), audits businesses at its discretion to ensure accurate and timely tax declarations. As p… -
Query to get composite key - learnerLearningRecordsUniqIDSummary: How do i retrieve the learnerLearningRecordsUniqID to get the information of the learnerLearningrecords information. {{baseurl}}/hcmRestApi/resources/11.13.18.0… -
Issue with exporting xls data from several reports for some usersSeveral of our users are facing the issue(see a screenshot below) when they try to extract XLS from several Financial reports (all of them for reports from the EPM works…Ann Djiyanova 11 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform -
Tax Audit Trail Report export to excel not working properlySummary: Tax Audit Trail Report export to excel not working properly. This started happening in Feb25 after patch. HTML looks ok but when you export to excel it is messe… -
Is it possible to implement a parameter refresh function when the parameter is in date format at BIPSummary: Is it possible to implement a parameter refresh function when the parameter is in date format, like a text parameter? Content: Hi, In the SQL for the parameter …M Watanabe 11 views 1 comment 0 points Most recent by CristinaV1-Oracle Payables, Payments & Cash Management -
Values exported from Financial Reporting Studio to Excel with the wrong sign!We configured a report on FRS (Financial Reporting Studio), the customer asked us to set the opposite sign on the values present in the system (e.g. in the system the …Michele Ferro-Oracle 11 views 2 comments 0 points Most recent by Rich Merkel General Ledger & Intercompany -
What is the usage of ROW[#Ref] function in the Financial Reporting StudioSummary: There is a Function called ROW[#Ref] in the formula for FRS. What is the usage of it. Content (please ensure you mask any confidential information): Version (in…SuniChacko 1 view 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
Why Fusion and OTBI report gives different Validation StatusIn OTBI I use the MATCH_STATUS_FLAG from AP_INVOICE_DISTRIBUTIONS_ALL to get the validation status. A - Validated Null - Never / Not Validated T - Needs Revalidation Is …Alvin 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Shipment Details To Costing JoinsHello Team, i need to join the wsh_delivery_details with cst_cogs_details table but could not find a -
Update information in Financial Reporting when new accounts are addedI would like to update information in Financial Reporting when new accounts are added: I have a report built in Financial Reporting, but the new account I added isn't ap…Jorge Luis Gomez 31 views 1 comment 8 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany -
We need some assistance to create a report from the budgeting systemSummary: There is a requirement to create a report from the budgeting system with the fields 1.Budget year 2.IT Budget allocated by Business Unit 3.IT Budget - Actual vs… -
Need a report with employee's default expense account and position informationSummary: I need a report with the employee's default expense account and position information so I can verify the account is correct. Is there a trick to connecting the … -
Query/tables to find payment approved by final approver approved PPRSummary: Query/tables to find payment approved by final approver approved PPR Content (please ensure you mask any confidential information): Hi All, We got a requirement…Venkatesan 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management -
Hello, I need help with SQL query joining 3 subject areasSummary: Hi, I need some help to verify my query. I'm trying to join 3 subject areas: "Workforce Profiles - Person Profile Real Time", "Workforce Performance - Performan…