Reports
Discussion List
-
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 71 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 132 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 202 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 112 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 23 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
-
Dashboard on Development Area: hrr_tmpl_metric_configSummary: Goodmorning, we're fancing a problema with the Talent Review Matrix in the Dashboard Standard The matrix is empty: analyzing the query from the log, we've seen …AM HRE 11 views 1 comment 0 points Most recent by Sivakumaran Muthusamy-Oracle Reporting and Analytics for HCM
-
HCM Extract: ORA-06502: PL/SQL: numeric or value error: character string buffer too smallSummary: The extract is running into error, logging also set to "no logging". But still the extract running into error, below shows log. There was a ORA-06502: PL/SQL: n…
-
Download Excel template BIP Report using SOAP Web ServicesThere was an error rendering this rich post. -
Which SQL Table store the Activity Information of Time Entry in OTL.Summary: If you have BIP SQL handy. Please share Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable…Ketan-Oracle 12 views 2 comments 0 points Most recent by Ketan-Oracle Reporting and Analytics for HCM -
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…