Reports
Discussion List
-
What is the recommended way to extract item data in bulk from Fusion Cloud(PDH) by External SystemSummary: What is the recommended way for an external system to extract item data in bulk from Oracle Fusion Product Data Hub (PDH) to be used with OIC. Content (please e… -
OTBI Report to fetch List of Line ManagersSummary: OTBI Report to fetch a List of Line Managers who have at least one direct report and the direct reports(Employees) should be Salaried. Content (required): For t…Thulasi Ram 481 views 7 comments 0 points Most recent by Aditi Sehgal Reporting and Analytics for HCM -
26.04 Update Feature Audit Changes to Documents and Report ArtifactsSummary: New 26.04 Feature Audit Changes to Documents and Report Artifacts - the audit log does not provide the name of report for which content was modified. Is there s…Lauren Lee 44 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Learning Table Details to fetch Learning Access Group related fields along with access group membersSummary: I have requirement create BIP report to fetch all learning item along with access group related details like Access Group selection method, Access group Run as,…Kamini Kaushik-Oracle 255 views 5 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM -
oracle cloud hcm bi publisher absences error handling reportHas someone written or found documentation for the steps to write an oracle cloud hcm bi publisher absences error handling report (or similar) that writes error messages… -
Oracle Fusion Cloud – SQL to Extract Report-Level Permissions for All Reports (BI Publisher, OTBI)Hello Experts, We are working in Oracle Fusion Cloud (SaaS) and need to extract report-level security/permissions for all available reports in the system. Scope includes…Noorul Ariff1986 84 views 2 comments 1 point Most recent by Jehosheba Amruthaluri Reporting and Analytics for ERP -
Need to make dynamic file name in BIP reportWe have a requirement to place the BIP report to SFTP server , file name should be dynamic as 'Filename_(sysdate-15)_(sysdate-3)'. I tried to make the filename as Filena…Anjali_Kumari4121 216 views 5 comments 0 points Most recent by CharanBochker Reporting and Analytics for HCM -
FCCS custom report to dynamically pull data where an Entity has ICP transactions with itselfIs there a way to create a custom report in FCCS to dynamically pull all such lines where an Entity has ICP transactions with itself ( Intracompany transactions)? We cur…Batul Rangwala 42 views 4 comments 0 points Most recent by GMohan-Oracle Financial Consolidation and Close -
Book Prompts shared across different cubesSummary: Is it possible to link Prompts from Reports within a Book that are within different cubes? Content (please ensure you mask any confidential information): I have… -
Approver Name of a transaction with OTBISummary: Create an OTBI report with Transaction details, the initiator and approver Content (please ensure you mask any confidential information): Hello experts, is it p… -
Bi report changes are not reflecting on ORC offer preview pageSummary: Bi report details with recent changes are not reflecting on candidate's application preview offer Page. Content (please ensure you mask any confidential informa…Muzammil_789 34 views 4 comments 0 points Most recent by Muzammil_789 Reporting and Analytics for HCM -
User Login Activity QuerySummary: We have a contractor and would like to measure his level of effort within our company. Is there an existing query or report that shows how many times a specific…usr_a.nv 62 views 20 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Is View Display Error / Timeout issue related to missing BI Admin role?Summary: Multiple user encounter View Display Error when running Dashboard Report. Most of the reports results with errror. We confirm that they have access in the repor… -
Assignment Changes on Employment HistoryContent Our organization is working to transition to utilizing the Quick Actions verse Person Management. One feature we use is the “view history” and then "export" on t…Kayla Malecki 310 views 14 comments 3 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI Conditionl FormatingI’m facing an issue while building a formula in OTBI (Subject Area: General Ledger - Journals Real Time). Requirement: I want to calculate a value that combines: Journal…Abdulrahman Mostafa 12 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
Unable to see triangle after zooming in on a parent memberSummary: I work at Expedia and am trying to run TRCS tax reports from our Library folder. I attempted to expand parent members to view their child members by following t… -
Bursting sending one consolidated email instead of multiple emailsSummary: Needs to send one email to Manager with consolidated notifications of all the employees instead of sending one notification for each employees. Content (please … -
Infolet Section says Refresh to Load after LoginSummary Infolet Section does not load Infolets by DefaultContent We are on 19C and on news feed. I have enabled HCM infolets and infact made couple of infolets. But What…Prateek Parasar - GTUK, ACE Pro 117 views 16 comments 6 points Most recent by User_ORRJ4 Reporting and Analytics for HCM -
BI Publisher - Bursting - Email Delivery Channel - HTML Message BodySummary BI Publisher - Bursting - Email Delivery Channel - HTML Message BodyContent All, Able to burst BI Publisher Reports and deliver them via email using: Email PARAM…User_2025-02-05-22-13-16-277 959 views 7 comments 3 points Most recent by Aditya Jena Reporting and Analytics for HCM -
How to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcmSummary: Hi Team I am looking for how to get data in oracle fusion hcm country vise which HCM offering they using in oracle fusion hcm Could you help me on this Content …Anup Karmankar 22 views 3 comments 0 points Most recent by Anup Karmankar Reporting and Analytics for HCM -
Help with query to pull Spoke System Items for a given itemHi, I need to create a query to pull all "Spoke System" linked to a item. A have tried the query below, however if won't work because the source_system_id on EGP_ITEM_RE…Filipe Geissler 1 view 1 comment 0 points Most recent by Filipe Geissler Reporting and Analytics for ERP -
Reports to get Service Usage in fusion HCMWe need reports for below: 1) Anonymized Authorized User Names by Service Details 2) Authorized User Names by Service 3) Authorized User Privileges by Service 4) Authori… -
Illinois "Equal Pay Registration Certificate" reporting requirementSummary: Any suggestions or experience on how companies can best extract this data to meet this state requirement? Content (required): Good afternoon! Has anyone had to … -
Customisation of Expense Approval Workflow Notification using BIPSummary Issues persist even while following expense config document step by stepContent Hi,We are trying to implement customized expense approval workflow notifications …Mohak Kirtane 153 views 3 comments 1 point Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP -
Customize Payroll Activity Report and/or Periodic Payroll Activity ReportQuestion: What are best practices for customizing the seeded, legacy Payroll Activity Report and/or newest Periodic Payroll Activity Report? How can we add in assignment… -
HCM Custom Extract Guide for Payroll ReportsSummary Sample extract with modularized UEs for customized payroll reportsContent Change Notes Date Version Change Reference 16-May-2018 v1 First Version 18-Sep-2018 v1.…Jianzhong Tian 1.6K views 5 comments 7 points Most recent by Tia Bly Reporting and Analytics for HCM -
Dynamic scaling in reportsSummary: We have customers who would like to be able to choose the scaling in reports at runtime (as there are different requirements for different purposes). Fiscally t…Tjeerd Huisman 31 views 4 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close