OTBI
Discussion List
-
Schedule otbi asset reportSchedule otbi asset report: If you schedule an OTBI Fixed Asset Report will it pick up the current Period if you tick the Use Trigger flag? -
Report to reflect latest asset locationSummary: Report pulling through a line per location, even if it was updated Content (please ensure you mask any confidential information): We currently have an OTBI repo…
-
How to find Grade ID for EmployeesHi, I am trying to complete a Bulk Load and require 'Grade ID' for employees, I have the Grade Name and Grade Code but not the Grade ID associated, how can i extract thi…Jacob Good 131 views 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM -
I cannot avoid multiplexing when joining item and category tables.Hello The following SQL multiplexes up to the item organizations record. CAT.CATEGORY_NAME AS CATEGORY_NAME and CAT.CATEGORY_CODE AS CATEGORY_CODE multiplexes on the bas…
-
How can we customize a learn role by giving access only to Learn OTBI reportsSummary: We have a requirement to create a learn administrator role along with country specific Area of responsibility which is working fine, but we need to restrict the…
-
Reporting on a Managers Direct Reporting LineHiya, I went on a workshop recently in Reading and Julian kindly told me how I should be able to report on direct employees under a manager instead of direct and indirec…MikeW 323 views 18 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Multi Row Attribute Group Attributes Enabled for BI not displayed in OTBI AnalysisSummary Multi Row Attribute Group Attributes Enabled for BI not displayed in BI Analysis Subject AreasContent Multi Row Attribute Group Attributes Enabled for BI not dis…Sudheer Movva-193114 40 views 5 comments 0 points Most recent by Leen Mardini Product Master Data Management
-
I am facing issue with one of my custom BI report developed to extract COGS Revenue & Margin!Hi Folks, I am facing issues with one of my custom BI report developed to extract COGS Revenue & Margin. While running the report from Data Model Schedule window, I can …Sravan Komminedi 21 views 1 comment 0 points Most recent by Radhika Abhyankar-Support-Oracle Reporting & Analytics for Fusion Service
-
Payroll Reporting name in OTBISummary Payroll Reporting name in OTBIContent Hi All, I can see a field "Reporting Name" in PAY_ALL_PAYROLLS_F table, I can able to pull this in BIP but not able to see …Prabhu Krishnamoorthy 50 views 4 comments 0 points Most recent by Anubha B Reporting and Analytics for HCM -
Create Analysis Report for Marketing Interactions with Account informationDear Community, we are trying to create an analysis report for Marketing Activities linked to various Contacts but it's hard to find a good subject area that works corre…George Papadogiannopoulos 11 views 1 comment 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales
-
Future new hire reportI am using Workforce Management - Worker Assignment Event Real time subject area. I am trying to pull all new hires and rehires. In order to included the future hires I …Trupti Khodke 88 views 5 comments 0 points Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for HCM
-
Can a Vanity URL be setup for the OTBI or BIP ReportsSummary: One of the requirements is to have a Vanity URL setup for accessing the OTBI/BIP reports from external source. Content (please ensure you mask any confidential …SSN-Oracle 41 views 9 comments 0 points Most recent by Patrick Breidel-Oracle Reporting & Analytics for Sales
-
OTBI scheduled reports/analyses "From" email changedHas anyone else noticed a change in the "From" email address for scheduled reports/analyses from OTBI? I have rules in my Outlook to filter these to a specific folder an… -
Does anyone have an idea on how to Call Third Party API from Fusion via ESS JobSummary: We have a standalone Oracle DB and and API that exposes the data from a specific table. Since we can't connect OTBI to other DB, we just want to be able to call…PeterXavier 11 views 2 comments 0 points Most recent by JohnCap Reporting & Analytics for Fusion Service
-
Skills and Certifcation Report but issue is will get one Extra Empty rowSummary: Hi Team, We have Skills and Certifcation Report but issue is will get one Extra Empty row how can we overcome the thta row. Thanks, Ajay https://us.v-cdn.net/60…AjayKumar Maddipati 21 views 6 comments 0 points Most recent by AnishaPatra-Oracle Reporting and Analytics for HCM -
Combination of position data and worker name only shows filled worker name rowsSummary: For an analysis in OTBI I used the subject area "Workforce Management - Position Real Time" for position data (position code, position name, department etc.) an…
-
PVO hcm extracts what types should be used and how ?Hello , We would like to use PVO extracts of Oracle of HCM type. Purpose -to get the worker (employee) details including their current manager, location, assignments, et…Revital Mefano 21 views 1 comment 0 points Most recent by Simona Stoian-Support-Oracle Reporting and Analytics for HCM -
Project receivable invoices payment statusIs there any analysis or OTBI subject area that can help in tracking the Project AR invoices status based on the applied amount. the image below is captured from the man…Mohamed Abdelbar 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Project Management
-
How to pull employees and contingents on a OTBI report along with seniority datesSummary: Hello, I am trying to pull both employees and contingents on a OTBI report along with seniority dates. I am noticing that since contingent workforce donot have …Nikhila 1 view 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Need help on combining these two analysisSummary: Hi, I have to create an OTBI report(attached screenshot) where I have to show voluntary termination/active HC and total termination (vol+invol)/active HC in one…Shreya Datir 41 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Perfermance Status Chart (SPI AND CPI)Summary: In which type of Analysis the said graph could be made. Thank you for your prompt attention to this matter.Looking Forward for your reply. Version (include the …
-
OTBI - Project Current Baseline Version and Actual CostSummary: Content (required): I'm trying to create an OTBI Analysis which shows the latest Current Baseline budget for a project, and next to this I would like to have a …
-
Need Guidance on a new feature "VIEW PURCHASE ORDERS AS A REQUESTER USING A DEEP LINK" in Patch23DSummary: The requesters and preparers cannot view PO detail using deep link which is a new feature in Patch23D. Content (please ensure you mask any confidential informat…
-
Assignment Status in BI ReportSummary Assignment Status in BI ReportContent Hi, I want to find out table field in BI Report which hold value Assignment Status = "Active Payroll Eligible" or "Inactive…User_2025-02-07-19-03-14-525 239 views 12 comments 1 point Most recent by Aurobindo Ghosh Reporting and Analytics for HCM -
How can I pull Job Families and Jobs, including Job Families not linked to Jobs?Summary: How to display "blank values"? Content (please ensure you mask any confidential information): From the Worker Assignment Real Time subject area, I can pull the …Arnaud Bory 62 views 3 comments 0 points Most recent by MandeepGupta Reporting and Analytics for HCM -
Custom Font on OTBI Dashboard?Is it possible to use a custom font with OTBI Dashboards/Analyses? We would like to develop a "theme" for our Dashboards and use our company's font. The only information…
-
How can I populate LEDGER_SUM columns similar to the standard General Ledger and Subled Account Rep?Does anyone know where we can take the values to populate or calculate these columns in a report? LEDGER_SUM_PR_DR LEDGER_SUM_PR_CR LEDGER_SUM_BAL_DR LEDGER_SUM_BAL_CR W…MARIA EUGENIA VICTORIA LOPEZ-Oracle 1 view 2 comments 0 points Most recent by MARIA EUGENIA VICTORIA LOPEZ-Oracle General Ledger & Intercompany
-
To extract employees list that receive standard notificationHello everyone, is it possible to extract a list of employee that receive a standard e-mail from the system? Thank you Alessandra