OTBI
Discussion List
-
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 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 515 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 60 views 4 comments 0 points Most recent by Dawn Cawston - CPS Reporting and Analytics for HCM -
Pivot Salary Data For Employee PopulationSummary Want to display salary data for employee population without summing the dataContent Hi - I am trying to create a pivot table in OTBI that would show salary data …Kyle Norris 30 views 9 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Parent Manager Name FormatContent How to switch format from First Name Last name to Last Name, First name/ Any ideas? Thank you.Mike Borghoff 24 views 10 comments 0 points Most recent by Mike Borghoff Reporting and Analytics for HCM
-
Need Public Holiday List in OTBI ReportSummary Need Public Holiday List in OTBI Report based on Country and year parameter.Content Need Public Holiday List in OTBI Report based on Country and year parameter. …User_2025-02-04-17-42-01-535 56 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for HCM
-
Automatic mechanism to Purge Interface Tables by checking the records countSummary Automatic mechanism to Purge Interface Tables by checking the records countContent Hello, Requirement is to Run the Purge Interface tables job, when the Item int…Aravind Laxmaiah 13 views 1 comment 1 point Most recent by Shyam Lakshman-Oracle Product Master Data Management
-
Error occurs while calling remote service ADFService11G. Details: Runtime error for service -- ADFSeSummary OTBI Analysis is running out with above error after 20B upgradeContent Hi All, One of the Analysis which is having below subject areas is running out in error (c…