Reports
Discussion List
-
Assignment Category was Limbo (PRN) for entire yearSummary: I have a requirement to identify employees with an Assignment Category of Limbo (PRN) throughout the entire year 2025 or until their termination date in 2025. I… -
Address Change Notification Not Reflecting the Changes in the NotificationSummary: New fields have been added to the Address Change Report (Report Name: PersonalInformation_AddressReport). While the changes are being pulled into the report cor…Balavignesh A 73 views 15 comments 0 points Most recent by Megan Pulford Reporting and Analytics for HCM
-
How to Obtain History of Last Updated Date and Owner for ReportsSummary: How to Obtain History of Last Updated Date and Owner for Reports Content (please ensure you mask any confidential information): Is there a way to obtain a list …
-
OTBI Analysis Error: Subquery contains too many values for the IN predicate.Summary State: HY000. Code: 42029. [nQSError: 42029] Subquery contains too many values for the IN predicate. (HY000)Content Hi, I have a OTBI report which needs to pull … -
How to get ESS job schedule end date for all scheduled ESS JobsSummary: How to get ESS job schedule end date for all scheduled ESS Jobs Content (please ensure you mask any confidential information): Hi Team, Greetings! We have multi…Parag Hiremath 592 views 7 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Explain Differences in Payroll Balance Core Assignment and Core Relationship RunsSummary: When reporting using Subject Area Payroll - Payroll Balances Real Time, could an expert please explain the differences in the following Base Dimensions: Core As…
-
Currency Conversion in OTBI report from Procurement - Procure to Pay Real time subject areaSummary: We have a custom OTBI report created from Procurement - Procure to Pay Real time subject area. The report currently shows all open POs in different currencies. …Pranita S 98 views 3 comments 0 points Most recent by Judith COLLONGUES Reporting and Analytics for ERP -
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…MikeW 1.5K views 11 comments 0 points Most recent by Alok Suraj-Oracle Reporting and Analytics for HCM
-
Error while downloading BIP Report in Excel FormatSummary: We are getting error while run a BIP report and try to export in Excel and other formats. When we do the same in Interactive mode no error is coming IO Exceptio…Sanglap Kundu 21 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM
-
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. 24 views 3 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
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 8 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…
-
Security for OTBI Subject Area "Projects - Labor Distribution Costs Analysis Real Time"Summary: We need to expose OTBI queries written against the subject area "Projects - Labor Distribution Costs Analysis Real Time" to a larger population. Right now, it i…
-
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 22 views 4 comments 0 points Most recent by Wilson Chelakadan Financial Consolidation and Close -
Getting 401 Unauthorized error code while calling an OIC integration from BIP reportSummary: I have created an app-driven integration that has - trigger REST connection with security policy: OAuth 2.0 - the REST trigger configures multiple resources - m…Nermin Khaled-Oracle 197 views 6 comments 0 points Most recent by ThiyaguRJ Reporting and Analytics for ERP -
Unable to pull E-Signature details from RequisitionSummary: I am looking to extract E-signature information, specifically the flow name, signature date and time, and the signer’s identity. My current approach joins IRC_A…Sandeep Aravindakshan 3 views 0 comments 0 points Started by Sandeep Aravindakshan Reporting and Analytics for HCM
-
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
-
FCCS Cash Flow Mapping Issue: GL Accounts with Multiple Movement TypesWe load year‑to‑date (YTD) trial balance data into FCCS for consolidation purposes, and we are now looking into implementing cash flow reporting in FCCS. However, we hav… -
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.3K views 7 comments 1 point Most recent by Ch M Prasad-Oracle Reporting and Analytics for ERP
-
Gen Ai Comments/Highlights issueWe are facing an issue with the GenAI functionality in EPRCS, where we are unable to generate comparative variance analysis narratives across multiple entities and accou…
-
Deleting multiple reports at onceSummary: How can you delete multiple reports in one go? Content (required): Hi all, Our reports (approx 50) are put in a folder structure. As we want to delete all of th…
-
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.2K views 5 comments 3 points Most recent by N.V. Mehta Reporting and Analytics for ERP -
Unable to open the DM after UnachiveSummary: We successfully Unarchive Data model but unable to Open the Data Model Content (required): We Archive the Data Model from one instance and successfully Unarchiv…
-
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 441 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 Started by KeerthanaBaskaran Reporting and Analytics for HCM