Reports
Discussion List
-
Required table for the Payment Method Preferences in PayrollSummary: Hi, Could you please let us know the table where the information of Payment Method preference stored for Payroll module. PAY_ORG_PAY_METHODS_VL has no informati… -
Subject Area: Payroll - Personal Payment Details Real TimeHello, Could anyone help or confirm if the Subject Area: Payroll - Personal payment details real time can extract the Account Suffix for our Personal Payment Method? Cou…
-
Unable to select parameters in a Manage Job SetWe want to create the Job set and with job parameters itself so that every time we run the job set, we do not have to fill the parameters again. Can you tell us how we c…
-
Unable to find the SQL joining for Event class and Mapping set in Oracle fusion Project to CostingSummary: Hi, We are unable to find the SQL joining Event class (XLA_EVENT_CLASSES_VL) and Mapping set (XLA_MAPPING_SETS_VL) in Oracle fusion Project to Costing. The inpu…
-
FDI - Is there a Manager Flag or Supervisor Indicator field available for selectionSummary: Is there a specific field within FDI that can be used to check if an Employee is also a Line Manager? e.g. If I used the the Subject Area MTS HR Analytics - Wor…David Thomson-265878 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM
-
How to embed Dashboard to My Team Page tab?Summary: Content (required): Could you please advise where I can find the instruction on how to embed an OTBI dashboard into My Team as a new tab? Thank you! Version (in…Evgeniya Repnina 201 views 12 comments 0 points Most recent by Vittoria Reporting and Analytics for HCM -
Online Excel preview to view BIP report outputs instead of downloading the file?When getting a BIP Report output in Excel format, is it possible to preview it online (as in cases with PDF/CSV outputs) rather than having it downloaded to system and o…PrerakKhandelwal 31 views 0 comments 1 point Most recent by PrerakKhandelwal Reporting and Analytics for ERP
-
How to best suppress base entity detail when ownership changes in reports?Not suppressing the detail results in double counting the base entity detail when reviewing descendants of the total Entity hierarchy even when the ownership has moved f…mattk1528 51 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Please provide definition of the following business Objects (In context of Audit Policies)Summary: Please provide definition of the following business Objects (In context of Audit Policies) - Data Security Control - Under Product "Common Work Object" Electron…dilipkumar 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unable to see goals under approval/in draft in OTBI ReportsSummary We are not able to get the data for goals awaiting approval or in draft state using Workforce Management - Goal status overview real time Subject Area.Content Hi…Mohit Gupta-45440 230 views 18 comments 1 point Most recent by andywuwuwuwu Reporting and Analytics for HCM -
requirement to automatically trigger BICC/BIP batch jobs after the ComCal are completed in the FIC.We have a requirement to automatically trigger BICC/BIP batch jobs after the Compensation Calculations are completed in the FIC (Fusion Incentive Compensation) applicati…Anita_ABR12 41 views 4 comments 0 points Most recent by Varun Malhotra-Support-Oracle BI Publisher Learning Center
-
OTBI British Summer Time effecting dates in Payroll - Element Entries History Real TimeSummary: British Summer Time (GMT +1) is producing incorrect results from the date Prompt using Effective Start annd End Dates Content (please ensure you mask any confid…Kevin Robertson 1 view 0 comments 0 points Most recent by Kevin Robertson Reporting and Analytics for HCM
-
Procure to Pay DashboardsSummary: Procure to Pay Dashboards Content (required): How can these be added to the home dashboard once the user is login, instead of going to reports and analytics and…
-
Table to get Assignment change historySummary: Table to get Assignment change history Content (required): Hi All, We got a requirement to show the assignment changes (Like Transfer). From which tables we can…Venkatesan 1.9K views 12 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Issue is when we add termination date in two subject areas OTBI reportSummary: Hi Team, when we add the two subject areas it showing correctly but when i adding termination date it showing two rows as below ? one is with termination record…AjayKumar Maddipati 41 views 10 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
ESS Job Parameters Not Displaying When Submitting Copied Journals ESS JobSummary: We created a custom ESS job by copying the seeded "Journals for Mexico" report, including: A new custom data model A new custom report A new custom ESS job The …Geethanjali kandlakoyya 111 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
HCM Approvals report secured by locationSummary: I have a requirement to create a report or analysis of approvals and their statuses, but it must also consider the employee’s location. The report should only d…Ismael Jimenez 11 views 4 comments 0 points Most recent by Ismael Jimenez Reporting and Analytics for HCM -
how to pull data from FCCS into Analytics and combine with Fusion Cloud ERP data (Finance)Summary: We would like to have some ideas about how to extract data from FCCS in reports in Analytics and combine with Fusion Cloud ERP data (Finance) Content (please en…Hans Krogstie 21 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Table name and column for EXPENDITURE BUSINESS UNITSummary Table name and column for EXPENDITURE BUSINESS UNITContent what could be the Table name and column for EXPENDITURE BUSINESS UNIT for project commitment although …
-
SoX BI report for Role and ESS changesHi All, As part of SoX auditing, we are looking for lookback BI reports to identify Role and ESS changes as we find from our analysis that the Audit reports available ou…Sam Mathews-81448 31 views 3 comments 0 points Most recent by Sam Mathews-81448 Reporting and Analytics for ERP
-
OTBI Analysis Report – Duplicate Rows Issue Even After Enabling DISTINCTSummary: I am working on an OTBI analysis where I am seeing duplicate rows in the output. For example, the same Person Number and Person Name (e.g., "101 – Ben") is repe…Manoj Muddineni 71 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
need to fetch the timestamp when Invoice status changes to Approved at summary levelSummary: for every invoice, when clicked on 'Validate' it will kick a process in the backend "Validate Invoices" which will change the status of Invoice to Validated nee…Anjali Sidharthan 11 views 1 comment 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
User engagement reportsSummary: In FCCS is there any way to generate User engagement reports? Like what features does a user is using regularly may be generating reports, passing Journals, ent…Amara Sai Sandeep 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unable to see data in xml_data_cache column of HRC_txn_data table.Summary Unable to see data in xml_data_cache column of HRC_txn_data table.Content Hi Team, As we know, Data_Cache column is deprecating from 21A and new column xml_data_… -
Check-Ins ReportContent We are considering implementing the Check-Ins feature in our 2021 performance reviews. We will need to be able to track completion rates. Perhaps I am overlookin…User_2025-10-31-00-57-47-193 78 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
How to disable play button on FCCS reports?We have users who see the "play" button when they open the migrated FR report. How can I disable it and get the report load automatically?Patrick Pontillas 31 views 1 comment 0 points Most recent by Komala Reddy-Oracle Financial Consolidation and Close
-
Variance arrows/icons in ReportsIn Planning and creating Reports, is there a feature for displaying variance arrows/icons either natively or through a workaround? Thanks for any insight. App Type: PBCS… -
Can we dynamically pull values from formula row depending on dynamic quarter and year?We want to pull values in current quarter and previous quarter dynamically from the formula row. Is there a way to do it using IF formula or any other way? In the below …
-
Need sample query to get Original transaction number from credit memosSummary: Need sample query to get Original transaction number from credit memos Content (please ensure you mask any confidential information): need to know about the bac…MayuriMMote 251 views 3 comments 0 points Most recent by Mohamed M. Faramawy-Oracle Reporting and Analytics for ERP
-
Reports under Workforce Compensation planSummary: Hello experts, Please let me know where can I find the details of delivered reports available under Workforce Compensation and related data models. Thanks, Cont…Vaishnavi Agrawal 31 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for HCM