OTBI
Discussion List
-
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.2K 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 235 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 62 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 13 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…
-
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 161 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
How to Pull Future Dated InformationSummary: How to Pull Future Dated Information from HCM Content (required): I have created a report in OTBI using the Payroll - Calculation Cards Real Time Subject Area. …User_2025-03-07-06-11-23-192 41 views 4 comments 0 points Most recent by User_2025-03-07-06-11-23-192 Reporting and Analytics for HCM
-
Removal of first two rows in OTBI outputHi Team, When we schedule the OTBI report with excel output, Output contains first line with header and next line is blank. Our actual output starts from third line. How…
-
OTBI Report subject area to include all shared category hierarchies of an item in our ReportSummary: Need OTBI Report subject area to include shared category hierarchies of an item in our Report Content (required): We attempted to use the "Inventory - Inventory…
-
Reporting on Termination Counts - An analysisSummary This post provides an explanation on the calculation of termination counts in OTBI.Content The post contains a brief synopsis and also a sample analysis xml to c…Raghavendra Raghunath-Oracle 178 views 14 comments 9 points Most recent by Yves Blanc Reporting and Analytics for HCM -
Assignment Event/Workforce Trends - Counting a Termination on the Termination DateContent Hello Experts! I'm using Assignment Event Real time and have noticed that terminations are counted the day after their termination date. I suspect it's counting … -
How to count terminations as effective on termination date itself?Summary Looking for ways to summarize terminations per period (i.e. monthly) based on the termination date itself, rather than the effective start date of the term actio…James Hoffmann 87 views 8 comments 1 point Most recent by Yves Blanc Reporting and Analytics for HCM
-
Is there a BICC data store that contains the Expenditure Type to Account MappingsSummary: Is there a BICC data store that contains the Expenditure Type to Account Mappings Content (required): We cannot find a data store that contains this information…Holly Wells 51 views 4 comments 0 points Most recent by Shivashish Dwivedi-Oracle Project Management
-
Are there any dashboard prompt experts or videos out there?Summary: Trying to create an EDI dashboard cross referencing with the new Learning Subject Area Content (required): I need to access data in three subject areas "Workfor… -
Can we access SOA MDS schema in fusion OBI reportsSummary: How to access SOA MDS schema in fusion OBI reports Content (required): We want to fetch business rules information in Cloud HCM through an OBI report. Is SOA MD…Hitachi ServiceDesk 21 views 0 comments 0 points Started by Hitachi ServiceDesk Reporting and Analytics for HCM
-
Page Composer -> How to pass pass parameters to embedded dashboard in Talent Profile pageSummary Bind Parameters to OTBI dashboard promptsContent Hello, Can anyone please help on this scenario? I have built a dashboard in OTBI, embedded that inside Talent Pr…SantoshKumarBhairi 130 views 3 comments 1 point Most recent by Raju Konidala Reporting and Analytics for HCM