OTBI
Discussion List
-
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 26 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 193 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 127 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 102 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 49 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 25 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 52 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
-
OTBI - Line Manager cannot report on future dated joinersSummary Line Manager cannot report on future dated joinersContent We have a requirement for Line Managers to see future dated joiners and internal movers. We are using t…User_2025-02-05-05-26-04-705 53 views 12 comments 0 points Most recent by User_2025-02-05-05-26-04-705 Reporting and Analytics for HCM
-
How to join Procurement - Procure To Pay Real Time and Procurement - Purchasing Real Time without "OSummary Ability to display PO Line DFF with Procure to Pay information and Logical SQLContent We would like to display the PO Line DFF with Procure to Pay information an…
-
Absence Days between DatesSummary Data must be returned where the absence is between two datesContent Hi all Can anyone help me with a problem where the Workforce Management - Absence Calendar De…Dawn Cawston - CPS 59 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM