Reports
Discussion List
-
Suppression on FCCS ReportsSummary: We migrated our reports and now suppression is not working the same. We have a lot of variance formula built into our reports. For example taking descendants of…Casey Kempel 11 views 1 comment 0 points Most recent by Anand Thota Financial Consolidation and Close -
please help me to fetch report for Specialization with individual activity status in Learn ModuleI want to pull the details of specialization, including status, along with individual activities and their status | SQL query to get specialization details , module name…Nagarani M 15 views 0 comments 0 points Started by Nagarani M Reporting and Analytics for Taleo Learn -
While loading worker dat file, getting error the error for PersonLegislativeDataSummary: While loading the worker dat file getting the below error for PersonLegislativeData component You can't update this record because the SourceSystemId {SRC_SYSTE…Gali Sujana 83 views 2 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Need SQL query to get Set General PreferencesSummary: We need a query for the setup Set General Preferences as shown in the UI. We are unable to get Date format, Time format and Time zone as shown in UI page. For e…Opkey PA 51 views 3 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
Dependents not displaying on reportSummary: I had a detailed Benefits Enrollment report that had the employee's information and dependent information displaying on the same report. I started with Benefits… -
Position Hierarchy queryHi, I need a small query that returns parent position name and code of positions. Is it possible for you to share the query about it? Regards -
Bursting Definition Zip Email Attachment functionality not available in Financial Close and ConsolidBursting Definition Zip Email Attachment functionality not available in FCCS . Can anyone get this functionality to work in FCCS? if you go to the user guide for this fu…Laura Cohen 52 views 6 comments 0 points Most recent by Laura Cohen Financial Consolidation and Close -
Depot Repair Debrief Charges Subject Area for OTBII am unable to find subject area for Depot Repair Debrief Charges, Please guide where i can find this subject area -
Query to get the Job Requisition Approver details in BIP ReportSummary: we are trying to get the details of Job Requisition approval flow. precisely we wanted to get the details:::: with whom the Requisition is pending with? Content…User_2025-03-07-05-34-02-150 1.6K views 9 comments 0 points Most recent by User_YG5HR Reporting and Analytics for HCM -
Hi Experts, I am looking for a query get Estimates details for Work orders?Summary: I tried below table to get details but there is just one record exists in table and view. rcl_estimate_headers_b rch, rcl_estimate_lines rcl,——-No data exists r… -
Can we print the name of the Data source (Cube) in report header?Summary: for example, the reports are connected to the cube named FINCON, in the header it should show the Datasource connection name as "FINCON" -
Item not showing in estimate pdf reportSummary: Item not showing in estimate pdf report Content (please ensure you mask any confidential information): Item lines created in Estimate are not showing on pdf rep… -
Is there a log or audit report available that tracks the changes made to the existing schedules?Summary: Can we access logs for changes in the report schedule? Is it possible to generate a historical report of those changes? Content (please ensure you mask any conf…mmgascon 11 views 1 comment 0 points Most recent by Srikanth Mandapati Panduranga-Support-Oracle Workforce Management -
Migration issue with reportsSummary: We migrated reports from FR to Reports and went live with Reports for April close. We observe an issue with TB reports. When thousand separator with comma is us…Divya_Masoodi 281 views 8 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close -
Custom Payslip Prints Wrong AmountsHello experts! We use a custom format for our payslips. When the payslips are generated, if an employee has money going to different banks, and one prenotes and the othe…Henry Imgrund 31 views 2 comments 0 points Most recent by Henry Imgrund Reporting and Analytics for HCM -
Can we get the approval unit owners details for each entity in the report in SWP application.Summary: Can we get the Entity approval unit owners details for each entity in the report in SWP application. We have requirement to get the HC planner name (approval un… -
How to add security on custom BIP folderSummary: We want to implement security to a custom BIP folder to give restrict access of some users to it. How can we do that? Is there something we can do in permission… -
What are the standard Smart View reports available in Oracle ERP Cloud?Hi, What are the standard Smart View reports available in Oracle ERP Cloud? Such as for Cash Management we have the Cash Forecast and Cash Position Report which could be…Janitha Perera 31 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to fetch amount delivered on PO through SQL QueryWe have a custom Purchase History BI report that gives entire PO history. This report also has columns named quantity_delivered and amount_delivered which are being fetc…Pranita S 1.1K views 7 comments 0 points Most recent by Rakesh Sreenivasa Reporting and Analytics for ERP -
Changing the POV of migrated Financial Report to Reports (Insert Formatted) reportWhen I edit the POV of a report downloaded using Insert Formatted Report, it appears to open a new Excel sheet rather than simply refreshing the values within the existi…Patrick Pontillas 1 view 0 comments 0 points Started by Patrick Pontillas BI Publisher Learning Center -
Oracle HCM Cheque Report any issues in customizing a template for itSummary: Have been asked to create a customized template for the seeded report and check printing into a tri-fold check printout. I have not dealt with this report befor… -
Inbound HCM Extract to compress multiple reports in a Single Zip FileSummary: Hi, We have a Inbound BI Report created. The Inbound Interface HCM Extract needs to run multiple reports and compress all those reports into single zip file and…
-
Is there a way to create a JDBC Connection to Oracle ERP Fusion Database from External IDE?We are looking to connect to the BIP tables as if from the BIP Data Model creation → SQL Query. There is a possible connectivity using an outside software called CloudMi… -
I need to get a link to see a dashboard without settings pannel.Summary I need to get a link to see a dashboard without settings pannel.Content Hi, I have a dashboard that I have to link in the employees profile. Our customer needs t…Pablo Martinez de Villa De las Heras 121 views 16 comments 0 points Most recent by Tomasz 'TJ' Jublewski Reporting and Analytics for HCM
-
which table having the United States Job Information under the Manage Job setupSummary: Hi Team, We could not find the right table for "United States Job Information under" the "Manage Job setup" We have gone through multiple table but we are unabl…Opkey PA 12 views 1 comment 0 points Most recent by Martina Iovino-Oracle Reporting and Analytics for HCM -
Is there a report to show users' roles and privileges or what's table of them?Summary: We want a report to show users' roles and privileges or we can customize a new if there's no statndard process, but we don't know the table for these infoematio… -
How to fetch the document names of the attachments on a Journey Checklist taskSummary: I need to fetch the names of the attached documents on a checklist task, onto my OTBI analysis. Content (required): I need to fetch the names of the attached do…User_2025-07-18-13-29-11-469 52 views 3 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
In which table having the Workday informationSummary: Hi, We need a table to get workday information. For the setup: Manage Department have the workday information and we could not find the right table. Attached sc…