Reports
Discussion List
-
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… -
Bursting Report for Line Managers - Future Hire Notifications (No Data Returned)Summary: Hi Community, I'm developing a bursting report in BI Publisher that will notify line managers about employees starting on their hire date. The report should run…Vishal Purohit 5 views 0 comments 0 points Started by Vishal Purohit Reporting and Analytics for HCM -
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.… -
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…usr_a.nv 177 views 19 comments 0 points Most recent by Vasanthakumar Ravi Reporting and Analytics for HCM
-
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…Rob F 39 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 …User_MC37Q 91 views 11 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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 Report Rest API call in OICSummary: Rest API call in OIC to pull a Narrative Reporting Report that opens the file and allows me to read it into an atp database Content (please ensure you mask any …
-
Execute Narrative Report using REST API in OIC and download Excel formatSummary: Hello All, I am able to execute Narrative Report output using pdf format from Postman and OIC, The requirement is to generate report in Excel format. Has anyone…
-
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…
-
XML-23029: (Error) FORG0001: invalid value for cast/constructor ERROR IN BIP REPORTHi All, We are getting below error while running BIP report, while it runs successfully for some orders and gives error for 2-3 orders Can you suggest nay possible solut…
-
How to bring the value from Previous schedule in HCM ExtractTeam, We have scheduled an extract where the Union Name parameter has a default constant value of CUPE. During the first scheduled run, we manually selected NBUPPE. Howe…
-
How to create BI report for checklist task type "Report" which accepts the parameter as AllocatedCheSummary We have requirement that one of the Task performer (which is last task in checklist) wants to review the report with all other task performers input to DFFs and …User_2025-01-30-23-59-27-880 1.7K views 12 comments 1 point Most recent by Riti Malhotra Reporting and Analytics for HCM -
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 7 views 0 comments 0 points Started by Sammeta Srividya Reporting and Analytics for ERP
-
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 9 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…
-
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 235 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 22 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