OTBI
Discussion List
-
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 122 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 Most recent 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.8K 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 11 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
-
List of all Agents created in OTBISummary Ability to report on scheduled AGENTS - Listing of Agent, Report Recipient and Frequency (schedule)Content The Payroll/HR department is lookin for a report that …Raz Baboorian 845 views 10 comments 0 points Most recent by B S Aravind Rao-Oracle Reporting and Analytics for HCM
-
Emergency contact OTBI analysisHi Guys i am trying to create an OTBI to show employees with emergency contacts and the contact details of them too. I have tried using the subject area 'Workforce Manag…Jeevan Loyal 31 views 6 comments 0 points Most recent by Jeevan Loyal Reporting and Analytics for HCM
-
OTBI Report on Seniority Rule ValuesSummary: Can we report on the values associated with a given seniority date rule using OTBI? Content (please ensure you mask any confidential information): I'd like to c…Monique 11 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM
-
Work Order material consumption across task in Project based SCM ManufacturingSummary: Requirement to consume items on Work order from different task apart from the Work Order task . (WO header task : Project A task 1, inventory available under Pr…Mohit Sahni - Mastek 11 views 3 comments 0 points Most recent by Prasanth Senthivel-Oracle Manufacturing
-
difference balances xla_ae_lines and xla_ac_balancesSummary: We created an OTBI report in the "Subledger Accounting - Supporting Reference Real Time" subject area, and it doesn't contain a value for a supporting reference…
-
OTBI RSSP Receipt NotesSummary: We need to be able to provide information to AP regarding RSSP receipts via an OTBI report. We want to add the notes in the Receipt Details screen Notes field a…Robert G Wilkinson 1 view 0 comments 0 points Most recent by Robert G Wilkinson Inventory Management
-
Access to Expense Transactions Real Time Subject Area for Employees and ManagersHi, I wanted to assign secured access to Oracle Fusion Expense Transactions Real Time subject area for Managers and Employees. Following is the requirement: 1. Managers … -
How to embed BIP report in OTBI dashboard with Date Prompt/parameter?Summary Provides guidelines for embedding BIP report in an OTBI dashboard and use a date parameterContent Steps: 1. Create dashboard column prompt with a date column and…Anil Kola-Oracle 2.4K views 5 comments 9 points Most recent by User_FCP05 Reporting and Analytics for HCM
-
Employment Contract Real Time Subject Area Not Returning any recordsSummary: Employment contract Real time subject area not returing any value when a column from "Employment Contract Details" is added. Content (please ensure you mask any…Samir Patro 21 views 9 comments 0 points Most recent by Keerthi Chinthapatla Reporting and Analytics for HCM
-
How to calculate EOD balance for the last day of Previous month based on accounting date in OTBII'm trying to calculate the End of the day balance for the last day of previous month based on accounting date which I'm passing as a parameter in the OTBI Analysis. Sub…Sri Sai Kiran Tekumudi 61 views 2 comments 0 points Most recent by Sri Sai Kiran Tekumudi Reporting and Analytics for ERP