Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for HCM
Discussion List
-
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 … -
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… -
Custom column not prompted correctly in drill-down reportSummary: Custom column not prompted correctly in drill-down report Content: Hi, I have created a dashboard with different analysis about Hires & Terminations (analysis p… -
We have developed OTBI Report issue with output formatSummary: Hi Team, We have developed OTBI Report but issue with output format that is when try to export the report in csv or excel we getting multiple records please fin… -
need a PVO name for XML_DATA_CACHE column from HRC_TXN_HEADER tableSummary: I have checked in mapping file, but couldn't find the XML_DATA_CACHE column from the file. I want PVO name for XML_DATA_CACHE column Content (required): I have … -
How can I have a data model for Line Managers with Inactive - Payroll Eligible status?Summary: The organization decided to just use one BU. In so doing, there are expense reports generate and managers have not assigned to the new BU. Content (required): W… -
Benefit Certifications tableSummary: We have a requirement to fetch "Certifications" tab related data in the BIP report. May I know in which tables holds the information on certification? Content (… -
Reporting on Direct & Indirect Reports of Line ManagersContent Hello, I need to build a report where, as an Admin, I can see the details of the direct & indirect reports of a manager after selecting the line manager. Could a… -
Inaccessible Column Error When Running OTBI Report DashboardSummary: Inaccessible Colum error while running OTBI reports Content (required): Reports run fine for few users role but for few user/groups tried to run shows Inaccessi…
-
Find courses not completed in a specialization - Activity SequencingSummary: Hi, I have reviewed the article which mentions this OTBI report for specialisation. This works for us in the PROD instance where we have not enabled Activity Se…
-
how can I get correct seniority date when multiple seniority dates are there for a person in OTBISummary: I am reporting from Workforce Goals - Goal Status Overview Real Time and Workforce Management - Person Seniority Real Time. When I have Seniority Date showing, …
-
OTBI if Grade is Null those employees are not fetching in the report.Summary: We are adding version 3 seniority dates in OTBI existing report, added new subject area "Workforce Management - Person Seniority Real Time" when using filter co…
-
Connecting On Premise database from Oracle ADW deployed in OCISummary: What are the options in connecting - On Premise database from Oracle ADW deployed in OCI? Customers require to issue SQL involving objects from both of the data… -
How to display the value to be in line using BI Publisher (rtf)Summary: We want to display value in line from the RTF Template. However it displays as per below. Content (required): Please find attached RTF Template and XML Version …
-
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…
-
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…
-
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…
-
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… -
Data Security Policy Mapping for Leads in the UI and OTBISummary: Using different security in OTBI to HCM Cloud Content: Would it be possible for you to give me an example of this solution: https://community.oracle.com/custome…
-
Which tables do these search results belong to?Summary: When I search Subject Areas the result contains duplicates. Content (required): How do I know to which presentation tables the search results belong, and how ca…
-
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 …
-
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… -
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…
-
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… -
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 …
-
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…
-
How to fetch Arrear balance details for terminated EmployeesSummary: Content (required): Hello, Our requirement is to fetch the arrears details for the terminated employees, adjust them accordingly. Deduction report has a section… -
Looking for Report with Absence Type and it's corresponding Display Name on a TimecardSummary: Howdy, I'm looking for a report that will list the absence management type and corresponding display name by Timecard. See screenshot below. Content (required):… -
Infolet / Reporting Issue - USER.ID matching to Manager Email AddressHi all, I'm currently working on some infolets for displaying learning information for the managers to use when they load up PeopleCloud and I appear to have run into a …
-
Is there a way to report on user accounts being created?Summary: I want to audit when new user accounts were created, by whom and possibly which roles are assigned to the user account Content (required): I'm looking for a sub…