Reports
Discussion List
-
Industry field for otbi subject aresSummary: Please help in getting industry field for otbi having subject ares: 1.order management-fulfillment lines real time 2.order management-order headers real time 3.… -
Why is per_person_secured_list_v secure view not working on AORs in custom BI Report?Summary: Why is per_person_secured_list_v secure view not working on AORs in custom BI Report? I am running my custom report (containing the per_person_secured_list_v) b…Consultant Ian 4 views 2 comments 0 points Most recent by Consultant Ian 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 171 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 41 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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… -
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 -
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… -
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 20 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 1 view 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 291 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 621 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 157 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… -
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 91 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 22 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 …