Reports
Discussion List
-
Drill down in OTBI Dashboard does not work correctlySummary: Drill down in OTBI Dashboard does not work correctly Content (please ensure you mask any confidential information): Hi, we created a Dashboard based on a OTBI R…Barile Alberto 32 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
How to fetch attachment report from document of recordsSummary: Hi Team, How to fetch report for attachments of each employee. Content (required): Documents of records - Documents type- COVID 19 Version (include the version …AjayKumar Maddipati 178 views 10 comments 0 points Most recent by sayeed_ahmed Reporting and Analytics for HCM -
Learning Management replaced by the Learning Record subject areaSummary: Can't find mappings for the new Subject Area Content (required): Goodmorning, in reference to "APRIL MAINTENANCE PACK FOR 21A" document which states: "Be aware … -
HR own position data not appearing for HR rolesSummary: Position Report is showing positions to the HR teams but its not showing their data Content (please ensure you mask any confidential information): I have a posi… -
Report to trace the elements costed from Journal entries along with transaction numberSummary: Report to trace the elements costed from Journal entries along with transaction number Content (required): Hi Team, Greetings! Once the entire payroll cycle is …Parag Hiremath 23 views 3 comments 0 points Most recent by Fazal Subhan Reporting and Analytics for ERP -
Ability to submit Multiple Custom Bi reports(HCM) based on a single schedule (dynamic date param)Summary: We have multiple BI reports that take similar date parameters as input and produce different txt files as output. Since there around 60 unique scenarios we are …SarthakRohilla 11 views 0 comments 0 points Most recent by SarthakRohilla Reporting and Analytics for HCM
-
Absence Balance MismatchHi All, Several employees have a balance discrepancy between the plan level and the accrual level. Is there a query available to retrieve this information and identify t…
-
Employee Active Payroll balance reportSummary: Employee Active Payroll Balance Report Content: We have a requirement to include New Mexico Workers' Compensation for both Employee and Employer in the Employee…Ayesha Islam 21 views 0 comments 0 points Most recent by Ayesha Islam Reporting and Analytics for HCM
-
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 62 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 1.1K 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 72 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 152 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 61 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
-
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 -
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