Reports
Discussion List
-
Does anyone have a Leadership Hierarchy prompt or guidance on how to create one?Hello Does anyone have a leadership hierarchy prompt? If so can you share some guidance on how it was created? I want to be able to add a leadership hierarchy onto our d… -
how add user variable to report headerIs there any way to put a user variable into the header of a report?
-
Point in Time Headcount with Salary report - isolated doubling of salarySummary Our "point in time" report is mostly working. For a very small percentage, the salary amount is being doubledContent We have a report that is working fairly well…Cheryl Burwell 109 views 7 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
How to print data from different levels in the same line in Etext templateHi All, I am using EText template for HCM Extract which results in Employee having Multiple Balances. The Requriement is to display the employee record along with all th… -
How to create a Fusion Data Intelligence DV Report using OTBI Fusion TableI have an OTBI BIP Report which is sourced from Data model using OTBI Fusion database tables. I need to recreate the report under FDI DV. I am not sure how to find same … -
How to list all locked users?Summary: How to list all locked users in BI Publisher? Content (please ensure you mask any confidential information): Table PER_USERS and PER_LDAP_USERS are related to u…Stefano_Mazzocca 20 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Viewing reports history submitted by the userSummary: Our target is to see the reports history submitted by all the users in the fusion HCM. Please advise accordingly how can I retrieve this information. Content (p…Azhar SIDDIQUI 1 view 1 comment 0 points Most recent by Azhar SIDDIQUI Reporting and Analytics for HCM -
Financial reports audit in FCCSummary: Audit trial for financial Reports in EPM - FCCS ? Content (please ensure you mask any confidential information): Version (include the version you are using, if …Vishal Kunda 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Not able to see data row(s) in HTML preview in Reports in EPMI created a report under Reports in EPM. I can preview and see the data rows in PDF and Excel preview but row header or data show up or display in HTML preview or format… -
Career StatementsSummary: Creating a Career Development's analysis report and I am unable to locate Career Statement in the subject area. Content (required): Looking to add Career Statem… -
sent automated email when records are more than 50I have a report which lists failed records for ar invoice. I need to send a email with list of records, when there are more than 50 records failed. Can this be achieved … -
How to add Hyperlink to BI Excel template fieldSummary: We have a requirement to show Oracle AR Invoice Page and when click on Invoice Number in BI Excel template. Excel template has list of Invoice Numbers and its d…SireeshaJaladi 413 views 5 comments 0 points Most recent by SatheeshSamy-Oracle Reporting and Analytics for ERP -
Which table stores Payroll Association dates?Summary: We are able to report on Payroll Relationship Final Close date and specific Payroll Assignment dates, but cannot find the data for Payroll Association Final Clo…TraciH-NorthBayHealth 1.1K views 6 comments 0 points Most recent by awheel09 Reporting and Analytics for HCM -
Request Read Receipt while scheduling BI ReportsContent I have scheduled a BI report and enabled Request Delivery Status Notification and Request Read Receipt Option. But I havent received any email or notification af…Sabarish Reddy Ganda 126 views 1 comment 1 point Most recent by Usman Ali2025 Reporting and Analytics for ERP -
Cannot open OTBI Report Workforce Compensation subject areaSummary: Content (please ensure you mask any confidential information): Hello experts, when opening the attached OTBI report the system doesn't return any value. However…Valerio Curzi 11 views 2 comments 0 points Most recent by Gail Langendorf-Oracle 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 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How can I get the usage details of the FR reports?Hi Team, We need information regarding the usage details of the FR reports i.e. which FR Reports are generally used by the Users on a frequent basis. Also, it would be h…KIRTI SETH 22 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Audit Trial for Workforce Compensation Approval taskSummary: Content (please ensure you mask any confidential information): Hello experts, when approving compensation plan (Approval task) the name of the last approver alw… -
Unusable FCCS SmartView/Report Retrieval Performance with DSO configurationSummary: We are developing a new FCCS application using the DSO (i.e. Dense Period and Movement dimensions) configuration. The SmartView retrievals and reports take upwa…Ken Chen666 95 views 11 comments 0 points Most recent by Ija Vidaurri Financial Consolidation and Close -
Any Oracle plan to separate or hidden Data & Reports under Library in the future?Summary: FCCS Data & Reports both are under same Library after migrating FR to MR Will they be totally separated or totally hidden each other in the future? Content (ple… -
SQL query or Table for Actions under Transaction Design studio in oracle fusion HCM my client groupSummary: Hi Team, We need a table name or SQL query where the information of Actions under Transaction Design studio in oracle fusion HCM my client group. Content (pleas… -
Facing issue to fetch proposed value of Pending TransactionsWe are trying to fetch proposed valued of pending transactions. Transaction is on Assignment change, I have written the following code but getting ORA19011: "Character s…SWAGATA1991 33 views 2 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Oracle ARCS Custom Report-Date parameterSummary: Client has a requirement wherein they want to generate report on month to date basis. Meaning when I generate report today (22/10/2024), it should fetch transac… -
While editing the report the message showing session has timed out and is no longer activeSummary: While editing the report system logging off automatically. Content (please ensure you mask any confidential information): Version (include the version you are u… -
How to get users last login dateContent Hi, We have requirement to fetch all users last login date and time. May i know which table can help to get the info. I tried FND_SESSIONS and ASE_USER_LOGIN_INF…