OTBI
Discussion List
-
Need a sql query to get Deliver-to Location Type in RequisitionsNeed a sql query to get Deliver-to Location Type in RequisitionsMahmoud Ashraf 45 views 1 comment 1 point Most recent by Rakesh_Kumar_Sahu Reporting & Analytics for Fusion Service -
Absence is wrongly calculating in OTBI reports when applied in advanced mode.Hi Folks, While submitting the absence in Advanced mode, the balance is calculating for whole week even if i apply for two days in a week. What might be the issue? Pleas…
-
Accurate Headcount Reporting in OTBI even after department changeMy goal is to accurately reflect the headcount by department, ensuring that the count includes only active employees, even if they have changed departments. Currently, w…Nithin Reddy 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Send a Document of record as attachment through OTBI analysis output via emailDear All, We want to send by mail the output of an OTBI Analysis we have, but we need to send with it an attached file. The file that we need will be the CV of an employ… -
How to remove the privileges that are caught up in the ERP license count from the job roleHello, We tested and found the follows when trying to assign roles for OTBI report access. For the OTBI reports that spans business areas, there are some that cannot be …
-
OTBI drilldown to a Custom object detail pageSummary: I want to configure a drill down feature in my OTBI analysis to open the application detail page for the selected object. But, my action link opens only the obj…Curtis Allen 11 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service -
Is there a query that returns all valid grades ever associated with a position with eff datesWe found an issue on Positions where Valid Grades, previously deleted via HDL, are returning as a valid grade in the UI when any change is made on the Position itself. W…desirae_coleman 11 views 0 comments 0 points Started by desirae_coleman Reporting and Analytics for HCM
-
How to get Week of the Year in OTBI ReportsWEEK_OF_YEAR(dateExpr) not giving expected/correct valuesSagarChadha 1 view 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service -
Dashboard Prompt Not Visible to Users with Custom RoleWe have a folder named PLM Reports located under Custom Folder, which has security enabled for two roles: Custom BI Administrator – Full Control Report Enquiry Role – Re…Karthik Chedella 11 views 0 comments 0 points Started by Karthik Chedella Reporting and Analytics for SCM
-
Subject Area Related to CE_BANK_ACCOUNTS to get bank account Num & Asset Code Combination IDI am using "General Ledger - Journals Real Time" Subject Analysis & need to Join using Code Combination ID to get above bank account numSagarChadha 21 views 2 comments 1 point Most recent by SagarChadha Reporting & Analytics for Fusion Service
-
Unable to Find "Placement Match Date" Field in OTBI - Workforce Management: Absence Real TimeWe're encountering an issue in Oracle Fusion HCM when reporting on Adoption Leave (Event Type: Placement) using the Workforce Management - Absence Real Time subject area…Minal Deshmukh-Oracle 1 view 0 comments 0 points Started by Minal Deshmukh-Oracle Reporting and Analytics for HCM
-
Issue with OTBI – General Ledger Journal Real Time DashboardWe are currently experiencing an issue with the OTBI – General Ledger Journal Real Time Dashboard. Specifically, some of the accounting segments are not visible in the d…Kinjal Patel-Oracle 31 views 1 comment 2 points Most recent by KetanJ-Oracle Reporting & Analytics for Fusion Service
-
How to restrict the access folder level in BIP ReportsCould you please advise if there is an option to grant the permission only one folder (Eg: Pyables Custom) . We’re looking to ensure users cannot view or access for any …Linga Murthy 11 views 2 comments 0 points Most recent by Linga Murthy Reporting & Analytics for Fusion Service
-
**SOLVED** How can I get Manager grade step to display in OTBI?I have a requirement to include the grade step of managers in a report I am building however there doesn't appear to be anything available out of the box for this. Does …Rob Ward 11 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Need a report which lists all reports with roles required to run thoseIs it possible create a report that lists all reports in fusion Financials and the security role that is required to run each of these reports. Business is asked constan…Vinay414 32 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP
-
course usage reportHello, I would like to create a report to see course usage to potentially achieve trainings that have not been used for a while. Any suggestions on how to create this re…Sara.Zhao 11 views 1 comment 0 points Most recent by Abdul Rauf Mohammad-Oracle Reporting and Analytics for HCM
-
How to fetch Additional Communication settings under Recruiting Messaging Configuration in sql queryHi Team, We are unable to fetch Additional Communication settings under the task "Recruiting Messaging Configuration" in oracle table. Could you please help us in fetchi…
-
SQL Query for Data Model objects from OTBISummary: I am looking to perform a SQL query of Data Models from within OTBI and need to know which table to query. Content (please ensure you mask any confidential info…Alexinmn 265 views 3 comments 0 points Most recent by marcfromhawaii Reporting & Analytics for Fusion Service
-
Is it possible to download a BI report PDF through API from a CRM Groovy script?Hello, We have a requirement to download a PDF from a CRM Service Request screen, when a button is clicked, so we'd like to know if it's possible to run and download a B…Eduardo Ortiz 21 views 2 comments 0 points Most recent by Eduardo Ortiz Reporting & Analytics for Fusion Service
-
OTBI Prompt to control AORIn OTBI, can we control the prompt list of alues based on area of responsibility. Example - if the employee is tagged to abc, xyz & 123 legal entity, then when opening t…Suganya v 11 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
How to pick delivery method (online or offline) on the report defined in development goal pageOn the development goal page we have attached the course as a training and that course has DFF of online training or offline training defined on create course page, now …
-
How to Resync Arabic Hijrah Calendar in Oracle FusionWe are experiencing discrepancies in the dates within Oracle Fusion, specifically with the 'Arabic Hijrah calendar'. leading to issues with reports using Hijri Date. The…KirolosMagdy 81 views 2 comments 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM
-
jl_br_ar_collection_docs is empty in oracle cloudThe Table jl_br_ar_collection_docs is empty in oracle cloud. Does anyone know how this table gets populated? This table is being used for Brazil Boleto report which can …
-
SQL query to get multiperiod accounting in Accounts PayableSummary: Hi Gurus, I am struggling to get the correct data for multiperiod accounts details to match the GL account (Deferred). Build a query from AP to SLA but getting …Birley Varghese 375 views 4 comments 0 points Most recent by Yahya Khan Reporting & Analytics for Fusion Service
-
Fetch all report catalog objects - GL_FRC_REPORTS_BSummary: Fetch all report catalog objects - GL_FRC_REPORTS_B Content (please ensure you mask any confidential information): We are looking for a way to query all the cus…KDR 204 views 6 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Avg Time to Resolve (In Hrs)Summary: We are using the "CRM - CRM Service Request Summary" table to prepare service request data using reports. As part of that, there is a report that provides week-…Anusha716 12 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Role required to Search for Report JobsSummary: User X (with BI Admin role) is unable to search and view BI report submitted by user Y. Content (please ensure you mask any confidential information): User leil…Shubhojit 31 views 3 comments 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Prompt variable in SOAP executeXMLQuery requestWe have a report on which i have added a prompt variable to filter based on the email address. This works in the report itself: But when i try to get the report data usi…
-
New update multi-language for some table in oracle fusion in Jan 2025Hi Everyone, I noticed that some data tables have been updated with additional languages since Jan 14th 2025 in Oracle Application Cloud. Could you provide information a…