Reports
Discussion List
-
How to generate the BIP report with the user time zone rather than the server time zone?Summary: Our reports are generated in UTC time zone, especially when it comes to Exit reports the LWD & the submitted dates are not matching because of time zone differe…Elavarasan S 98 views 2 comments 0 points Most recent by Elavarasan S Reporting and Analytics for HCM -
AR Aging ReportSummary AR Aging ReportContent Hi all, I am doing a AR Aging Report using OTBI. For example: AR aging report has following columns: Customer Name, Transaction Date, Tran…User_2025-02-04-05-26-22-197 126 views 8 comments 1 point Most recent by Ayala01 Reporting and Analytics for ERP -
Query to find the representative of an employeeSummary Query to find the representative of an employee through AORContent Hi Experts, Is there any generic query available to get the representative of an employee thro…Charan Kollipara 1.8K views 4 comments 0 points Most recent by Ashraya_SN-Oracle Reporting and Analytics for HCM -
Need to burst a book that will create one excel sheet with multiple tabsSummary: Need to burst a book that will create one excel sheet with multiple tabs, where each tab has the same report but is for a different cost center. Content (please… -
OTBI - ConcatenationSummary Is it possible to create a field that concatenates two or more text fields in an OTBI analysis?Content I am trying to create an OTBI Analysis using the Procureme…User_2025-01-28-20-11-21-100 919 views 3 comments 1 point Most recent by Ayala01 Reporting and Analytics for ERP
-
EPM Groovy Table in Email, The Character & issue and EPM Groovy Short URLSummary: Is there a way to use Short URL/Hyperlinks in email? We desire to send reports (smart cut link) in email as a hyperlink and also with shortened URL. We are not …
-
In My report have two views is Pivot table view and Table view how can we schedule both to emailSummary: Hi Team, In My report have two views that is Pivot table view and Table view how can we schedule both to email. when i tried it goes to only table view report. …AjayKumar Maddipati 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
Reporting employee access to dataHello Experts, It was rise as a demand the possibility to have a report on what employee has access of country data, i was trying to use per_person_secured_list_v and pe…Lucas B Maciel 21 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
DV Export To CSV export format- Date columns corrupted eg FIXE2LENGT02ATESummary: OACS - DV When exporting Table data from DV, Date Column are corrupted with text values similar to FIXE2LENGT02ATE value. When exporting Table data from DV as E…Keith Dunlop 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
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 11 views 0 comments 0 points Started by Nagarani M Reporting and Analytics for Taleo Learn
-
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 52 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 51 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 32 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.2K 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