Reports
Discussion List
-
New Oracle FCC Feature – Migrating FR Snapshot Reports to ReportsHi Community, In the latest Oracle EPM Cloud update, I noticed the new feature that supports migrating Financial Reporting (FR) snapshot reports to the Reports module. T…Soumya Choudhary 33 views 3 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
Image in Email Body of BI bursting query along with static AttachmentSummary Image in Email Body of BI bursting query along with static AttachmentContent Hello All, I have a report that needs to be bursted I have a static attachment in it…AvishekNandi 564 views 5 comments 0 points Most recent by Amit_Ekbote Reporting and Analytics for HCM -
Conditional Formating In OTBISummary: Hi I am trying to apply conditional formatting in OTBI for a particular column(Expiration Dates) which is less than current date should return in red colour cel… -
subject areas Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real timeAs per the business custom requirement OTBI subject areas to be used are Distributed Order Orchestration - Fulfillment Lines Real Time and Shipping Real time which is cc…Shahid Qureshi 01 16 views 0 comments 0 points Started by Shahid Qureshi 01 Reporting and Analytics for ERP -
HCM Extract failed with "ORA-01426: numeric overflow"Summary: HCM Extract failed with "ORA-01426: numeric overflow" Content (please ensure you mask any confidential information): We are using the PER_EXT_SEC_ASSIGNMENT_NOW… -
How to read csv from content server?Summary: Content (please ensure you mask any confidential information): I need to show in report results from csv uploaded in content server, what is the table to query?…Stefano_Mazzocca 5 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
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…theachiever_07 537 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 43 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 251 views 5 comments 0 points Most recent by AnushaDB-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 256 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 321 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 50 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 41 views 4 comments 0 points Most recent by Muzammil_789 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 311 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 11 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 120 views 16 comments 6 points Most recent by Jyothi Pasupuleti 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 1.1K 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 24 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 2 views 1 comment 0 points Most recent by Filipe Geissler Reporting and Analytics for ERP -
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 …