OTBI
Discussion List
-
I have created an OTBI report in which customer name is promptSummary: I have created an OTBI report in which customer name is prompt but the LOV contains all the parties instead of customer only How to restrict that LOV? Content (…Muhammad_Saad 1 view 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Business Unit Name not showing results in OTBI reportWhen creating a report for user groups via analysis report, the business unit name is not showing results. When I run the report without business unit, it works fine. Do… -
How to display Header and line groups in EXCEL Template, line has two groups@Kevin M-Oracle I have 3 groups in xml , G_3 is master , and G_1 & G_2 are in line. G_2 =Sheet1!$A$16:$N$16 G_1 =Sheet1!$O$16:$R$16 G_3 =Sheet1!$A$2:$R$16 While I add G_…Dineshkumar.A-Oracle 21 views 1 comment 0 points Most recent by Lori W-Support-Oracle Reporting & Analytics for Fusion Service -
How to set dashboard prompt where user selects name, but variable is set for person_Id?Summary: Hi team, I am seeking some assistance building an OTBI dashboard prompt. I am wanting to present the display name to the user, but when they select it I want to…Luke.Findex 21 views 1 comment 0 points Most recent by Julian Challenger-Oracle Reporting and Analytics for HCM -
Find duplicate customer/org. tax registration numbers ReportSummary: I need to create a datamodel with SQL so I can create reports that helps me find customer/org. duplicate registration number (TAX) So I can see what customers I… -
How to include historic versions of org tree in OTBI workforce trend analysis?Summary Analysis containing HC summaries spanning years does not accurately reflect earlier org tree versionsContent Subject Areas: * Workforce Management - Workforce Tr…James Hoffmann 52 views 8 comments 0 points Most recent by Claudia Linares L Reporting and Analytics for HCM
-
Our customer needs to identify the report path in OTBI related to an Infolet.Our customer needs to identify the report path in OTBI related to an Infolet. Please see the attached document (Infolet-OTBI.docx and HELP-OTBI-PATH.docx) attached here.…Oscar Chahestian-Oracle 1 view 0 comments 0 points Started by Oscar Chahestian-Oracle Reporting and Analytics for ERP
-
Need a query to link the Import costs process id with load interface id is passed as parameterHi Team, I am working on a query which is consuming by dell Bhoomi integration platform to the status of the ESS Job. So they are passing the load_request_id (the proces…
-
How to fetch Goals Target outcomes in OTBIHi All, How to fetch Goals Target outcomes in OTBI? Thanks in advance.Robinson Ng 1 view 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Fusion Service
-
Project Period Close Exceptions DashboardSummary Project Period Close Exceptions DashboardContent Project Period Close Exceptions Dashboard - Anybody created as shown in release document. Attached screenshot -
View PDF PO ErrorSummary: Cannot view PDF for specific PO Content (please ensure you mask any confidential information): Hi I cannot view PDF for specific PO. These PO status Open or Inc…
-
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 51 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 61 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 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 21 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 25 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 47 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 121 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 12 views 1 comment 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Fusion Service