Reports
Discussion List
-
OAC lab not found on Core HR implementer courseSummary: no OAC console as it was previously the case when requesting a lab from worforce structures in the Core HR MyLearn Course Content (please ensure you mask any co…Lauriane Massin Whitaker 11 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for HCM -
Required Table or SQL query to get Criteria under Manage Statement Groups in Workforce compensationSummary: Hi, We are stuck to get the details for Criteria details under Manage Statement Groups in Workforce compensation plan in Compensation Module. Please help us to …Opkey PA 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Looking for a Custom Audit report showing old and new valuesClient is looking for a custom audit report build through BI which shows the old and new values.Meenakshi K 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Workforce scheduling: can't get details of patterns and shifts to show on analysisSummary: Looking for direction on how to find and capture the patterns and shifts in my analysis. Under Define Availability: Work Shifts, Work Workday Patterns and Work …MissHeidiJ 71 views 3 comments 1 point Most recent by Stephanie McInnes Reporting and Analytics for HCM
-
Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiSummary Extra blank line in Excel output from BI Publisher RTF template due to using page break to get multiple tabsContent Hi Experts, I have a problem. There is a BI R…Aloka Bhattacharya 2.1K views 26 comments 1 point Most recent by User_C767R Reporting and Analytics for HCM -
How does smart view work with Oracle fusion? are there any conditions to work like license?Summary: How does Smart View work with Oracle Fusion? Are there any conditions to work like a license? Content (please ensure you mask any confidential information): Ver…Mohamed Roshdy 31 views 2 comments 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
can we create Custom Journal report Same as OOTB journal reportcan we create a custom journal report Same as Out of the box consolidation journal report with same labels ? even is it possible to pull the data in debit/credit columns…
-
Common Dimensions between Subject Areas in OTBIanyone has a list of Common Dimensions between Subject Areas in OTBI? at least 2 or 3 different Subject Areas?
-
Expected Effort values not populatingHi team, We are experiencing an issue where we receive really inconsistent results for the 'Workforce Learning - Learning Records Real Time' Expected Effort value. Some …
-
Financial Reporting Studio Issue: 2025 Data Not Appearing CorrectlyDear Oracle Support, We are encountering an issue in Financial Reporting Studio (FRS) that is affecting the display of 2025 data in our reports. Problem Description: Whe…Patrick Chrabieh 82 views 6 comments 0 points Most recent by user10987169 Reporting and Analytics for ERP -
report /audit to track any changes done to auto provisioning rules(HCM role provisioning rules)Summary: We need to get a report /audit for any changes done to auto provisioning rules(HCM role provisioning rules). Please help us on how to achieve this requirement. …Jagadesh S 91 views 5 comments 2 points Most recent by Parag Hiremath Reporting and Analytics for HCM
-
Latest data changes are not reflecting in the OTBI report immediatelySummary: Hello All, We have an AOR drill-down OTBI report, but the latest changes to data are not reflecting immediately. For example, when we assign an AOR to an employ…Nusrat Shaheen 91 views 8 comments 1 point Most recent by Parag Hiremath Reporting and Analytics for HCM -
how to create subtotals in excell template for bipI had a requirement to create subtotals for each individual invoice_numbers , when i try to do sum function or subtotal selection it is not giving subtotal for each indi…Voladri Saikiran 34 views 0 comments 0 points Started by Voladri Saikiran Reporting and Analytics for ERP
-
Workforce Learning - Learning records Real time returns no dataSummary: Workforce Learning - Learning records Real time returns no data Content (please ensure you mask any confidential information): Hello I am trying to build a repo…
-
BI Publisher Workflow Notification – Show/Hide Fields Based on Logged-In User for NotificationsSummary: Hi, I’d like to know if it’s possible to configure a BI Publisher Workflow Notification to dynamically display or hide certain fields based on conditions relate…Matheus Roberto 31 views 0 comments 0 points Started by Matheus Roberto Reporting and Analytics for HCM -
SQL query or Table for Dynamic Columns data under Configure Assignment Segments in CompensationSummary: Hi, We could not find the tables name or query for Dynamic Columns data under Configure Assignment Segments in Worforce Compensation plan What is the table name…Opkey PA 21 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
building a report in Oracle PBCSHi everyone, I’m building a report in Oracle PBCS and I need to insert line breaks so that the rows don’t appear too long. However, I can’t find the option. Could someon…FTufaro96 31 views 1 comment 0 points Most recent by Dave Roberts_-Oracle Financial Consolidation and Close
-
Explanation / Description of values in STATUS column in pjc_expend_item_adj_acts TableSummary: Looking for help identifying the description / explanation of various statuses in the pjc_expend_item_adj_acts.status table. These are the values we see in that… -
FA Asset Addition and FA Asset Register reports lexical parameter and Temporary tableHi , Both of these reports use lexical parameter &l_fa_whatif_rep_t. We want to understand how this parameter value is derived. We tried to use fa_whatif_rep_t table, to…
-
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 200 views 5 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
Project Costing - Unprocessed Transactions Real Time Cannot see people namesI have one user who has all seeded Project roles and the proper access defined and is not able to see people names in the analysis: Project Costing - Unprocessed Transac…erpexpert03 11 views 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management -
Need Cleared check report in Oracle fusion without reconciliation processSummary: Hi, The business is using check payment method and issuing checks and they are using cash account when they issue payments. So there is no reconciliation proces…
-
Report Data is incorrect because Time zoneHello, we just recently faced an issue related to BI report on absence related data. It will give last one hour updated records of employees absences. (submitted/awaitin…Dara Nagasai 12 views 4 comments 0 points Most recent by Vanitha Kundaram Reporting and Analytics for HCM -
Purge User RequestsSummary: Purge User Requests Content (please ensure you mask any confidential information): There is a way to purge a specific request? I'd like to purge some requests f…Luca Nobili PWC 31 views 3 comments 0 points Most recent by Luca Nobili PWC Reporting and Analytics for ERP
-
Unable to find audit logs for archive or unarchive activity on BIP data model/report in ERP FusionOur client has a requirement to build a BIP report for audit purposes that can fetch information, such as when a user archives or unarchives the BIP data model or report…
-
Control report-level permissions during migrationSummary: We have a custom folder ("Folder A") with 4 roles assigned: Role A, Role B, Role C, and Role D. When a new report is migrated into this folder, it automatically…