OTBI
Discussion List
-
HR Help Desk Infolets "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no dataSummary: Hi, I have a question about HR Help Desk Infolets. "My HRHD Request Work Time" and "Team HRHD Request Work Time" return no data and I am trying to understand wh…Viktoria Priona-Oracle 18 views 1 comment 0 points Most recent by Paul Romero-Support-Oracle Reporting & Analytics for Fusion Service -
Where to Find Extract Data Stores Documentation for HCM related PVO'sSummary: Hello, We are unable to find the documentation for the Extract Data Stores for HCM . The same is available for Financials, Procurement and SCM. Can you please a…Amritha2184-Oracle 109 views 9 comments 1 point Most recent by vmahendra7 Reporting and Analytics for HCM -
Job Offer DFF values not appearing in OTBISummary: We are trying to pull a Job Offer Descriptive Flexfields (DFFs) OTBI report for India, the values are appearing blank. Interestingly, we can see the correct val…
-
Issue Accessing Data in Custom HCM BI Report in Lower EnvironmentHi Team, We have a custom BI report in the HCM module that retrieves both Salaried and Hourly employee data. Although the required data access and roles appear to be cor…Deepak kumar Rai 2 views 0 comments 0 points Started by Deepak kumar Rai Reporting & Analytics for Fusion Service
-
What is the Vacation Delegation Table in fusionWhat is the Vacation Delegation Table in fusion and what is different between FA_FUSION_SOAINFRA.WFUserVacation and PER_DELEGATED_ROLES I am encountering an error (ORA-0…Mohamed Shaaban 41 views 3 comments 1 point Most recent by BK_Oracle-Oracle Fusion Applications Administration
-
Account Analysis Drill down -Subledger-Real TimeSummary: The requirement is to have all the transactions (Invoices/Credit Memo's) listed in tabular form once we click on particular balance sheet account for the period…Kinjal Patel-Oracle 21 views 2 comments 2 points Most recent by Kinjal Patel-Oracle Reporting & Analytics for Fusion Service
-
Tools for generating the Income Statements and Balance Sheet “out of the box"Is there any tool provided by Oracle for generating the Income Statements and Balance Sheet “out of the box”. If FRS is going to be sunset ->is there a tool already in t…twinkle talreja 11 views 0 comments 0 points Started by twinkle talreja Reporting and Analytics for ERP
-
We have a requirement to fetch the Pending change order amount for a particular projectWe are fetching the change order amount from 'Procurement- Pending change Orders Real Time' subject area but we are not getting the exact amount changed column. Kindly l…User_XWNJM 11 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle 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 21 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
OTBI 'Can't load models - Restore your models' issueIn our TEST environment we are seeing the following issue is all users: As far as we are aware nothing has changed in the back end. We have done the following: Purged th…Mike Pee 11 views 1 comment 0 points Most recent by Paul Romero-Support-Oracle Reporting and Analytics for ERP
-
how to add the hyperlink to Dash board AnalysisWe have created an OTBI dashboard with an analysis that includes a graph based on suppliers and their purchased item categories. We need functionality that allows users …venkat chaladi 31 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for ERP
-
Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Is there a way to align X-axis labels to the bars in bar graph in OTBI Oracle Fusion.Currently if the orientation is changes to 90 degree, it shows like below:Shreya Agarwal-Oracle 11 views 1 comment 0 points Most recent by Pratap1305-Oracle Reporting and Analytics for ERP
-
Is there a suitable replacement for PAY_ACTION_INFORMATION table for 'Employee_Rec' type rows.Hello, Could you please suggest a replacement table for PAY_ACTION_INFORMATION for action_context_type (POA) and action_information_category ('Employee_Rec'). We are fac…
-
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…
-
How to implement rollup functionality in OTBI / BIP report in Oracle CX Sales Fusion?Hi everyone, I’m exploring whether Oracle OTBI (Oracle Transactional Business Intelligence) or BI Publisher can support a report layout similar to the Rollup (expand/col…Himanshu_Kumar 31 views 1 comment 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
Issue with Month-wise Active Headcount Count in Workforce Real time Trend Subject Area - OTBI ReportHello All, I am working on a report using the Workforce Trend - Real Time subject area in OTBI. The requirement is to show month-wise new joiners, attrition, and total a…KetanChavan 104 views 6 comments 0 points Most recent by Suneha .-Oracle Reporting and Analytics for HCM -
Receivables - Transaction Real Time to Receivables - Standard Receipts Application Details Real TimeHi. We are tying to get this subject are (Receivables - Transaction Real Time TO Receivables - Standard Receipts Application Details Real Time), however data is not show…Krishna Kishore 21 views 0 comments 0 points Started by Krishna Kishore Reporting and Analytics for ERP
-
In which Subject Area Can I get Fields related to "Event" ObjectI need to fetch data related to the "event" object in OTBI Reports. However, I’m not able to locate the fields in OTBI. Can someone guide me on which Subject Area contai…srikanth gollapally 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Help Needed: REST API Endpoint for Retrieving OTBI Reports in Oracle Analytics Cloud CRM DemoI am working with an Oracle Analytics Cloud environment integrated with Oracle CRM SaaS (demo instance at fa-etaq-dev13-saasfademo1.ds-fa.oraclepdemos.com). I want to us…srikanth gollapally 31 views 0 comments 0 points Started by srikanth gollapally Reporting and Analytics for ERP
-
Does BICC query returns live data?Using the 'EXTERNAL" keyword, does the following BICC query returns live data from Oracle ERP? or uses an offline extracted source? select distinct TransactionEntitySour…SHAHRAM SALAMI 11 views 0 comments 0 points Started by SHAHRAM SALAMI Reporting and Analytics for ERP
-
Issue with Retrieving "Workforce Scheduling - Workforce Schedule Real Time" subject area in OTBIHi , We have a client requirement to identify the scheduled number of working days using OTBI. For this purpose, we are utilizing the subject area: Workforce Scheduling …Nithin Nannuri 11 views 0 comments 0 points Started by Nithin Nannuri 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 Nannuri 21 views 2 comments 0 points Most recent by Nithin Nannuri Reporting and Analytics for HCM
-
Timecard calculated time SQL report showing unexpected resultsSummary: I have written a SQL query which is intended to show the period of a timecard for a given user, that user's calculated times for that week broken out by expendi…
-
Audit Data for Custom Fields on Service RequestsHi, we currently have the following query: SELECT DISTINCT SR.SR_NUMBER, CATEGORIES.CATEGORY_NAME AS CATEGORIA_ATTUALE, OLD_CATEGORIES.CATEGORY_NAME AS CATEGORIA_PRECEDE…Martina Di Battista 1 view 2 comments 0 points Most recent by Martina Di Battista Reporting & Analytics for Fusion Service
-
OTBI display duplicates while query don'tHi everyone, We use OTBI to extract some data in Excel to feed an home-made FBDI requisition process. The report included 11 queties, linked by their record_number to ge…Francois Robineau 11 views 1 comment 0 points Most recent by Francois Robineau Reporting and Analytics for ERP
-
Oracle fusion FDI in data actions How to provide the authentication for REST APII'm trying to get the invoice attchemnt url in FDI using data actions type HTTP API by call the REST API. but facing an issue to authenticate the REST API. We have enabl… -
How to get all the Queues & Resources assigned dates for a Service request in OTBI Analytics reportSummary: Hi Team, As per the requirement, we need to create reports with the list of resources assigned to the SR with the assigned dates and the same for Queues. Could …Nikhil_Samudrala 61 views 4 comments 0 points Most recent by Nikhil_Samudrala Reporting & Analytics for Fusion Service
-
Seeded report for ESS Job/BIP Reports running historyDoes Oracle has any seeded BIP reports or OTBI subject area to see below 1. ESS Jobs History 2. Scheduled BIP Report History
-
fnd_sessions has rows with last_connect that is after the employee last logged inSummary: We are trying to build a report to show who logged in that day. If a person logged in multiple times, we need to report the last time user logged in. Person 464…
-
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 91 views 2 comments 3 points Most recent by Rashmitkumar Dodiya-Oracle Reporting & Analytics for Fusion Service