Reports
Discussion List
-
Create ICP Break report in Narrative ReportingHi Team, How can we create a ICP break report in NR to showcase the plug accounts and IC accounts along with mismatch values for the Entity and Partner, user does not wa…TejasVaidya03 21 views 7 comments 0 points Most recent by Anand Thota Financial Consolidation and Close -
How to add custom archival data to the GTN report?Summary: A customer needs to add custom deductions to the Gross to Net summary report, just as they can in the Payslip, which include this feature. The XML does not cont…
-
FDI attributes without Start & End date includedWhen creating reports in FDI, we find attributes that are present in the subject area but the attributes Effective Start Date and Effective End Date (and sometimes other…
-
FDI - Custom Security Context LOV returns row-level values instead of value-based valuesHi, We are currently implementing the security configuration in Oracle Fusion Data Intelligence (FDI). In addition to the 5 standard Security Contexts available, we need… -
Download Excel template BIP Report using SOAP Web ServicesSummary: We are currently using the following two web services to schedule and download BIP reports: soapWsdlUrlSchedule: https://{instance-name}.oraclecloud.com/xmlpser… -
EPM Book down loads/runtime increasing recentlySummary: we are observing huge rise in time when running/extracting reports from EPM books. The report book which was downloading in 1-2 minutes is not taking around 20 …Divya_Masoodi 52 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Is there a report that will show me what app caused a user to get locked in OCISWe have an admin ID that is getting locked every so often, and we are having issues finding the cause of it. Is there a report in OCIS/IDCS that would help us identify t…
-
Need inputs for 401k Contribution ReportSummary: Need inputs for 401k Contribution Report Content (required): Hi Team Greetings! This is about getting the details for 401k contributions report including deferr… -
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 21 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 533 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 11 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 1 view 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
OTBI analysis report output does not show the values selected in the prompts when scheduledHi, I currently have the prompt fields as a Static Text element in the results. Running the report directly shows the selected prompt values normally, but does not appea… -
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…
-
Working report stopped and throwing an error ORA-01722: invalid numberSummary: I was able to use a custom BI Report a week ago. But it stopped working and throwing an error "ORA-01722: invalid number" when running. I am not sure what is ca…
-
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 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 252 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…