Reporting and Analytics
Discussion List
-
fnd_sessions has rows with last_connect that is after the employee last logged inSummary: We are trying to build a report to show who logged in that day. If a person logged in multiple times, we need to report the last time user logged in. Person 464… -
In case of SCFO context in AR invoice, how to get fullfillment line id?In oracle fusion, I want an sql query to find fullfillment line id in case of Supply Chain Financial Orchestration (SCFO). For DOO we are getting this from interface_lin…ManuYal 15 views 2 comments 0 points Most recent by Victor Martin Supply Chain Planning and Collaboration
-
Feasibility of Using PDF with Embedded Tags Instead of RTF TemplateCan we modify the PDF document to include tags/tokens such as P_SIGNER within the PDF itself and upload it in place of the existing RTF templateAprajita Gokhale 9 views 0 comments 0 points Started by Aprajita Gokhale Reporting and Analytics for ERP
-
how to customize FusionApproveRejectLinksHi, anyone knows how to customize FusionApproveRejectLinks for the approvals? Thanks
-
OTBI - How to link Learning Management & Learning Records Real TimeHello everyone, I am currently working on an OTBI analysis for specific Learning Items. Most of the required data is available in the Workforce Learning – Learning Manag…
-
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…
-
BICCSummary: Initial synchronization for large tables using BICC Content (please ensure you mask any confidential information): Our implementation involves several large tab…SunilRamankutty 41 views 2 comments 0 points Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
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…
-
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
-
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 35 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle General Ledger & Intercompany
-
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 26 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.7K 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 343 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 18 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 20 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 40 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 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 61 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 4 views 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 46 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 49 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service