Reports
Discussion List
-
Modify New Hire State Report Template for USSummary: We have a requirement to include few extra columns in the delivered New Hire State Report for US. I would like to understand if we are allowed to that? Previous… -
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 41 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 72 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 21 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.4K 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.3K 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 531 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 756 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… -
Required Table or SQL query to get Phase details for the ORC moduleSummary: Hi, Required Table or SQL query to get Phase details uder the task: Candidate Selection Process Configuration for the ORC module Content (please ensure you mask…Opkey PA 52 views 1 comment 0 points Most recent by Poojitha Siddamsetty - Support-Oracle Recruiting, Opportunity Marketplace
-
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 31 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 1 view 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 51 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 21 views 5 comments 0 points Most recent by Hans Villanueva Rojas Profitability and Cost Management
-
OTBI Performance and Timeout Errors For End UsersHi all, I'm wondering if anyone has any suggestions on how to work out some issues with some analyses we're using for a dashboard our business uses. We've built several …
-
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 11 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 51 views 2 comments 1 point Most recent by Simran Bachani Reporting and Analytics for ERP