OTBI
Discussion List
-
HR Helpdesk Seeded Dashboards And AnalyticsSummary HR Helpdesk Seeded Dashboards And AnalyticsContent We are looking to explore if there are any seeded HR analytics available for the HR desk. We have referred to …User_2025-02-10-08-27-16-805 78 views 2 comments 0 points Most recent by User_2025-02-10-08-27-16-805 Reporting and Analytics for HCM -
Termination report to be run as termination date added/changedSummary Termination report to be run as termination date added/changedContent We want to build a report in OTBI that is run on an agent anytime a termination date is add…Emily Robinson 92 views 4 comments 2 points Most recent by Emily Robinson Reporting and Analytics for HCM -
Data-model from Analysis not working after 20BSummary Data-model based from Analysis keep saying path not foundContent After receiving 20B update, it seems like our Data-models are having issues (which are tied to A…
-
Please Save BI Answers Direct Database Query SQL Definition before 19D UpgradeSummary Please save your BI Answers Direct Database Query SQL definition before 19D UpgradeContent Please Note: This notice does not affect BI Publisher SQL data models …User720640-Oracle 149 views 5 comments 2 points Most recent by User_R6A85 Reporting and Analytics for HCM -
Compensation Salary History Details Subject Area not returning termsSummary Compensation Salary History Details Subject Area not returning termsContent Compensation Salary History Details Subject Area not returning terms. It will only re…TerryM01 27 views 23 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Report for all items name + item code + barcode numberSummary Report for all items + item code + barcode numberContent Hello All, I need a report to display the Item Name + Item Code + Barcode Number. I have the below table…User_2025-02-05-12-20-44-163 194 views 1 comment 0 points Most recent by User_2025-02-05-12-20-44-163 Reporting and Analytics for SCM
-
Is there delivered Affirmative Action Report for US in Oracle HCM CloudContent Hi All I was told there should be delivered report for Affirmative Action Report for US as its statutory requirement But I could not find one. Can you please let…Naveen Jayaraman-48236 125 views 1 comment 1 point Most recent by Tony Johnson-Oracle Reporting and Analytics for HCM -
Is it possible to view reports as employee?Content Hello experts, our customer would like to enable a user to see a specific OTBI report. However, at the same time this user cannot have access to My Team and My C…Valerio Curzi 103 views 9 comments 2 points Most recent by AshishERPCloud Reporting and Analytics for HCM -
Notify supplier on approval of agreement change orderSummary We have a requirement to generate a FYI notification to supplier once change order is approvedContent We have a requirement to generate a FYI notification to sup…
-
Odbc driver returned an error (SQLExecDirectW)Summary Error running reports for users in Production: Odbc driver returned an error (SQLExecDirectW).Content Hoping someone has encountered this issue before. We curren…AIT 48 views 4 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
Benefits ReportingSummary Dependent that is an employee OTBI or BIPContent how do we determine that a dependent is an active dependent or a certain plan and an active employee at the same…User_2025-01-28-01-44-03-184 127 views 2 comments 0 points Most recent by Adam Gates-Oracle Reporting and Analytics for HCM
-
Benefit Pending Action Item informationSummary Need back-end table name for Benefit Pending Action Item informationContent Hello Everyone, Can anyone share the table name/column name to identify benefit "Pend…
-
Intermittent Error Preventing Report FilteringSummary When applying filters to our Business Unit Column we are intermittently unable to do so when creating OTBI analyses and when using previously created analyses.Co…Thomas Griffiths 24 views 5 comments 0 points Most recent by User_2025-01-30-21-52-52-008 Reporting and Analytics for HCM
-
Joining Workforce Events to Person Real TimeSummary Having trouble getting the data to align between the two subject areasContent Hello Everyone, I've created a simple example of an analysis we're making to see ho…Rob F 34 views 11 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Sample Report: Salary Change Date Prompt (updated)Summary Sample salary change report using a date promptContent Salary Change Report Date Prompt This is part of the series of sample reports to use in your cloud environ…Gail Langendorf-Oracle 514 views 3 comments 4 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
OrganogramSummary Organogram RequiredContent Hi, I have come across many previous posts regarding organogram / organisational charts and none deliver a proper organogram whereby e…User_2025-02-05-22-44-35-842 51 views 37 comments 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Drill Down from the Master to Detail via Action Link using case formula columnSummary I am trying to drill from the Master report to the detail report, I am fetching the count of rejected invoices with respect to each statusContent Dear Friends, M…SandeepPaspunuri 51 views 3 comments 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP -
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…
-
Row Limit? Missing RowsContent Hi all - I have a query (Logical SQL) that I use to run for changes. It runs Assignment and Salary changes. When I ran the report in April, it pulled back ~132K … -
Seniority hoursContent We are developing a report using OTBI and one of the columns is to populate employees Seniority hours. Wondering which subject area contains that information? We…User_WHB5J 36 views 6 comments 0 points Most recent by Aliasgar Khambhaty-Oracle Reporting and Analytics for HCM
-
Analysis for finding positions with more than one EmployeeSummary Need a report that shows a list of positions that currently have more than one Employee in the positionContent I am trying to build an audit report that shows th…User_2025-02-04-08-51-08-912 37 views 6 comments 0 points Most recent by User_2025-02-04-08-51-08-912 Reporting and Analytics for HCM
-
20c Subject Area Changes - Transaction AdministrationSummary Additional fields added to Human Capital Management - Transaction Administration Real TimeContent I have been reviewing the readiness docs for 20c HCM, but I hav…ndryden 56 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
OTBI Report with Position Headcount data as of current month and as of previous month in the same anSummary Current and Previous month data in the same OTBI analysis based on AsOfDate variable parameterContent Hello All, Request help! Trying an OTBI report which includ…pooja yelsangikar-Oracle 167 views 10 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Multiple Rows For Assignment ManagerSummary Updated the assignment manager job today and each employee now has multiple rowsContent Hi, Today we ran the jobs to update the assignment manager fields. After …
-
Could not able to fetch Manager Hierarchy for Contingent workers using Workforce Management - WorkerSummary Could not able to fetch Manager Hierarchy for Contingent workers using Workforce Management - Worker Assignment Real Time Subject AreaContent Hi Experts, We are …Harish Kumar Kovi 25 views 2 comments 0 points Most recent by Harish Kumar Kovi Reporting and Analytics for HCM
-
OTBI report on requisition header attachment attributeSummary What attribute can be used to report on attachments against requisitions?Content Is there an attribute within any of the OTBI subject areas for procurement that …User_2025-02-05-09-40-23-780 110 views 3 comments 0 points Most recent by Ashok Sriniva-Oracle Self Service Procurement
-
How to increase the number of characters for a OTBI Analysis columnContent Hello experts, a text column returns truncated text while in Core HR I can see the entire text. As a result, I think that it depends on the report configuration.…Valerio Curzi 46 views 5 comments 0 points Most recent by Valerio Curzi Reporting and Analytics for HCM
-
Which PVO should be used to extract Resource Requirements in Supply Planning from BICC in Fusion ?Content Which PVO should be used to extract Resource Requirements in Supply Planning from BICC in Fusion ? Version Release 20BSandeep Pati-Trinamix 29 views 2 comments 0 points Most recent by Cherry Bruns-Oracle Supply Chain Planning and Collaboration