OTBI
Discussion List
-
Calculation using a UnionSummary: Is a calculation from two results using a Union possible? Content (required): I have a report which I'm looking to show the % of active employees who have a wor…Gary Miller-39965 41 views 2 comments 0 points Most recent by Gary Miller-39965 Reporting and Analytics for HCM -
Creating Reports and Extracts: How to map/link application front end fields to back end database tabSummary Looking for a simple way to map application pages/fields to cloud database tablesContent Good morning, I have been digging through the schema documentation while…User_2025-02-10-17-54-21-557 276 views 5 comments 1 point Most recent by Vamsi BOmmagani Reporting and Analytics for HCM -
OTBI Anaylsis to retrieve Security roles by usersHello, How can I create an OTBI Analysis to pull users along with their Security Roles or by able search the Role to see all the users using that role? Any help is appre…Gail Wilmoth 41 views 1 comment 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM -
want a Query to fetch the elements which don't have costing details.Summary can you share a query to fetch elements list which don't have costing details? Content (required): can you share a query to fetch elements list which don't have …
-
Need to report which Orgs have a common BOM added in OTBI reportSummary: When I run a BOM report in OTBI only brings up the master org when other orgs have the common BOM added Content (required): We have a group of products where th…ALASTAIR BURNS 31 views 2 comments 0 points Most recent by ALASTAIR BURNS Reporting and Analytics for SCM
-
OTBI Color coding on rowsSummary: Hi Team, Can anyone please help us on achieving the below requirement in OTBI. We have the percentages on each of the Job row as shown. These percentages are th…Vishal Quadros 81 views 5 comments 1 point Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Pass Dashboard prompt and analysis filters to drill down analysisI have a summary analysis of employee count by home state in a dashboard using a dashboard date prompt to pull as of a certain effective date. I have other filter criter…Susan Anderson 111 views 9 comments 0 points Most recent by Susan Anderson Reporting and Analytics for HCM -
How to View the Oracle Inventory Seeded Infolets And Get The Queries Behind Them?Summary: How to view details of Inventory Management seeded Infolets? Content (required): We need to edit/view details of oracle seeded infolets, currently we are unable… -
OTBI Pivot Table with multiple Subject AreasSummary: I am looking to create a Pivot Table with multiple subject areas that shows the completion status of certain learning items and the existence (Yes or No) of a f…
-
I am unable to fetch payroll details with worker and bank details in OTBI .Summary: When i take only payroll columns like payroll_id, payroll_name then i got output but when i select payroll columns with bank details or worker columns getting n…mohityagyik 21 views 4 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do I edit/access a bursing SQL?Hello, We need to review/edit a bursting SQL in one of our integrations. I can see the Bursting SQL icon in the DM Properties but I don't see an opportunity to change or…Wendy G 41 views 2 comments 0 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for HCM
-
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 752 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 62 views 14 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM
-
SCM Dashboard ReportI am looking for end to end O2C lifecycle details in report. Do we have any sample report report with this requirement ? Below are the columns I am looking into it. Sale…Oracletechnofunctional 61 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
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 344 views 1 comment 0 points Most recent by MandeepGupta Reporting and Analytics for HCM
-
Restricted Access to Reports and AnalyticsSummary: Hello All, I have a requirement where users should be able to access all reports and analytics in OTBI but should not be able to access any objects in Fusion Ho…Manju_Bujendra 172 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Understanding BI Extender and Import Oracle Fusion Data Extensions for Transactional Business ess joSummary: Hi Team, When using the columns of Entity(Balancing Segments) individually using balances real time subject area, it is generating correct result. However, when…Palak Singh 965 views 2 comments 0 points Most recent by Palak Singh Reporting and Analytics for ERP
-
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
-
Is there a way to get the Stop Date for Initiatives to populate if I want to make a report from hereSummary: We would like to be able to see when initiatives will stop so we don't miss making a new one. Is this something that can be done or do we have to keep our own s…
-
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
-
Query to fetch work requirement name against a work order.Summary: Content (required): In fusion Maintenance Cloud, we have defined multiple Maintenance Requirements in one Maintenance Program. Maintenance WO is generated from …
-
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. 171 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 31 views 2 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM