OTBI
Discussion List
-
How to remove aggregation from OTBI analysis?Summary: How to remove aggregation from OTBI analysis? Content (please ensure you mask any confidential information): I have this table with first fields aggregated: I d…Stefano_Mazzocca 21 views 2 comments 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM -
Enterprise hire date of pending workersSummary: Enterprise hire dates of the pending workers obtained from OTBI analysis are equal to the dates of adding the pending workers Content (please ensure you mask an… -
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 58 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 63 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Report combining Subject areas Project Costing - Actual Costs and Project Costing - CommitmentsHi, Has anyone created an OTBI report that lists all costs related to a specific project and the tasks designated to that project? I was able to get almost all the field… -
How to extract requisition approval rules created in BPM as a report or CSV file.Summary: Requirement is to extract approval rules along with details/settings of the various stages, participants and the rulesets. Content (required): I have referred a…Ananda Bhargav Potluri 1.6K views 9 comments 3 points Most recent by Ananya Patel-Oracle Self Service Procurement
-
how can I create an alert within OTBIHello, how can I create an alert within OTBI? I need to send email notifications to both the manager and the employee. Is there any documentation or guidance available f…italoanjos 24 views 2 comments 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
FMLA Qualified Entitlement Balance ReportSummary Does anyone have a report that pulls balances on qualified entitlements?Content I am able to pull reports of absences but not entitlements. Since some absences a… -
How to use 2 subject areas in same formulaSummary: Using Analysis Report type, is it possible to have data from both subject areas in the same formula? Content (please ensure you mask any confidential informatio…Justine Klemetson 21 views 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for ERP
-
How to Enable Seeded Landing Page Infolet in Redwood UI for Presales ActivitySummary: We are currently working on enabling Redwood UI for presales-related activities and would like to leverage the seeded landing page infolets to provide users wit…
-
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 42 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting and Analytics for ERP
-
Create custom notification with Agents in OTBISummary: We are looking to create custom notifications utilizing Agents in OTBI. We have specific use cases where we need users to receive notifications (i.e. project co…
-
PDH Item Status backend tableWe need to have Item Number and its Item Status both combined in backend. Item Number is available in EGP_SYSTEM_ITEMS_B table, INVENTORY_ITEM_STATUS_CODE is available i…
-
OTBI showing home department instead of worked/cost department for reported hoursWe’ve noticed a reporting discrepancy between HCM and OTBI when it comes to department allocation for hours worked. In HCM, an employee’s hours are correctly charged to …Trupti Khodke 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Subject Area for Price ListSummary Subject Area for Price ListContent Hi, My requirement is to create a custom analysis for the price list. I am not able to find any subject area which will allow … -
Total current hours worked per employee in reportI am trying to run a report that will show every employee with the total number of hours they currently are contracted to work subtotalled (we have quite a number of emp…Karen Wilson 114 views 4 comments 0 points Most recent by Jose Guerra Reporting and Analytics for HCM -
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
-
BIP Web Layout Editor (.xpt) Pivot table Header's Vertical alignmentSummary: Is there really no Vertical Alignment in Measure labels header in a pivot table in .xpt report template? it looks in the center in edit but in the output: I tri…Carlo Reyes-59977 1 view 0 comments 0 points Started by Carlo Reyes-59977 Reporting and Analytics for HCM
-
How to apply segment value security to Procurement OTBI subject areasSummary: How do we restrict access to requisition OTBI subject areas based on the segment value security rules? Content (please ensure you mask any confidential informat…
-
Configuring Descriptive Flexfield Segments With Expense Report ParametersContent What attributes are enabled as flexfield parameters, and the syntax to be used in the value set logic for the Expense Report? I'm creating a new flexfied, in the… -
Query to extract open AP and AR invoices with all FBDI template fields to upload in another accountSummary: We are splitting our Legal entities and hence we need to extract all open Invoices and upload into a different account. Can you please help me with a query to e…
-
How to see who deletes datamodel/report in catalog?Summary: How to see who deletes datamodel/report in catalog? Content (please ensure you mask any confidential information): A datamodel is missing under analytics/catalo…Stefano_Mazzocca 1 view 1 comment 0 points Most recent by Dhilip Kumar P. Reporting and Analytics for HCM
-
Query to fetch all the workflow transaction in HCMSummary: Team, can someone please share me the query to fetch all the transactions recorded in HCM Cloud(Transaction Console), I tried to query from fa_fusion_soainfra.w…Satyanarayana M-Oracle 4.6K views 7 comments 0 points Most recent by AnnaMorelli Reporting and Analytics for HCM
-
Withdrawn Renewal Course Record Not Returning to No Active OfferingIssue: Renewal record changed to status Withdrawn as the Learner had a position movement, and the new position was not initially listed on the OTBI Learning Analysis Rep… -
Need help for Tables / query used in Standard "Distribution Detail By Account" OTBI ReportSummary: I need to create BI publisher report using sql query same as Standard "Distribution Detail By Account" OTBI Report. Please guide with underlying tables/ query u…
-
In OTBI trying to pull Natural Account preSummary: We are creating OTBI report by combining the subject areas - 1. Payables Invoice - Transaction Real time and 2. Payables Payment Disbursements real time. We are…Mounika P 15 views 1 comment 1 point Most recent by Conor Pewterbaugh Payables, Payments & Cash Management
-
Formula for Days Open in OTBI for Job RequisitionsSummary: I'm creating an OTBI report for Posted Requisitions. Currently I'm using Job Requisition Open Date from the Recruiting - Recruiting Events Real Time and to get …Nicole A. 21 views 1 comment 0 points Most recent by Denis Magnan-Oracle Reporting and Analytics for HCM
-
OTBI report to pull BPFM hierarchySummary: Could you please help in pulling the BPFM Hierarchy using OTBI Content (please ensure you mask any confidential information): Version (include the version you a…Nagarani M 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM