OTBI
Discussion List
- 
             How to fetch Goals Target outcomes in OTBIHi All, How to fetch Goals Target outcomes in OTBI? Thanks in advance.Robinson Ng 1 view 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service How to fetch Goals Target outcomes in OTBIHi All, How to fetch Goals Target outcomes in OTBI? Thanks in advance.Robinson Ng 1 view 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
- 
             why the Export Data has different results than Export FormattedSummary: why the Export Data has different results than Export Formatted Content (please ensure you mask any confidential information): We are actually trying to export …Kadali Harika 41 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service why the Export Data has different results than Export FormattedSummary: why the Export Data has different results than Export Formatted Content (please ensure you mask any confidential information): We are actually trying to export …Kadali Harika 41 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
- 
             How to add action link in otbi report to link it to parameterised bip report?We have requirement in which we need to add action link in the otbi column which will take us to a bip report. The bip report will have a parameter and that would be the…SHRUTI PRIYA 32 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service How to add action link in otbi report to link it to parameterised bip report?We have requirement in which we need to add action link in the otbi column which will take us to a bip report. The bip report will have a parameter and that would be the…SHRUTI PRIYA 32 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
- 
             about assigning roles for OTBI report accessHello, I have some questions about assigning roles for OTBI report access. For cross-module OTBI reports, we created a duty role requiring 'priv1', 'priv2', and 'priv3' …M Wang 37 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting and Analytics for ERP about assigning roles for OTBI report accessHello, I have some questions about assigning roles for OTBI report access. For cross-module OTBI reports, we created a duty role requiring 'priv1', 'priv2', and 'priv3' …M Wang 37 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting and Analytics for ERP
- 
             BICC PVO for privileges and their link to rolesIs there a BICC PVO for privileges and their link to roles ?keshav rowjee 1 view 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management BICC PVO for privileges and their link to rolesIs there a BICC PVO for privileges and their link to roles ?keshav rowjee 1 view 1 comment 0 points Most recent by Clara Azoitei-Support-Oracle Project Management
- 
             Drill Down in Reporting not workingSummary: My pivot table is coming up as not able to drill down into even though the settings are correct for it to be allowed to be clicked into, not sure what I'm doing…Gabby 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service Drill Down in Reporting not workingSummary: My pivot table is coming up as not able to drill down into even though the settings are correct for it to be allowed to be clicked into, not sure what I'm doing…Gabby 11 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service
- 
             How to know what live agents are available and online for chatSummary: We have deployed Web Chat for Service with Oracle Digital Assistant integration and different queues based on the country. We would like to know what are the li…Calin Pavel 61 views 8 comments 1 point Most recent by Calin Pavel Reporting & Analytics for Fusion Service How to know what live agents are available and online for chatSummary: We have deployed Web Chat for Service with Oracle Digital Assistant integration and different queues based on the country. We would like to know what are the li…Calin Pavel 61 views 8 comments 1 point Most recent by Calin Pavel Reporting & Analytics for Fusion Service
- 
             Tables which stores the details of Request More Information for CandidateWould like to know which table stores the details that will be entered by the candidate when he/she is requested for More Information. The details may also include attac…Nalsoft Pvt Ltd 11 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace Tables which stores the details of Request More Information for CandidateWould like to know which table stores the details that will be entered by the candidate when he/she is requested for More Information. The details may also include attac…Nalsoft Pvt Ltd 11 views 1 comment 0 points Most recent by Chris O-Oracle Recruiting, Opportunity Marketplace
- 
             How to show a BI Publisher report along with an OTBI reportHi, I have a requirement to show a BI Publisher report along with an OTBI report. Is it possible to attach or embed a BI report inside an OTBI report? Also, if this is p… How to show a BI Publisher report along with an OTBI reportHi, I have a requirement to show a BI Publisher report along with an OTBI report. Is it possible to attach or embed a BI report inside an OTBI report? Also, if this is p…
- 
             Unable to join Purchasing and Receipts subject areas in OTBIWe have a requirement where we need to create an OTBI report with Purchasing Order and Purchase Order Receipts information like Purchase Order Number, PO Line Number, PO…vikram khengare 21 views 2 comments 0 points Most recent by Teresa Meyerhoeffer Reporting and Analytics for SCM Unable to join Purchasing and Receipts subject areas in OTBIWe have a requirement where we need to create an OTBI report with Purchasing Order and Purchase Order Receipts information like Purchase Order Number, PO Line Number, PO…vikram khengare 21 views 2 comments 0 points Most recent by Teresa Meyerhoeffer Reporting and Analytics for SCM
- 
             Additional details needed on Recruiting – Candidate Tracking Real Time subject area.We are developing a report in the Recruiting – Candidate Tracking Real Time subject area. Objective: Our goal is to extract a report that shows candidates activities per… Additional details needed on Recruiting – Candidate Tracking Real Time subject area.We are developing a report in the Recruiting – Candidate Tracking Real Time subject area. Objective: Our goal is to extract a report that shows candidates activities per…
- 
             Need a sql query to get Deliver-to Location Type in RequisitionsNeed a sql query to get Deliver-to Location Type in RequisitionsMahmoud Ashraf 67 views 1 comment 1 point Most recent by Rakesh_Kumar_Sahu Reporting & Analytics for Fusion Service Need a sql query to get Deliver-to Location Type in RequisitionsNeed a sql query to get Deliver-to Location Type in RequisitionsMahmoud Ashraf 67 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… 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 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… 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 … 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 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 14 views 0 comments 0 points Started by desirae_coleman Reporting and Analytics for HCM 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 14 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 3 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service How to get Week of the Year in OTBI ReportsWEEK_OF_YEAR(dateExpr) not giving expected/correct valuesSagarChadha 3 views 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 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 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 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
- 
             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 13 views 2 comments 0 points Most recent by Linga Murthy 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 13 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 13 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM **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 13 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 31 views 1 comment 0 points Most recent by Razvan Paduraru-Oracle Reporting and Analytics for ERP 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 31 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 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… 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 288 views 3 comments 0 points Most recent by marcfromhawaii Reporting & Analytics for Fusion Service 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 288 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 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