Reports
Discussion List
-
can we have different color for total bar in waterfall chart?Summary: As client requested in the total bar with different colors Content (please ensure you mask any confidential information): Version (include the version you are u… -
How to Access Oracle HCM Cloud User Activity Audit data via API or any method ?Summary: Customer has a requirement to track the activities logs data performed by HCM Cloud User via API or any other method. They are interested to fetch the user even…RBM 505 views 8 comments 1 point Most recent by Mihai Nedelea-Oracle Fusion Applications Administration
-
Changed account type as Expense but still at closing balance I am getting data as Closing+OpeningI have changed the account type from Asset to Expense Account Type. How can I get the current year movement data on Closing balance without opening balance addition?KIRTI SETH 21 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Smartview Error - "Unable to get property 'open' of undefined or null reference'Summary: I get the following error when running a macro to generate a report in smartview: "Unable to get property 'open' of undefined or null reference. Any assistance …
-
parameter value while scheduling reportSummary: hi In order to retrieve data from FLA_LEASE_BALANCES_ALL table, we were told that need to run Generate Lease Transactions and Balances Report every GL period. a…
-
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 34 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 171 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 14 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 24 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 384 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 60 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 993 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 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 143 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 64 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