OTBI
Discussion List
-
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 129 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 -
How do we control Grant/Restrict access to OTBI > Jobs > Report Job HistorySummary: Hello All, We Would like to understand how can can we grant or restrict access to "OTBI > Jobs > Report Job History". Do we have a role or Privilege with contro…tawfeeq.k 71 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
No Results- The specified criteria didn't result in any data in WorkForce Manag.- Person Real TimeSummary: Hello Oracle Experts. We are trying to create an OTBI for generating the employees loaded in the Fusion ERP. We don't have HCM in scope, it is only SCM and Fina…Lokesh_619 81 views 5 comments 0 points Most recent by Raghavan p-Oracle Reporting and Analytics for HCM
-
How to Automate BACS file to be placed in UCM server?Summary: We have a requirement where BACS File generated using "Make EFT payments process" should be automatically sent to UCM(Oracle WebCenter Content). If anyone has f…
-
Report a journey task status "not applicable"Summary: How can I report, via OTBI, the status "not applicable" if an employee clicked on it during the completion of a journey? It won't appear as a completed task on …Jacqueline GRANDIN 21 views 4 comments 0 points Most recent by Jacqueline GRANDIN Reporting and Analytics for HCM
-
Infolets sampleHi Experts, Can someone share infolet samples/catalog files for employee and manager ? Thanks in advance. Regards, NivyaNivya Mathire 31 views 3 comments 0 points Most recent by Nivya Mathire Reporting and Analytics for HCM
-
How can I optimize/simplify my KPI formula in order to reduce the time of the report to load?Summary: It takes 13mins to load my report using the formula since I have to add 2 values on my KPI formula before getting the percentage. Is there a way to optimize my …John Patrick Diaz 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Sql query in dashboard prompt for bi publisher parameterSummary: Hi All, I am developing one Absence report by BIP report. The requirement of this Absence report is to show the employee's absence details in his dashboard. For…Sai Krishna Chelikani 151 views 2 comments 0 points Most recent by Sai Krishna Chelikani Reporting and Analytics for HCM
-
procurement work confirmatSummary: Subject Area for Purchase Order Work Confirmation Please i need to know if there's a subject area in OTBI which stores the data for work confirmation for procur…Mona_ahmed 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Report Hours Worked/Processed by PayrollSummary: I need to be able to report hours processed by payroll from beginning of the year to current. I cannot use the timecards. I thought it would be in the payroll r…Jessica D 21 views 1 comment 1 point Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Does anyone have a EEO-4 that meets the layout specifications they would be willing to shareSummary: We are required to submit an EEO-4 report by December 5, 2023. Content (required): The EEO-4 report is a mandatory biennial data collection that requires all st…Emily Wilde 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
How do add custom infolets in order-to-cash tab?Summary: Hi, we need to add custom infolets, but there is no add field in this option below. We able the sandbox, but I can't add new custom infolets Content (please ens…Alex Pagliarini - Ninecon 31 views 2 comments 0 points Most recent by Alex Pagliarini - Ninecon Order Management
-
Unable to download Purchase Orders via Oracle Visual builderSummary: Content (required): error message received The requested resource could not be found. (VBAFE-00107) The remote server returned an error: (404) Not Found. Please…
-
Time and Labor -- Calculated time card entries for a date range or pay periodSummary Calculated time card entries for a date range or pay periodContent Hi Friends I have been working on a report for Calculated Time Card Entries and so far i have …