OTBI
Discussion List
-
How to include legal employer to a document of record OTBI reportSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Aina Emmanuel 33 views 4 comments 0 points Most recent by Aina Emmanuel Reporting and Analytics for HCM -
What is the Oracle behavior when delete asset?Hi, I would like to know will Oracle reuse old asset number when we delete asset which created from FBDI template and recreate it using same FBDI file? The steps as belo…
-
Project Cost Budget BreakoutSummary: Project Cost Budget Breakout Content (please ensure you mask any confidential information): How can I get the breakout of what makes up the Cost Budget? Which r…
-
How to Version Invoice templatesSummary: We currently create Invoices by using an OTBI report to gather the data and put it into a RTF Template. However when you upload a new version of the template, t…Pete.Sterchak 11 views 0 comments 0 points Most recent by Pete.Sterchak Reporting and Analytics for ERP
-
Logical SQL with NULL resultsSummary: I'd like a Performance Tile based on a Logical SQL query to show Zero when no results are found i.e. there is a null result Content (please ensure you mask any …Richard Kemp-Eyre 31 views 1 comment 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM -
Possibility to Create Dynamically Different Tabs of The Same Report by Passing Diff. Param’s ValueSummary: OTBI Dashboard > Possibility to Create Dynamically Different Tabs of The Same Report by Passing Different Parameter’s Value Content (please ensure you mask any …Bernard T 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Line Manager Dashboard Workforce Trends with no resultsSummary: Hi, We are working on customizing the seeded Line Manager Dashboard. In "Workforce Trends" tab there are no results for the analysis (see attached screenshots) …Vasco 81 views 1 comment 4 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Calculated Field in OTBI PromptSummary: Wish to have Calculated field in OTBI prompt. I want to have 3 prompts based on the given table data below: Assignment Last Update Date Grade Change Flag Grade …Pradnya_Pampatwar 31 views 8 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Third party organization payment method reportSummary: Third party organization payment method report Content (please ensure you mask any confidential information): We have a requirement to run a report of the bank …Michelle Hughes 128 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
in OTBI Performance Report Completion Weight value not showing the total weight percentageSummary: OTBI Performance Report needs to show the Completion Weight percentage value display as the total. it is displaying as the separate Completion Weight percentage…Ritu Surve 11 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Can you secure objects in Subject Areas?Summary: Can you restrict certain objects contained within a Subject Area? Content (please ensure you mask any confidential information): Hi Community, I have a requirem…Matthew Hancock 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Is it possible to fetch Projected Start Date changes of Pending Workers through HCM Extract or OTBISummary Is it possible to fetch Projected Start Date changes of Pending Workers through HCM Extract or OTBI or BIP?Content Hi Experts, We are working on a requirement to…Harish Kumar Kovi 202 views 4 comments 0 points Most recent by 'Reekey Reporting and Analytics for HCM
-
Help reporting on Veteran, Disability, and DiversitySummary Looking for a way to report on Veteran, Disability, and Diversity dataContent Hello All, I would like to create a report in Fusion to include veteran, disability…User_2025-01-22-19-24-11-575 369 views 4 comments 0 points Most recent by Shant_Sarkissian_WJG Reporting and Analytics for HCM -
how to show extensible flexfields from order management to OTBISummary: Hi, we able extensible flexfield in order management and we enabled "BI Enabled" in all of fields, but these fields don't migrate to OTBI, we run the process Im…Alex Pagliarini - Ninecon 121 views 8 comments 0 points Most recent by User612903-Oracle Order Management -
How to get the PTD & YTD Balance values from the "Payroll Balances Real Time" Subject AreaWe need to create an OTBI report with the balance PTD and YTD values. In the "Payroll Balances Real Time" Subject Area, Assignment-Period to Date, and Assignment- Tax Ye…Jatin_Maru_1 81 views 2 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM -
Payroll - Payroll Costing Setup Details Real Time subject area has timed tracked changesSummary: This subject area is called RealTime but it contains history, as a result it will only return costing details for a position if the costing details have a start…Diane G123 32 views 3 comments 0 points Most recent by Venkateswara Rao Vadlamani Reporting and Analytics for HCM
-
Learning resources usage report neededSummary Learning resources usage report neededContent Hello, We need to build a learning resources usage report. Try to look for the resources (like classes or instructo…
-
Can HCM OTBI output file be password protected like BI Publisher ReportSummary Can HCM OTBI output file be password protected like BI Publisher ReportContent Hi, We know how to BI Publisher report output file can be password protected with …User_2025-02-05-22-36-27-300 91 views 11 comments 0 points Most recent by AjayKumar Maddipati Reporting and Analytics for HCM
-
OTBI Report for Grade Change ReportSummary Grade Change ReportContent Hi Team I want to create the grade report to retrieve the previous and current based on the date parameter. I referred to all the repo…User_2025-03-07-20-55-01-859 182 views 24 comments 0 points Most recent by Pradnya_Pampatwar Reporting and Analytics for HCM
-
Different infolets for employee and managerHi, Can we enable different infolets for Employee and Line manager ? Regards, NivyaNivya Mathire 21 views 5 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Can you secure reports using area of responsibility?Summary HR Managers have an area of responsibility based on business unit however can see every employee when in Oracle Transactional Business Intelligence.Content We ha…
-
Workforce Management - Documents of Record Real Time: how to pull the DOR attachment link?Summary: Workforce Management - Documents of Record Real Time: how to pull the DOR attachment link? Content (required): Hi experts, I am curious if there is any way to p…Volodymyr Faranosov 41 views 7 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
case statement was producing only 3 records instead of 6 records in FINAL_PATH ColumnHi All, need help on below case. i am concatenating the different structure of Reports Url's (BIP,OTBI,DASHBOARD) with POD url along with report path. Here FLV.DESCRIPTI…Ravindr-Oracle 11 views 4 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
How to increase the length of the Description column more than 1000 pixels in lookup tablesHello All, Currently, I am facing issue with Description column in lookup tables. i wanted to store the Bip report path in Description column but it is truncating some p…Ravindr-Oracle 31 views 2 comments 0 points Most recent by Ravindr-Oracle Reporting and Analytics for HCM
-
Alternative ways to Schedule Reports, Agents and Report Bursting as opposed to using a Generic userSummary: We currently use a generic user which is against our IT internal controls (so have an open Risk we track). We are looking to establish if other customers have t… -
LSQL - Connect Job Applicant and Employee AssignmentHello All, I am writing an LSQL analysis in OTBI which requires us to add the Hire Date for applicants who are hired. We're familiar with the Projected Start Date and ev…Nick Dorfner 31 views 2 comments 0 points Most recent by Nick Dorfner Reporting and Analytics for HCM -
Automate the Archive process in OTBISummary Automating the Archive process in OTBI for Fusion HCMContent Hi, We take backups of the OTBI catalog across our Fusion instances by archiving the custom folder. …User_2025-01-30-01-56-27-828 140 views 9 comments 2 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
What is the current OTBI export limitSummary: What is the current OTBI export limit in Oracle Fusion? Content (please ensure you mask any confidential information): Version (include the version you are usin…CarmenR. 111 views 1 comment 0 points Most recent by Mihaela Cozma GL-Oracle Reporting and Analytics for ERP
-
How to join worker assignemnt real time and Higher education person Real timeSummary: Hi Team, We unable to add the two subject areas ? Any one assisatnce me on ? We need RACE colum from Higher education person Real time. Content (please ensure y…AjayKumar Maddipati 21 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM