Reporting and Analytics
Discussion List
-
Administer Salary Notification template modificationThe approval workflow for administer salary includes - current HRBP-> Second Level Manager -> AROC_COMPENSATION_ROLE EXCEPTION: if the person receiving the salary increa… -
Looking for report listing users and assinged user role with start and end date of role assignmentSummary: Report listing active users and current and past assigned roles Content (please ensure you mask any confidential information): Client is looking for a report th…
-
hwm_timecard_report.timecard_totals - Specification (Oracle Fusion)An Oracle Fusion seeded report for displaying bulk timecard approvals is executing the TimecardApprovalNotificationBulkReport which displays a PDF on screen. The data mo…
-
Join required between exm_expenses and pjc_exp_items_all tablesHow do I join from exm_expenses and pjc_exp_items_all tables in Fusion. Do I need to join through other tables also to get this link? Thanks Scott
-
BICCSummary: Initial synchronization for large tables using BICC Content (please ensure you mask any confidential information): Our implementation involves several large tab…SunilRamankutty 12 views 0 comments 0 points Started by SunilRamankutty Fusion Applications Administration
-
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…Ketan- 52 views 5 comments 0 points Most recent by Velidi Supraja Reporting & Analytics for Fusion Service -
Unable to see and run "Input Tax Gain and Loss Report for Singapore"As per suggestion given on "https://docs.oracle.com/en/cloud/saas/financials/25b/ocuar/input-and-output-tax-gain-loss-reports-for-singapore.html#Frequently-Asked-Questio… -
Which table holds audit data or historic LC Expiration date under supplier master business class...Which table holds audit data or historic LC Expiration date under supplier master business classification as 'POZ_BUS_CLASSIFICATIONS' holds only one row which is curren…
-
What Subject Area is used to create a report for Item Batches and their overall statusWhat Subject Area is used to create a report for Item Batches and their overall status The purpose of the report is to see how many item batches are: Completede/In Progr…
-
Absence workflow approval notificationsTeam, we want to customize and hide attachments from approval workflow notification for absence approval. We want to customize the seeded template to hide the attachment…
-
Is it possible to register BICC Jobs in an ESS Job Set?Is it possible to register BICC Jobs in an ESS Job Set?
-
Difference in Accounts Shown Between Trial Balance Extract Report and SmartViewWe have a doubt regarding the Trial Balance. When we run the Trial Balance Extract Report from the Schedule Processes, the output is missing some accounts. However, when…Mukesh Sirigiri 12 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
Can we club multiple elements into one single line so that the payslip generated is not very long?We have a requirement where in we want the multiple elements (elements and their retros) to get clubbed in one single line along with their contributions summed up too. …Kanak Maheshwari 12 views 3 comments 0 points Most recent by Chai-Oracle Payroll and Global Payroll Interface (GPI)
-
Capture AP MetricsTo accurately capture Accounts Payable clerk metrics in a scenario where any clerk can fix or process any invoice, the 'last updated' field is insufficient for identifyi…
-
How to stop the BIP scheduled reportHi All , Could you please let me know How to stop the BIP Hourly scheduled report. Thanks, NagendraNagendra Chitra-Oracle 15 views 3 comments 0 points Most recent by Pandit Yaashi Reporting & Analytics for Fusion Service
-
SQL Query to get the details of the Roles and its inherited rolesSummary: Hi Fellow Developers, We have a requirement to create a BIP report to fetch the details of the Roles and its inherited roles. I tried using the "ASE_ROLE_VL" bu…Dhilip Kumar P. 1.4K views 13 comments 1 point Most recent by Ashish_Goyal_MPC Applications Security
-
Issue with PO PDF Layout in Oracle FusionWhile customizing the Purchase Order PDF layout in Oracle Fusion, I encountered an issue with the standard data model. When the PO is in "Draft" status, all line details…
-
Can Custom PVO be created on any Table or Query for BICC?Summary: Can Custom PVO be created on any Table or Query for BICC? Content (please ensure you mask any confidential information): If seeded PVOs are not matching to our …Sreeram Tadepalli 265 views 4 comments 0 points Most recent by Sreeram Tadepalli Reporting & Analytics for Fusion Service
-
Ability to view the output of BIP reports run by other users in Scheduled Processes.Hi Team, Is it possible to view the output of BIP reports run by other users from the Scheduled Processes tab without the BI Admin role? I assigned the necessary data se…
-
How Did You Map Natural Accounts to Financial Categories in Oracle Fusion ERP for FDI?Good Day, I've reviewed some related posts but none that directly address my question, so posting below. Here at WellSpan we're implementing Oracle FDI this fall and end…Jared Custer 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle General Ledger & Intercompany -
How do we achieve this calculation to be implemented in FDI/OAC classic Report.Hi Team, There is this caculation requirement in P&L report. Please let me know if anyone has implemented a similar logic for %Calculations in FDI Classic Report. For ex…Rasagna Repaka-Oracle 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Cannot successfully extract metadata using the Out of the box Oracle EPM connector in Oracle FDII have enabled the preview feature EPM Planning and Budgeting Data Export I have successfully created and tested connection to the EPM source. I cannot successfully crea…tismithhuron 21 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
How to fetch FA Approval details with BPM Worklist Task NumberHow to fetch Fa_Mass_Transactions and other FA additions,retirements,adjustment and transfer tables FA Approval details with BPM Worklist Task Number for Mass Transactio…
-
Oracle Fusion Cloud Database Schema Export for AI contextI am looking to get a database schema file in JSON or YAML that shows tables, columns, ideally column descriptions, primary keys, and foreign keys. This is so I can prov…Grant Abbondanza 21 views 1 comment 1 point Most recent by Andrew Townes BI Publisher Learning Center
-
Oracle BIP Report Excel template output displaying Number values as TextHi, We have created the new custom BIP Report with Excel template and when we download the report output into Excel, then all Number values are displaying as text, these…Nagaraju Vandavasi 43 views 5 comments 0 points Most recent by User_26T18 Reporting and Analytics for ERP
-
Assistance Required to Identify Root Cause of Number Format Issue in Custom RTF TemplatesHi Team, We’re experiencing an issue with custom RTF templates where a predefined number format behaves inconsistently—working correctly for some users, but displaying i…Baswanth Kumar Reddy-Oracle 1 view 4 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
how to display the date set in the user preference date format in BIP reportUser has set date format in Oracle fusion "General Preferences: Regional" settings. The requirement is to print the date in excel output as per that setting. The setting…Munish Kumar Mittal-Oracle 23 views 2 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Financial Reporting Oracle Fusion not able to view sum of Balance amountI have created a report in FRS studio, i can view all the data every time. But same report is run by any other user, they can only see left column account details. Accou…
-
Request SQL to Extract All Agent Configuration DetailsHi Team, We would like assistance in building a SQL query that retrieves complete Agent configuration details from the backend tables in Oracle Fusion. Currently, we can…Gulab_Ansari 40 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Unable to add security permissions for HCM seeded report folderWe need to give customized access to seeded HCM report folders in the Reports and Analytics page but unable to edit security permissions for the same. We have copied the…