OTBI
Discussion List
-
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 -
Need to report on Document Record attachmentsContent can we report on Document Records attachments count? Has anyone done it? Can anyone share a report or any with me? Thank you in advance! Version 21BGala Meyerovich 95 views 6 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
What is the Subject Area for Things to Finish (which are displayed on the user home page)?Summary: We have a requirement to show the count and Details of Assigned to Me under Things to Finish (which are displayed on the user home page) in an OTBI dashboard, s…Bhukya Vamsi Naik 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM -
How to set up time period for 12 week rolling percentageIn the "Workforce Management - Workforce Trend Real Time" subject area, in the "Workforce Trend" folder, there are the following fields: I need to use these in a calcula…rd17 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Line Manager Element Entries ReportingContent Hello everyone, We have a requirement that our line manager population needs to report on Element Entries (OTBI Report). When we run the report managers are able… -
Missing Work Phone TypeSummary: I'm looking at the subject area mapping, and playing with a few subject areas, but I cannot figure out how to build an analysis to see which employees are missi…
-
Can I put a link inside my Bursting query?I want to add an oracle link to send it in the mail notification in the message I print inside my bursting query, is this possible?Cansel Karasoy 51 views 3 comments 0 points Most recent by Cansel Karasoy Reporting and Analytics for HCM -
Impossible to open an OTBI reportSummary: Impossible to open an OTBI report Content (required): Hello experts, we have seen that, since a couple of weeks, a specific user is not able to open a report an… -
Recruiting - recruiting real time subject area not giving expecting dataSummary: We built an analysis using Recruiting - recruiting real time subject area while extracting the data we will able to get only Open Phase information However we w… -
What is the export limits in Oracle fusion OTBI/BI ?Summary: Could you please suggest what is the maximum row display/export limitation of the OTBI/BI Reports in Oracle Fusion Financials? Content (required): Version (incl…
-
how can I get one 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, …challa praveen 312 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Add timestamp so hours and minutes information capture while different phase in Job OfferSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
How can we pull data in custom report for the field name "Action" on Termination page.Summary: I am trying to generate a custom report and want to know the column name for the field name “Actions” in the Termination page. We do get the data for the other …
-
Customer Aging Report for Secondary IFRS ledger.Summary: Does Oracle Fusion has any reports that we can use for getting the Customer Aging(customer open transaction information using five/seven bucket aging method) de…
-
How to see DFF fields in the OTBI Subject Area : Procurement - Requisitions Real TimeSummary: New DFF fields were created in the Requsition UI but not found as a field in the OTBI Requisitions Line Detail Content (required): New DFF fields were created i…Maria Inocentes 1.1K views 1 comment 0 points Most recent by Amrita Gupta-Oracle Reporting and Analytics for ERP
-
OTBI: Multi Tab Excel Downloadable OTBISummary OTBI: Multi Tab Excel Downloadable OTBIContent Hi All, We have a requirement of creating a single OTBI analysis with multiple layouts. Each Layout should have a … -
Data Lineage on the FAW HCM LearningSummary: Looking for Data Model / Data Lineage for FAW HCM Learning area. That will have the joins/ information relation between the entities. Can anyone help with that.…Moumita Samanta-Oracle 71 views 6 comments 3 points Most recent by Moumita Samanta-Oracle Reporting and Analytics for HCM -
Get latest revision of sales order in OTBISummary: Get latest revision of sales order in OTBI Content (required): Hi Team, A sales order may have more than one revision. We are trying to create a OTBI analytics …ShantanuP 231 views 2 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
OTBI Subject Area to be used to create report in capturing receipt details and DFFSummary: OTBI Subject Area to be used to create report in capturing receipt details and DFF in self-service receiving. Content (required): Self-service receiving Version…Cliford 61 views 5 comments 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for SCM
-
OTBI:Individual Comp: Single row with Award Amount and Frequency in spite of data model constraints1- Below OTBI report has been built using "Compensation - Individual Compensation Real Time". It provides insights into the Awards awarded to an employee and the frequen…Abhishek Dixit-Oracle 61 views 2 comments 2 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for HCM -
OTBI created to fetch details of Absence accrual balance is not picking latest dataSummary: Content (required): We have created a custom otbi report which fetches the details of accrual balance. But we observed that the data is not getting updated on d…Veeru15 221 views 5 comments 0 points Most recent by Ramanathan Sockalingam Reporting and Analytics for HCM
-
How can I better manage OTBI based initiatives?Summary: We have more than 1000 initiatives based upon about 1000 OTBI analyses. What factors affect the efficiency of the initiatives? Are there any ways to know which … -
What is the process for adding group totals on an OTBI analysis?Summary: I want to add a group by employee number and to show its total trip distance for all start dates. Content (required): I have created an analysis based on Expens…
-
What does it mean to have 'INITIAL' in the 'STATE' field in the hrc_txn_data table?When I query the records with 'DRAFT' from the transaction table, the STATE field is reflected as 'INITIAL' AND 'SAVED'. What exactly does INITIAL mean?Cansel Karasoy 12 views 0 comments 0 points Started by Cansel Karasoy Reporting and Analytics for HCM
-
[OTBI] Delete HTML tag when exporting report to csv fileSummary: Delete HTML tag when exporting report to csv file Content (required): In order to delete the HTML tag in the OTBI report, the data format of the desired column …kayoung lee 41 views 3 comments 0 points Most recent by Bhaskar Konar Reporting and Analytics for HCM
-
Need details to create a report to fetch Supplier Attachment detailsSummary: Hi, I want to create a Report to list all the Attachment details of a Supplier. For that, I am looking for tables to find out the attachments of a Supplier at P…