Reports
Discussion List
-
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… -
FRS reporting issues- dimension placement making huge differencesI’m having an issue with an FRS report. When I place the scenario in the columns, the trial report doesn’t match the one from the generated from scheduled process, but i…
-
To identify last modification details in Item Master , Item Locator and SubinventorySummary: We want to identify last modification details in Item Master , Item Locator and Sub inventory other than the 'last update date' , 'creation date', 'last updated…PrerakKhandelwal 21 views 0 comments 0 points Started by PrerakKhandelwal Reporting and Analytics for ERP
-
Query to retrieve list of bi publisher jobs in oracle fusion.Summary: Hello Team, Could you please help in providing the query to show all the scheduled jobs from BI publisher page. Content (please ensure you mask any confidential…Srushti Dhote 22 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
Is there a way to change the format of the output from a report?We currently have a custom report we use for maintenance, and the user is requesting we help him change the output options so CSV can be used. We currently only have HTM…
-
What is the recommended way to extract data in bulk from the compensation external data tables?Summary: I need to extract Total Compensation Statement data from the the external data tables. What is the recommended way of doing that? Content (please ensure you mas…
-
Unable to select parameters in a Manage Job SetWe want to create the Job set and with job parameters itself so that every time we run the job set, we do not have to fill the parameters again. Can you tell us how we c…
-
Unable to find the SQL joining for Event class and Mapping set in Oracle fusion Project to CostingSummary: Hi, We are unable to find the SQL joining Event class (XLA_EVENT_CLASSES_VL) and Mapping set (XLA_MAPPING_SETS_VL) in Oracle fusion Project to Costing. The inpu…
-
Audit tables for Project Tasks and Sub Tasks in Oracle fusion cloud and policies to enableHi, Are there any Audit tables for Project Tasks and Sub Tasks related in Oracle fusion cloud to create a BI publisher report? I was able to enable the audit policies fo…sarathkumarkondadadi 26 views 0 comments 1 point Started by sarathkumarkondadadi Reporting and Analytics for ERP
-
Online Excel preview to view BIP report outputs instead of downloading the file?When getting a BIP Report output in Excel format, is it possible to preview it online (as in cases with PDF/CSV outputs) rather than having it downloaded to system and o…PrerakKhandelwal 31 views 0 comments 1 point Started by PrerakKhandelwal 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…
-
How to embed logo or image in email body using email bursting querySummary: Need info on Parameter5 of email bursting query can be included with image file or Logo in it. We want company logo to be added along with email body .Please gu…
-
how to pull data from FCCS into Analytics and combine with Fusion Cloud ERP data (Finance)Summary: We would like to have some ideas about how to extract data from FCCS in reports in Analytics and combine with Fusion Cloud ERP data (Finance) Content (please en…Hans Krogstie 15 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
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…
-
SoX BI report for Role and ESS changesHi All, As part of SoX auditing, we are looking for lookback BI reports to identify Role and ESS changes as we find from our analysis that the Audit reports available ou…Sam Mathews-81448 23 views 3 comments 0 points Most recent by Sam Mathews-81448 Reporting and Analytics for ERP
-
need to fetch the timestamp when Invoice status changes to Approved at summary levelSummary: for every invoice, when clicked on 'Validate' it will kick a process in the backend "Validate Invoices" which will change the status of Invoice to Validated nee…Anjali Sidharthan 11 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Need sample query to get Original transaction number from credit memosSummary: Need sample query to get Original transaction number from credit memos Content (please ensure you mask any confidential information): need to know about the bac…MayuriMMote 165 views 3 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Reporting and Analytics for ERP
-
Unable to proceed to create Dataset using webservice in Oracle BIP ReportSummary: Unable to create dataset with Webservice while creating custom BIP report Content (please ensure you mask any confidential information): below are the steps to …SireeshaJaladi 106 views 6 comments 1 point Most recent by Sri Prasanth Reporting and Analytics for ERP
-
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…
-
How to add page break in etext template (Fixed position based) in BIP reportHow to add page break in etext template (Fixed position based) in BIP report? Need to add page break after every 50 rows.Harshitha S Motagi 31 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
Need table name storing reporting period and status after "Finalize Transactions for Tax".We need to retrieve the final reporting status and reporting period in Oracle Fusion tables after running the "Finalize Transactions for Tax Reporting" ESS job. This ESS…Sanender SP 43 views 7 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Assistance Required: Identifying Primary Keys and Table Relationships in Oracle ERP BackendHi Team, We require information on the primary keys and relationships between Oracle ERP backend tables. We are currently retrieving primary key details from the "FND_PR… -
Can't inquire into Invoices in the system using Action Link in OTBISummary: Hi. I'm trying to create OTBI Report that will show outstanding Invoices (Unpaid after Due Date is already Due). I'd like to add Action Link, so user will be ab…Yftach Paschur-Oracle 2 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
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 2 views 1 comment 0 points Most recent by Sunder.Velagala-Oracle Recruiting, Opportunity Marketplace
-
convert period to a number and use in formulaI need to convert the period to a number (e.g. Oct = 1, Nov = 2, etc…) and then use that number in a formula to divide one of the amounts by that number. I was able to c… -
OTBI Report with Payments Disbursements and Invoices with Invoice distributionSummary OTBI Report with Payments Disbursements and Invoices with Invoice distributionContent I am trying to create a report that shows only the invoice expense account …User_2025-02-06-00-15-19-515 736 views 3 comments 0 points Most recent by J Dimond Reporting and Analytics for ERP -
[FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: TimeoutSummary: [FTPProcessor]Delivery to SFTP completed with failure oracle.xdo.delivery.ssh2.SshException: Timeout waiting for response from server. Content (please ensure yo…
-
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…
-
Geeting issue "business unit is out of report range" in Payable to Ledger Reconciliation reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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 14 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management