Reports
Discussion List
-
How can I edit a data source in Planning?Summary: I have migrated reports from Narrative Reporting to Planning, in version 26.07, and the reports were pointing to a data source in Narrative Reporting that have … -
OTBI report - functional managersSummary: I would like to create a report that could give me a list of functional managers by employee - OTBI reports. Content (please ensure you mask any confidential in…Jacqueline GRANDIN 21 views 2 comments 0 points Most recent by User_MKTG2 Reporting and Analytics for HCM -
Oracle hcm cloud seeded reports what is the list of reports and their locationHello, I would like to know please, what is the list of Oracle hcm cloud seeded reports ? and where they are located ? for example : employee contact ,employee address ,…Revital Mefano 864 views 11 comments 0 points Most recent by Raj Battiwala Reporting and Analytics for HCM -
Is there a report or table which store history or audit on the data access sets granted and revokedSummary: Is there a report or table which store history or audit on the data access sets granted and revoked. We cannot see the any data access set once they are revoked… -
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… -
Annual salaries for current and terminated employees in one reportIs it possible to create a report with just a list current and terminated employees and their annual salaries?Ulitka 104 views 15 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Generate .ZIP file from BI Publisher ReportSummary Need to create a BI publisher Report that can output .zip file to be run in HDLContent Hello, We want to create a BI publisher report that can provide us a .zip … -
Financial Reporting Center - Define Tags (GL_FRC_USER_ACCESS_REPORT_TAGS)Summary: Is anyone using the GL_FRC_USER_ACCESS_REPORT_TAGS table in a BI Publisher report? How are tags defined? https://docs.oracle.com/en/cloud/saas/financials/26c/oc…Meredith Bickell 1 view 0 comments 0 points Started by Meredith Bickell Reporting and Analytics for ERP -
Need sql Query to fetch the Job Applicants in Draft StatusSummary: We have a Requirement to build a BIP Report for fetching the Job Applicants in Draft Status. Can anybody please share the sql query for this requirement. Conten…Milan_Mohanty 24 views 2 comments 0 points Most recent by Milan_Mohanty Reporting and Analytics for HCM -
Web Forms opened in SmartView IssueSummary: Web Forms opened in SmartView is showing Zero values in Blank Formula Rows and Columns. Anyone has experience the same? Content (please ensure you mask any conf…Kenneth John Asper-Oracle 144 views 7 comments 1 point Most recent by Niranjan Bodas Financial Consolidation and Close -
Intercompany Report displaying value in Partner Amount instead of Entity Amount columnSummary: I have a question regarding out of the box IC report: Lets say there is a transaction recorded by Entity 54001 with a trading partner has an amount of 2,167. Ho…Saraiya Daisy Dhanesh 31 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
enable gen AISummary: enable generate AI in narrative - any additional costs? Content (please ensure you mask any confidential information): Assuming the client has enterprise perfor… -
How to add dynamic logo to an OTBI analysis ?Summary OTBI Analysis & Dynamic LogoContent Good People, Is there anyway we can add dynamic logo to an OTBI Analysis ? Thanks, SoumyaSoumya Prakash Parhi 124 views 7 comments 1 point Most recent by Tiw.Jyotsna-Oracle Reporting and Analytics for ERP
-
Facing performance issue with a query on gl_periods and per_calendar_events tables.On Fusion ERP I have a BIP report with complex query which involvers among others GL_PERIODS and PER_CALENDAR_EVENTS tables. Report parameters are GL Period From and GL …N.V. Mehta 11 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for ERP -
AI Agent Audit ReportSummary: Two different BI Publisher reports to track AI Agent usage by end-users and administrators. Summary Audit Report that audits a completed conversation from a pub…Race Schreimann-Oracle 543 views 10 comments 3 points Most recent by Race Schreimann-Oracle AI for Fusion Applications -
How to get the only Error message from FAULT_PAYLOAD columnSummary How to get the only Error message from FAULT_PAYLOAD columnContent Hi Experts, Good Day!! We are trying to pull the failed transaction details from transaction c…Charan Kollipara 111 views 6 comments 0 points Most recent by ViswanadhK Reporting and Analytics for HCM -
BPM Worklist ReportSummary Help on creating BPM Worklist ReportContent Hi, We currently have several requests regarding the BPM Worklist Report in Fusion HCM. Do you have any idea on how t…User_2025-01-29-01-38-21-058 256 views 9 comments 0 points Most recent by ViswanadhK Reporting and Analytics for HCM -
Clarification on Oracle AI Vector Search support within Fusion OTBI, FR and BI Publisher reportsWe are seeking clarification on the use of Oracle AI Vector Search (Vector Database capabilities) within Oracle Fusion reporting solutions. Specifically, we would like t…PrudhviRaju Addagada 2 views 1 comment 0 points Most recent by Srivanth_A Reporting and Analytics for ERP -
Can we split data into different sheet in CSV output of a BIP report ??I would like to enquire about the Oracle BIP Report CSV output data limit. Do we have a 2 million rows record cap for BIP CSV scheduled report? Can we split data into di…shauli.mukherjee 12 views 2 comments 0 points Most recent by Abhishek Premchandra BI Publisher Learning Center -
Probation Confirmation LetterSummary: We have a Requirement to send the Probation Confirmation using Oracle BIP Bursting . Can anybody share the Bursting Logic to call the IN .rtf Template or the US…Milan_Mohanty 38 views 3 comments 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", neSummary: Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", need to join the subject area to fetch data as there is no com…Prasad Tummalapalli 2 views 0 comments 0 points Started by Prasad Tummalapalli Reporting and Analytics for ERP -
Cross Subject Area receivables moduleSummary: Cross subject area "Receivables - Transactions Real Time" and "Receivables - Customer Real Time", need to join the subject area to fetch data as there is no com…Prasad Tummalapalli 1 view 0 comments 0 points Started by Prasad Tummalapalli Reporting and Analytics for HCM -
Creating a quick analysis for employee terminate information with legal employerI am creating a quick analysis for a bulk worker termination but when adding the legal employer name column that is needed in the criteria, it breaks the results. When I…Damien Curtis 14 views 6 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
Guidance Required – Executing Dynamic SQL in Oracle BI Publisher ReportSummary: We have a requirement where business users will maintain extract configurations through a custom Oracle VBCS screen. For each vendor, the users will configure d…
-
Is there any way to identify the last usage date of a role assigned to a user in Oracle Fusion CloudHi Team, We have a requirement to identify the last usage date of a specific role assigned to a user in Oracle Fusion Cloud SaaS. We are looking for a way to determine: …Vignesh_Rajasekaran-Oracle 12 views 0 comments 1 point Started by Vignesh_Rajasekaran-Oracle Reporting and Analytics for ERP -
Reporting package not being refreshed properlyHi All, We are experiencing an issue while refreshing a Narrative Reporting (NR) reporting package. Upon refresh, not all doclets are updated consistently—only a subset … -
How to get the the latest balance from HCM ExtractHi, I have created a balance group HCM extract to retrieve the custom balance value. I have selected the UE - PAY_INTERFACE_PAYROLL_REL_UE and selected the process type … -
How to map new custom data model and Separate Remittance Advice template to PPR process.Summary: I have created new custom data model & template and added it in Disbursement Separate Remittance Advice Formats report. But when run the payrun, still output is… -
Performance of conditional suppressionSummary: Is there any guidance for best practise on use of conditional suppression Content (please ensure you mask any confidential information): Is there any guidance f…