Reports
Discussion List
-
Attempted to use REPLACE (name, chr(38)||amp;, '&') function to remove 'amp;' after & in DM SQLSummary: Hello Forum: We have & showing up in place of 'Apples & Oranges' i..e. 'Apples & Oranges whether in a Report or a native HCM Extract XML output (View En… -
25A Feature : Lease Amortization Schedules ExtractSummary: Clarification on 25A Feature : Lease Amortization Schedules Extract Content (please ensure you mask any confidential information): 25A Release Notes describe a …Janelle Azimullah-Oracle 381 views 11 comments 0 points Most recent by Jayaram AnuPriya-Oracle Lease Accounting -
Displaying Data from Multiple Datasets in BI Publisher RTF Template with Hyperlink SupportWe have a business requirement to include hyperlinks in the output of an Oracle Fusion BI Publisher report, enabling users to directly navigate to specific application p…Tauseef-Oracle 51 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle BI Publisher Learning Center
-
SQL/OTBI query to get the Organization Payment Method and Payment sourcesSummary: SQL/OTBI query to get the Organization Payment Method and Payment sources Content (please ensure you mask any confidential information): We are looking a report…Visu 942 views 5 comments 0 points Most recent by GajavalliKoteswararao Reporting and Analytics for HCM
-
Ad Hoc Smartview ERPWe recently set up a SmartView connection for Oracle Hyperion Financial Reporting, Fusion Edition so our folks can access different FRS reports from smartview. They also…
-
Invalid parameter property type after migrate Financial Report to ReportSummary: We facing error in migrating on of our Financial Report to Reports in Financial Report we use this syntax to get Attribute Values : Plug Account in Account dime…sarahayuputri 73 views 7 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Need Table name to pull Time Entry Layout Component in Time and LaborSummary: Need Table name to pull Time Entry Layout Component in Time and Labor Content (please ensure you mask any confidential information): Hi, Need Table name to pull…Sujeeth Chinta 136 views 7 comments 1 point Most recent by Nathan CCC Reporting and Analytics for HCM -
need Sql Query of the balances with the below shown fieldsneed the SQl query which as fields like FIT Reduced subject witholdable FEDERAL TAX MARITAL STATUS FEDERAL NUMBER OF EXEMPTIONS STATE JURISDICTION INDICATOR YTD STATE TA…Kande_Likhitha 51 views 5 comments 0 points Most recent by Kande Likhitha Reporting and Analytics for HCM
-
"Last Logged on" Audit clarificationContent (please ensure you mask any confidential information): Summary: Wanting to understand where the "last logged on" value is derived from in the audit tables. For e…Emma Long 1 view 1 comment 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM -
What is the minimum information necessary to update contractsSummary: Trying to create a data model and report to fix contracts that are missing PERIOD_OF_SERVICE_ID.I can run an SQL query on any of the tables, filter by PER_CONTR…Kameron Withak 21 views 3 comments 0 points Most recent by Ram_S06789 Reporting and Analytics for HCM
-
Required interface tables for the below tasksSummary: Hiteam, We are unable to find interface tables for the following tasks, we gone through the oracle docs but we could not find the below tasks interface tables. …Opkey PA 21 views 3 comments 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
In Cash Management OTBI, is it possible to get the transactions reconcilied to a statement line?Summary: On the Manual Reconciliation Cash Management page, it is possible to see which system transactions (AP, AR, etc) are reconciled to a given bank statement line. …User_2025-02-11-06-12-35-024 201 views 3 comments 5 points Most recent by John Ban Reporting and Analytics for ERP -
OTBI Dashboard Reverted to Old UISummary: Hi team, We have a dashboard that has reverted to an older UI in both Test and Production environments. However, the same dashboard in DEV looks fine and retain…Josel Pleyto 111 views 3 comments 0 points Most recent by Josel Pleyto Reporting and Analytics for HCM
-
Tracking Timely TerminationsHi Does anyone have or is aware of a report or dashboard that tracks the termination submitted for processing? We are having issues with overpayments to employees have s…Jose Guerra 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
is it possible to build data segregation by one level down the BU level? For example by department?Summary: Is it possible to build data segregation by one level down the BU level? For example by department? The current security segregation is by BU in Lease, but by d…
-
How to extract person images in .jpg format from Oracle HCM Cloud?Content I have a requirement to extract the person images from the Oracle HCM Cloud in the .jpg format. Please can anyone guide on this. -
Reports BurstingDo all members in the POV dimension need to be in the distribution list and do all members in the distribution list need to have the email field populated? In my departm…
-
BIP Report or Dashboard for Data at Security Console with RolesHi Team, I am trying to create a report for the below columns using either Subject Area or SQL Query. Trying to mimic the page of the Security Console as well as include…Swapnil Kashid 51 views 6 comments 0 points Most recent by Iann hick Reporting and Analytics for HCM -
Does anyone have a SQL Query or OTBI report that will list by employee hours worked for the year?We are needing 2024 Paid Hours. We tried running the Periodic Payroll Activity Report but because the data is so large when including hours, it will not complete. I need…
-
Historical report on positions held by active and inactive employee within a date rangeSummary: Looking for a historical report on positions held by active and inactive employee within a date range Content (please ensure you mask any confidential informati…M.Naing 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Dynamic Picture watermark based on the conditionThe requirement is to get Picture Watermark only for a specific sponsor of the employee. If the employee has a different sponsor, we should not get any watermark. How ca…Nalsoft Pvt Ltd 21 views 0 comments 0 points Started by Nalsoft Pvt Ltd BI Publisher Learning Center
-
Need Submit and Duplication(copy) button for Consolidation Journal report jobsSummary: Need Submit and Duplication(copy) button for Consolidation Journal report jobs Content (please ensure you mask any confidential information): Version (include t…Prashant Tolanur-Oracle 1 view 1 comment 0 points Most recent by Prashant Tolanur-Oracle Financial Consolidation and Close
-
Trigger Notification under Bell icon (Fusion HomeScreen) using BI Publsher ReportContent Hi Gurus, Can we Trigger Notification under Bell icon (Fusion HomeScreen) using BI Publsher Report? I Created BI Analysis report and then Agent to call Analysis …Sunnyrajarora-Oracle 91 views 4 comments 0 points Most recent by PranayBhargava13 Reporting and Analytics for HCM
-
Looping in Etext template - HCM ExtractHi All, I am using EText template for HCM Extract which results in Employee having Multiple benefit plans. The Requriement is to display the employee record along with e…
-
In what way Dec24 feature EPM Cloud System Reports is better than already existing EJ Custom ReportsSummary: In what way Dec24 feature EPM Cloud System Reports is better than already existing EJ Custom Reports? Content (please ensure you mask any confidential informati…L. Lawliet 31 views 4 comments 0 points Most recent by Tom LeFebvre-Oracle Financial Consolidation and Close
-
FCC report book takes in excess of seven minutes to complete.Summary: Our FCC report books take an excessive amount of time to run. Are there any report book performance solutions available? Content (please ensure you mask any con…Justin_Scholl 31 views 2 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close