Reports
Discussion List
-
Transaction Console Job Requisition approval chain reportSummary: The user can't access the transaction console and through administrative tasks in BPM, they can see only their job requisition. We need a report to see the appr… -
25D - Text Object "Contains HTML/Javascript/CSS Markup" Option remvoedHello, We've recently upgraded our DEV environment to 25D. We're now finding that the option to include text that contains HTML has been removed. Was this documented any… -
How to burst and deliver a single CSV file to SFTP when no column has a common value for all recordsHi team, I am working on an Oracle HCM Cloud BI Publisher report where the requirement is to: Generate one CSV file Containing all records Deliver the file to SFTP locat…Sammeta Srividya 4 views 0 comments 0 points Started by Sammeta Srividya Reporting and Analytics for ERP
-
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 … -
FCCS: Is it possible to NOT display Forms under the library in Reports or limit accessSummary: Content (please ensure you mask any confidential information): Hi all As per attached, we are seeing Forms displaying under the library part of the new REPORTS.…NKW 31 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
narrative reporting custom header new lineSummary: Narrative reporting / custom header in a column - anyway to force new line in text? Content (please ensure you mask any confidential information): Narrative rep…
-
Narrative Reporting Two Questions - Heading Number by Report AND Bursting versus Report PackageSummary: Dynamic report header numbering in a 'container' AND best way to run various combinations of a list of reports by entity - where some entities do not run all en…
-
Dashboards in EPRCSWe are trying to create a Waterfall Bridge chart in EPRCS to show step-by-step variance (increase/decrease contributing to the final total). However, with the available …
-
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…
-
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… -
How to bind effective date parameter of HCM Extract to BIP Report's parameter and load HDL ?Summary: How to bind effective date parameter of HCM Extract to BIP Report's parameter and load the HDL file generated by BIP Report ? Content (please ensure you mask an…
-
Oracle BI Report bursting throwing errorHi Team, I created 5 reports and all 5 are scheduled in Prod. Only 1 report is getting failed while bursting. Getting below error. Detail Message: ::JOB_WAIT_TIME_SECOND…VijayRajalbandi 7 views 0 comments 0 points Started by VijayRajalbandi Reporting and Analytics for HCM
-
Lease accounting LDR has negative amountsSummary: Lease accounting LDR negative amounts Content (please ensure you mask any confidential information): LDR continues to display negative “Reclassified Long‑Term L…Wilfried121 5 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
BIP Scheduled report with date appended to filename.Summary: Hi, We want the BIP scheduled output Excel file to include the date in its filename. In the extract process, we can use %d%m%y in the output name to automatical…
-
Report to monitor payables invoice rejections due to invalid approval rulesSummary: Any seeded report to monitor payables invoice rejections rejected due to invalid approval rules. These kind of rejections can be viewed only in Transaction cons…
-
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 230 views 7 comments 0 points Most recent by Youssef_Antoury Reporting and Analytics for ERP -
Why the printing from the fusion is different from a laptop to another ?!Summary: I've tried to print a report from the fusion (its layout is made by the word in a RTF format) and it's been printed correctly on my laptop but the other laptops…
-
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 608 views 9 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Unable to find PVOs in BICCContent Hello, We need PVOs of following tables in BICC but we couldn't find these in Lineage Sheet. If anyone has any idea on how to get those or any workaround would r…Vinay Gharge 159 views 8 comments 2 points Most recent by User_0GZ7K Reporting and Analytics for ERP -
How to Link Payroll Details to Time Entry Data?Summary: Hii team, In the time entry details we are able to see the payroll linked data, like from frontend I can see this details I need to fetch this Earned date, valu…Vishal Purohit 21 views 5 comments 0 points Most recent by Vishal Purohit Reporting and Analytics for HCM -
Query optimization for HCM audit report with UNION ALL + UNPIVOT - need hints/index strategySummary: My audit trail query (HCM objects with UNION ALL for 30+ audit tables) was taking 12 minutes with left join on tables per_all_assignments_m and per_all_people_f…Vishal Purohit 9 views 0 comments 0 points Started by Vishal Purohit Reporting and Analytics for HCM
-
How to hide Schedule option from BI Reports for ManagersSummary: We created a one of the report and provided folder read access to manager role, however - customer wanted to restrict the managers to stop schedule this report.…
-
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 74 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 …
-
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 29 views 3 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for HCM