OTBI
Discussion List
-
Can we schedule a OTBI report by password protecting the output?Summary Can we schedule a OTBI report by password protecting the output?Content Hi, We have a question: Can we schedule a OTBI report by password protecting the output? …User_MC37Q 60 views 8 comments 1 point Most recent by Kimberly Nguyen Reporting and Analytics for HCM -
Learning Report to Track Course CompletionSummary: We have been using Managing Learning Real Time subject area to build our report to track completion status for each course and offerings. However, that subject …Ratha Sun 142 views 1 comment 0 points Most recent by David --Oracle Reporting and Analytics for HCM -
How to use Use the BulkDataExportService web service introduced in 22ASummary: Documentation missing for OTBI Webserivce BulkDataExportService Content (required): Release 22A has a note: Use the BulkDataExportService web service from the a…rsi-mir 31 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Split rows in Succession Plan reportSummary: Hi Experts, I've created 7 DFFs on the Succession Plan candidate page. To report these I'm building an OTBI report using the "Workforce Succession Management - …S Shree 31 views 3 comments 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
query to retrieve expenditure type linked to a project, task and organizationSummary: I need to extract the expenditure type linked to a specific project, task and organization (cost center). How can I build this query? Any suggestion? Content (r…Giuseppe Galluzzo 4.3K views 14 comments 0 points Most recent by Dustin Grabowski-Oracle Project Management
-
Is there a way to combine this so that the team shows on one row?Summary: Is there a way to pull the team on one row instead of duplicating per territory role? Content (required): I am trying to create an analysis for sales. The terri…
-
Ledger Revaluation Process Audit and ReconciliationSummary Ledger Revaluation Process Audit and ReconciliationContent Hi Does anyone have experience to audit and reconcile the Ledger Revaluation process? I know we can ge…Kashif Hussain-Oracle 96 views 2 comments 2 points Most recent by GAVMAX General Ledger & Intercompany -
Need to view who created and updated transactions.Summary: Content (required): In my organization, we want to find a way to view and analysis to know which user created or updated certain transactions such as AP Invoice…
-
Bi Publisher CSV output IssueSummary: Bi Publisher CSV Output Issue displaying all the fields in the output Content (required): Requirement is to display all the fields from the data model output of…kalyan gade 61 views 4 comments 0 points Most recent by kalyan gade Reporting & Analytics for Fusion Service
-
List of standard Out of the box reports available for ProcurementSummary: List of standard Out of the box reports available for Procurement Content (required): Hello Experts, Please let me if any standard out of the box (Pre-built/rea…
-
How to change middle name field to just one character?Summary: When the middle name field is more than one character, is there a formula that can be used to only show the first character? For example middle name contains "W…
-
Pension and annual salary data in one reportSummary: Hi, We are trying to build a report which provides information on an employees pension and annual salary. The report is built combining subject areas. When comb…NusratB 31 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
How do we find out the date a leave of absence was approved?Summary How do we find out the date a leave of absence was approved?Content We are using the 'Workforce Management - Absence Real Time' subject area and using the 'Assig…
-
Assignment Start Date Explained?Summary: Could an Expert help me understand how when Adding Assignments to a person, the Assignment Start Date field works in the Workforce Mgmt Subject Areas? The issue…
-
How to pull correct Learning Assignment Status valuesSummary: Cannot determine the logic to pull the correct Status value that is displayed in Status column of Learning Assignment Page. The Table has two Status fields and …Vanessa Gepitulan 328 views 6 comments 0 points Most recent by Vanessa Gepitulan Reporting and Analytics for HCM
-
Extract the ID of a department (going active on 01 october) from FusionHello, In Fusion we have created a department that will become active on the 1st of October. For our integration with Taleo I need the Department ID of this department a…
-
Rehire can't run OTBI report, but net new user account with same access canSummary: We have a rehire who can't run an OTBI report we built, but the same net new user account with the exact same roles and data access can. Content (required): Has… -
Absence Headcount - Percentage of Employees on Leave by JobSummary: Divide count of employees by total number of employees Content (required): Hello experts, As the title suggests, I was trying to fetch the percentage of employe…
-
Workforce Compensation Plan delivered reports and dashboardsSummary: Content (required): Hello experts, are there any delivered OTBI analysis and dashboards for Workforce Compensation Plan module? If so, please could you share th…Valerio Curzi 2 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Pull all of one HR Action as long as another HR Action doesn't exist afterSummary: Long title after contemplating how to ask this...:) My analysis pulls all HR Actions that equal 'Termination.' What I need to do is exclude any worker who had a…
-
Can we run ad-hoc queries using a custom tool/webpage by using BI publisher to access the Oracle CloSummary:We are currently in Cloud 23A for planning. We have an On prem 12.2.2 ERP system. Due to the new restriction Planning DB is on cloud and cannot be use accessed d…Raj Suman 41 views 2 comments 0 points Most recent by James Fabia Supply Chain Planning and Collaboration
-
Is there a Report that shows why a Work Order is not Complete in MaintenanceSummary: Client is requesting a report that shows reasons why a Work Order is not Complete e.g a report might not be complete because of material unavailability or even …
-
How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI.Summary: How can we fetch data under Performance Goals for the field "Manager Rating" in OTBI. We are able to fetch data only for the field "Overall Summary Manager Rati…
-
How to I pull a report on departments that shows the hierarchy level ?Summary: I need an establishment report with position details. Content (required): We have recently migrated to Oracle Fusion and are still getting our heads around it b…Isabela Radivoi 213 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
OTBI report - employees' action and action reasonHi all, we are having difficulty in exporting the Action Code/Name and Action Reason Code/Name for each employee. We can connect 'Person Number - Reason Code' but, canno…Lia P 308 views 1 comment 0 points Most recent by Raghavendra Raghunath-Oracle Reporting and Analytics for HCM
-
Assignment and Person Information for Whole Employee PopulationSummary: Hi - I have created a report that is supposed to pull in a combination of Assignment data, comp data, work relationship and person real time information (4 subj…Kyle Norris 11 views 3 comments 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM