OTBI
Discussion List
-
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 311 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 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 63 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 11 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 44 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…
-
How can I get mass results for Responses in Assessment?Summary: We assigned our organization (~7,200) a video to watch and asked everyone to answer a feedback question. All that was fine except now I am trying to report on a…Aaron Reynolds 31 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
How to view attributes for a value within OTBI Subject Areas such as enabled flag, start date etc.Summary: Need to view attributes of a value such as enabled flag, start date, end date, allow posting, account type etc. Content (required): Our client wants to be able …Shiva K 162 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany