Reports
Discussion List
-
Comparing 2 different Scenarios in NR using Autotextsummary(Compare)I'm working on a report which compared 2 columns with different scenarios for the same month but different versions. However, the explanation is coming back referencing … -
Rule Data Validation report running for all rules at onceHi team! We know it has Rule Data Validation report running for each rule to check the Source and Driver based for individual rule. Can we know if it can run for all rul…Gary Yip - D. 23 views 3 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Changes made to a record are not reflected in custom report immediatelyHello Team, We created a custom RTF report that shows employee contract information for a client. When we update a DFF value in an employee’s contract, the change doesn’…Irfaan Camaloodeen 45 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
report on pending life eventsSummary: Hi Team, We are looking for report that contains all employees pending life events. Please share inputs Thanks, Pranay Content (please ensure you mask any confi…
-
Calculate flux amount for p&l account by entity in fccs reportsSummary: Hi All, We have a requirement to calculate the flux (current year vs prior year) for P&L account. However it is working for BS account but not for P&L. We also …TanviKini 75 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
SmartView formula 'HsDescription' is not yielding result on the Fusion GL SideSummary: We are using Build Function > HsDescription to show Natural Account Description. However it is not working for us. Does it work on the Fusion Side. Reference : …Wilson Chelakadan 23 views 4 comments 0 points Most recent by Wilson Chelakadan Financial Consolidation and Close -
How to create Custom ESS Job for a Schedule integration from FusionI am trying to create a Custom ESS job in Oracle fusion by creating report for a schedule integration. But not able trigger the integration with the Report. Please let m…Harsha Karanam 21 views 4 comments 0 points Most recent by Harsha Karanam Reporting and Analytics for ERP
-
What are the solution options for Audit Trail for Spend Classification?Summary: We need to have an Audit Trail for Oracle Fusion Cloud Procurement > Spend Classification. Oracle doesn't include the Spend Classification product as part of Ma…
-
Query to get hash codes in case of Fusion APISummary: In max of the REST API for Fusion, we need to pass hash keys like for example in case of Invoice attachment (https://docs.oracle.com/en/cloud/saas/financials/23…sailesh_cloudare 1.5K views 7 comments 1 point Most recent by Ch M Prasad-Oracle Reporting and Analytics for ERP
-
Join between FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFRA.WFTASKHISTORYContent Hi, We are trying to find comments on actions taken by approvers on expense report. We found these 2 tables : FA_FUSION_SOAINFRA.WFCOMMENTS and FA_FUSION_SOAINFR…Bhavik Shah 3.4K views 5 comments 3 points Most recent by N.V. Mehta Reporting and Analytics for ERP -
Sql query or Table for Worksheet Display and Default Worksheet Display assigned to compensation planHi team, Sql query or Table where the information stored for Worksheet Display and Default Worksheet Display assigned to workforce compensation plan in HCM compensation …Opkey PA 614 views 6 comments 0 points Most recent by Sammeta Srividya Reporting and Analytics for HCM
-
Creating Multi sheet in Excel template based on Assignment action codeSummary: We are in need of generating multi sheets in which HIRE/REHIRE records are in one sheet and Assignment changes and Termination records are in different sheet(Wh…KeerthanaBaskaran 1 view 0 comments 0 points Most recent by KeerthanaBaskaran Reporting and Analytics for HCM
-
Query to get Deleted users and rolesSummary Need query to get deleted users and role data from FusionContent Is there any table that will provide us the list of deleted users and roles from Fusion. We were…User_2025-01-30-17-58-41-867 857 views 6 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
How to Find the Pension Scheme Name from the 'Benefits and Pensions' (BnP) Calculation Card in a BIPHello Experts, I am building a BI Publisher report to show employee pension details. I had a requirement, were I need to retrieve the Pension Scheme Name from the employ… -
How to customize the sub template for Termination Report?Summary: How to customize the sub template for Termination Report? Content (required): Hi All, How to customize the sub template for Termination Report? Where I can find…Venkatesan 32 views 5 comments 0 points Most recent by Priyanka Ramesh Reporting and Analytics for HCM
-
BI report scheduled jobs are skipping though the trigger is returning recordsBI report scheduled jobs are skipping though the trigger is returning records. -
We could see some extract sections from bakend for the task Profile Content Section AccessSummary: Hi Team, We are encountering an issue that there are some more sections in UI which we are unable to find functionally and technically where these extra section…
-
Unable to find the table and column in which "Grouped construction in progress" flag at project ExpContent Hi All, I am able to find the "Grouped Construction in Progress" flag at project expenditure level. please find the navigation attached. I'm unable to find the f…
-
Is there a way to dynamically rename split rtf files using PDFZ output?Summary: We have a requirement to rename the individual pdfs that get generated from an .rtf report in BIP. I think I am "close", but I can't seem to get the XML tags co…Abrahamson, John 2 views 1 comment 1 point Most recent by Abrahamson, John Reporting and Analytics for ERP -
How to ensure date columns in BI Publisher Excel output use date filters instead of text filters?Our customer wants to download online versions of reports in Excel format, next they will be applying filters on the table for deeper review and analysis. There are mult…Sayan Jasu 136 views 3 comments 0 points Most recent by Lee Eslick-Huff Reporting and Analytics for ERP
-
How to publish calculated data from PCM_CLC to PCM_REP for reporting purposes?Hello, We are currently working with Oracle EPM – Profitability and Cost Management and would like to gain a better understanding of how the PCM_REP cube is intended to …Hans Villanueva Rojas 23 views 5 comments 0 points Most recent by Hans Villanueva Rojas Profitability and Cost Management
-
FRS- Need to display the output in excel in different tabs for different branch valuesSummary: There is a requirement for an FRS report (Income Statement with Budget). Currently, when a user selects a specific branch (e.g., Deloitte Delhi) in the paramete…
-
How to break down biweekly earnings and deductions into weekly earnings and deductionsSummary: Hi Team, Our payroll is currently biweekly. However, we have a requirement to create a custom report that breaks down biweekly earnings and deductions into week… -
Could not find the table link between Rating Model and Profile section nameSummary: We could not find the table link between Rating Model and Profile section name HRT_PROFILE_TYP_SECTIONS_VL - section names are available in this table HRT_RATIN…
-
Best practice for defining formulas in Profitability (Account members vs pre-calculated KPIs)Hello, In Oracle EPM – Profitability and Cost Management, we currently use formulas defined in the Account dimension, since many of our reports directly consume these me…Hans Villanueva Rojas 24 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Unable to see the Goal Plan Approval status in the Employee Goal Plan OTBI ReportUnable to see the Goal Plan Approval status in the Employee Goal Plan OTBI Report. Only the 'Approved' status is displayed under the 'Approval' Status Column. The Subjec…Chaitanya Sai 54 views 2 comments 1 point Most recent by Simran Bachani Reporting and Analytics for ERP
-
Issue with Drill to Content DisplaySummary: When changing a POV member the Drill to Content links are shifting in a report to incorrect lines. Content (please ensure you mask any confidential information)…
-
Unable to Drill Thought to Source in Narrative reporting Report connect to FCCSummary: We've a basic report created in NR which is connected to FCC as Data source, Although we have enabled the Drill Through to Source option in Grid level and at ce… -
Best practice for using PCM_REP vs PCM_CLC for reportingHello, We are working with Oracle EPM – Profitability and Cost Management and would like to validate the recommended best practices regarding the use of the Calculation …Hans Villanueva Rojas 35 views 2 comments 0 points Most recent by Hans Villanueva Rojas Profitability and Cost Management