Reports
Discussion List
-
Query to extract the last update date for document record fieldsSummary: Query to extract the last update date for document record fields Content (required): Hello experts, please, could you share the query to execute in order to fin…Freddy_Cerron 344 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
"Search" bar in Smartview for "Import formatted Report" isn't availableDoes anyone faced similar issue, I'm trying to open reports in excel and there is search button to search for members. For example: "Centre" dimension has 800+ members, …User_2025-03-10-22-57-31-218 51 views 4 comments 0 points Most recent by User_2025-03-10-22-57-31-218 Planning
-
FRS Report - Line break after change of cost centre in cost centre / parent rows - how?Summary: FRS Report - Line break after change of cost centre in cost centre / parent rows - how? Content (required): This feels like it should be easy, but isn't proving… -
Oracle Analytics Cloud (OAC) - Briefing Books QuestionSummary: Briefing Books Update functionality Content (required): We are trying to create a briefing book that automatically updates itself whenever changes are made to t…Miguel Cardoso 41 views 2 comments 0 points Most recent by Miguel Cardoso Reporting and Analytics for HCM
-
OTBI Dashboard Record Count MismatchHi Team, We have built a dashboard and that has a record count to count the number of rows. We could see the record count shows different numbers for people with differe…Swapnil Kashid 81 views 6 comments 0 points Most recent by Swapnil Kashid Reporting and Analytics for ERP -
What table is the values in "Payroll Transfer Status" and "Payroll Processing Status" stored?The screenshot below is accessible in Team Time Cards: I was looking for how could I get the values for "Payroll Transfer Status" and "Payroll Processing Status" -
BIP Report for batch monitoring of Scheduled HCM ExtractsSummary: Feasibility of BI Report for batch monitoring of Scheduled HCM Extracts. Content (required): Would like to know if it's possible to pull Scheduled HCM extracts …Kate Calderon 21 views 1 comment 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
Is it possible to choose a member dynamically based on another member selection?Summary: We have users a number of use cases where we'd like to select a member in a report based on another member selection. For example we have a view dimension which…
-
Bursting body and pdf attachmentHello, I want the message body of an e-mail I prepared with bursting to appear as follows, and I also want to add a pdf to this e-mail. How can I do that?
-
Recruitment Requisitions in Draft Not Displayed in AnalyticSummary In OTBI Answers, when querying recruitment requisitions that are in draft in Fusion, they aren't not returned.Content Recruitment requisitions that are in draft …User_2025-02-05-17-23-19-130 36 views 5 comments 1 point Most recent by Tina T Reporting and Analytics for HCM
-
Employee Roster Report using subject area-Compensation Real TimeSummary: We are in need of an employee roster report built off of the Compensation-Real Time subject area, but to pull the grade and range from the Job Details area, ins…Tammy Hemmingson 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Impossible to get report output for only some usersSummary: Impossible to get report output for only some users when launching them Content (required): Hello experts, we have been having problems since November 2022 for …Oriana L. 171 views 3 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM -
From which table can I add the Synchronization From Position field to the sql report?Hi, I want to bring the field where Synchronization From Position field returns 'Yes,No' on the assignment details page in the employee record to my report. Which column…Cansel Karasoy 31 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Parent Member Needs to Show First When running a BookSummary: When I am running a book for an entity with descendants, the parent is showing as the last page in the report. Content (required): I need a solution or workarou…
-
Narrative Reporting: Grid Data Limit - Fusion Data SourcesSummary: Narrative Reporting: Grid Data Limit - Fusion Data Sources Content (required): I'm facing this issue when trying to run a grid report (trial balance): "Grid Dat…Juan Lobaton-68193 122 views 6 comments 0 points Most recent by Juan Lobaton-68193 Narrative Reporting
-
Intercompany Report SuppressionSummary: When trying to suppress via a tolerance on intercompany matching reports the suppression appears to be on the individual variance columns rather than the total …Paul Wilcock 51 views 4 comments 0 points Most recent by Paul Wilcock Financial Consolidation and Close -
Management report/Cost center Reports available in FCCSSummary: Are out-of-the-box reports like management reports/cost center/local GAAP reports? Content (required): Hello, We need to have access to multiple reports like ma…Teodora Bulancea 81 views 5 comments 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Incremental Date Parameters on a Scheduled OTBI ReportSummary Have scheduled report run every Monday, for data from previous 7 DaysContent I built an analysis that has a between date parameter off of HR Event Action Date. W…User_2025-01-28-08-47-04-905 163 views 6 comments 0 points Most recent by Gourabh Choudhary Reporting and Analytics for HCM
-
How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsSummary How to Prevent merging columns in excel using RTF template in Fusion BIP ReportsContent Hi Experts, How to Prevent merging columns in excel output using RTF temp…Bala Kasineedi 1.3K views 6 comments 0 points Most recent by User_67JNL Reporting and Analytics for HCM
-
Performance Task Status subject area is not pulling data belongs to old org structure.Summary: Performance Task Status subject area is not pulling data belongs to old org structure. Content (required): We have created new organization structure version in…Swati U 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Need a Query to Exclude the Terminated Record after 7 daysSummary: First 7 days , The Record should show with Status= Inactive Status and after 7 days The Record should not be shown in the Report. Content (required): Version (i…MilanMohanty 101 views 10 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
How can I combine multiple templates in a publisher?I have a report that returns the absence records of the people I prepared from SQL and it will work according to the absence type parameter. The report will be prepared …Cansel Karasoy 74 views 1 comment 0 points Most recent by Sandeep S. Chauhan-Oracle Reporting and Analytics for HCM
-
Adding Hiring Manager worker number to ORC ReportingContent Is there a way to show the requisition Hiring Manager's (from Recruiting - Recruiting Real Time subject area, Job Requisition - Hiring Team) worker person number…Christine Hill 154 views 15 comments 0 points Most recent by User_RVOUN Reporting and Analytics for HCM -
Slicing data in Workforce Trend subject area by Sales RegionSummary: I am trying to measure period start and end headcount that lives in Workforce Mgmt - Workforce Trend subject areas. I need to be able to slice it by Sales Regio…Tracy Colon 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can anyone help me in finding the SaaS tables mappings for Depot Repair Workbench screen dataSummary: I have received requirement to build BIP/OTBI report on Depot Repair Workbench estimates screen. Could anyone help me in find the either table mappings or otbi …
-
Employee Count - Snapshot in Time?Summary: Is there a way to pull an employee count during a specific period in time? Content (required): Is there a report or anyway to get an employee count from previou… -
Access to Vertex Tax Error reports - not displaying in scheduled processesWe use Vertex for tax calculations and in the document referenced below, there is an error report that should be available via Scheduled Processes. I'm on the admin team… -
Cross subject area analysis - ErrorSummary: Content (required): Hello everyone, We are trying to create a cross analysis in OTBI using the following subject areas: Workforce Management - Person Real Time …Agapi 91 views 6 comments 0 points Most recent by Nilanjan Biswas-Oracle Reporting and Analytics for HCM
-
Are the Goals and Performance Report Dashboards shown in the Oracle Demo available as delivered?Summary: Hi Peers, Our client attended an Oracle Talent Management Demo and was besotted by the Dashboards shown by the Oracle team. Now they expect us to have these sam…S Shree 41 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Announcement: Financial Reporting change in behavior for valid intersections in 23.05UPDATE: This will no longer be an issue in 23.05, a bug related to this has been addressed. In the 23.05 release, Financial Reporting (FR) will now filter and restrict d…Dave Roberts_-Oracle 51 views 2 comments 4 points Most recent by Pavan-Oracle Financial Consolidation and Close