Reports
Discussion List
-
bi query to extract journal approval rules, Invoice Apprvoal Rules and Project Approval RulesSummary: Hi All, I am looking for the tables or query to extract the journal approval rules, Invoice Approval Rules and Project Approval Rules from Oracle ERP Cloud thro…Chandra MAdasi 32 views 8 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
The Program Name is not populating in the ERP Project Costing module.Summary: The Program Name exists upstream but did not flow into the Project Costing module. As a result, costs are missing from the Project Cost by Transaction report. C… -
Cash Flow Roll Forward with YTD LoadsSummary: The client wants to load year-to-date (YTD) trial balance only in quarter-end months (Mar/Jun/Sep/Dec). They also plan to provide a movement-level split of the …Saraiya Daisy Dhanesh 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to disable the Open option on Reports & Analytics Catalog?Summary: How to disable the Open option on Reports & Analytics Catalog? Among the various reports offered out-of-the-box by the Oracle Fusion modules, some of them can b…User_2025-02-11-06-12-35-024 911 views 12 comments 0 points Most recent by SurendraPB Reporting and Analytics for ERP -
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…
-
Create Report from Tags and Experience sections in ConnectionsSummary: Content (required): Hello Experts, Is it possible to create a custom report for the fields in the Connections, more specifically for Tags, Experiences, Interest… -
Job Requisition Approval Workflow Template – Approval Comments Not VisibleSummary: Hi Oracle Community, I am working on the seeded Job Requisition Approval Workflow Notification Template in Oracle Fusion HCM and have run into an issue with app…Vishal Purohit 21 views 0 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
Dynamically update formulaIf I am using a formula in a column referencing Row 1. For example in Column B i am using [1]/100. Now row 1 is enabled for zoom, so i want when it is zoomed the corresp…
-
Drill through to Invoice levelSummary: Drill through from Oracle EPBCS to source Fusion ERP at invoice level not GL Balances. Content (please ensure you mask any confidential information): Is there a…
-
Bankwide budget extract in EPBCSWe have an inquiry regarding the bankwide budget extract in EPBCS. This extract is intended for use in the OPEX Dashboard, where it will help compare actuals versus budg…
-
Conditional suppression based on suppression of another rowSummary: Cannot conditional suppress row based on suppression of another row, when suppression of the other row is because of No Data. Content (please ensure you mask an…
-
How to bind effective date parameter of HCM Extract to BIP Report's parameter and load HDL ?Summary: How to bind effective date parameter of HCM Extract to BIP Report's parameter and load the HDL file generated by BIP Report ? Content (please ensure you mask an…
-
How to Burst Email and FTP Output Delivery from the Same Schedule in BIP Report?I have a data model and a report in BIP, and there is a requirement to distribute the report output both by email to HR representatives and also to store the output on a…JayeshKori-Oracle 81 views 3 comments 4 points Most recent by Rashmitkumar Dodiya-Oracle BI Publisher Learning Center
-
Oracle Fusion ERP Cloud Receivables Transactions Integration with EPM CloudNeed: Steps or processes to be followed to integrate Receivables Transactions from Oracle Fusion ERP Cloud. Summary: We have a requirement in which we want to get Fusion… -
Report Query to Determine Subject Area UsageSummary: With the 26A release, the Workforce Management - Vacancy Real Time subject area is being discontinued. Is there a query that can be run in OTBI that will provid…Nick Henderson 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
How do we get the price strategy association start date and end dateSummary: I am writing a report to fetch the pricing strategy, price list along with the method of pricing like Customer Number or Bill to Number. I am unable to find the…
-
Report to monitor payables invoice rejections due to invalid approval rulesSummary: Any seeded report to monitor payables invoice rejections rejected due to invalid approval rules. These kind of rejections can be viewed only in Transaction cons…Rajesh_BR 1 view 3 comments 0 points Most recent by Pradeep Kumar Reddy V Reporting and Analytics for ERP
-
Capitalized Interest Transactions are not populating in the Project Costing Transaction ReportSummary: Capitalized interest transactions for these projects are visible in the Generate Capitalized Interest Transactions report, but the same projects do not appear i…
-
History of management reports when it run adhocSummary: We want to see history of management reports in FCC when it run adhoc..Verified it is not recorded in audit log or jobs.What Parameter passed.Neha Talati-267028 1 view 1 comment 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
How can we track which users have executed an Oracle Fusion BI Publisher report from the catalogSummary: We want see the Report details who ran from catalog. is there any tables which stores that info to extract. Content (please ensure you mask any confidential inf…Sreekanth Kandula 31 views 7 comments 0 points Most recent by Sreekanth Kandula Reporting and Analytics for HCM
-
Lease Accounting - CWB + Test Scripts + Business Process ModelSummary: Lease Accounting - CWB + Test Script + Process Flow Content (required): We are looking at replacing our legacy system for Lease with Oracle Lease Accounting, an… -
Query to fetch Cost Center Details which are not mapped at Department LevelSummary: i need a query to fetch all cost center which are not mapped to the department. If anyone have SQL query please help me. Version (include the version you are us…
-
Changes to expense approval template does not reflect after 24hoursHi all, We have a requirement to modify expense approval template to add the account number to show up on the email notifications. To achieve this, I have modified the '…
-
Hide column/s of an FRS ReportSummary: When FRS Report parameters are entered and report is run, I need column/s which give all blank values to be hidden. How can this be done? Content (please ensure…
-
Intercompany Elimination before the Data load in FCCSHello Everyone Is it possible to use an intercompany matching module in Oracle FCCS where transactions are matched first and then entity loads the ICP partner data in ER…Bhavishya Edula 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS – Rounding to Millions Causing Parent-Level DifferencesHi, We have a requirement to report values in millions with rounding. We implemented this by creating a member named as "DS Millions" in the data source dimension and de…JyotiSharma 41 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
BIP report Pivot filter not functioning as expectedSummary: Running an online layout for a pivot date from a data model doesn't properly filter null dates Content (please ensure you mask any confidential information): Fo…Marko Puskac 12 views 2 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
FCCS: Change Signage of Account Types according to Source SystemSummary: We would like to know about the Impacts/Challenges of applying the customize signage for Asset/Liabilities/Equity/Revenue/Expense which aligned with ERP signage…Karan Varshney 211 views 7 comments 0 points Most recent by Joost Mellegers Financial Consolidation and Close
-
PerformanceGoalRespApprovalNotificationReport not returning data after passing the transaction_idHi Team, Experiencing issues with the seeded notification (PerformanceGoalRespApprovalNotificationReport) triggered for manager approval when a worker adds, updates, or …Shivani Nakade 11 views 0 comments 0 points Most recent by Shivani Nakade Reporting and Analytics for HCM