OTBI
Discussion List
-
How can I get the absence entries for the next month to my query?I am preparing a report that will be sent to employee in the form of notification for the absence in the status of Saved for the next month. So how should I restrict my …Cansel Karasoy 51 views 4 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
I need an example of a sql query that returns person names and roles.I need to prepare a report that will list certain roles. So how can I write the query about the names of the people and what roles they have?Cansel Karasoy 704 views 6 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
How can I run the report when I select the required parameter field 'ALL'?Hi, I have 1 parameter that is mandatory in the report I prepared, assignment status, you can see it in the screenshot. It is true that the report should not be opened w…Cansel Karasoy 61 views 14 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
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 321 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
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
-
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 -
OTBI Report: 360 feedback: details of the questionnaire answers + overall ratingSummary: Hello, Has anyone create an OTBI Report regarding 360 feedback: details of the questionnaire answers + overall rating? Can you please share a catalog for this? …Hazel De Castro 31 views 3 comments 0 points Most recent by Satheesh Nesamani 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. 131 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 33 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
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…Yves Blanc 71 views 7 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
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…AjayKumar Maddipati 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
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…User_2025-02-05-06-26-19-951 97 views 4 comments 0 points Most recent by Hazel De Castro Reporting and Analytics for HCM
-
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…Sathesh Ramaswamy 61 views 2 comments 0 points Most recent by Sathesh Ramaswamy Reporting and Analytics for HCM
-
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, …User_2025-07-18-06-45-42-477 101 views 4 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
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…challa praveen 71 views 8 comments 0 points Most recent by challa praveen Reporting and Analytics for HCM
-
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
-
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
-
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…Cassiano Carneiro 31 views 1 comment 0 points Most recent by Gail Langendorf-Oracle 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 43 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 143 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
-
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 …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
-
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):…David Rabalais 41 views 1 comment 0 points Most recent by David Rabalais Reporting and Analytics for HCM -
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…Matti Bugge 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM