OTBI
Discussion List
-
CRM Interactions Message ContentSummary: Very excited to see the enhancement to the CRM - CRM Interactions Real Time subject area in the 26A update. I can now see the subject and message content in OTB…Amanda McAfee 11 views 7 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Case Management Reports / DashboardsSummary: Hello All, We would appreciate the community’s support in sharing or pointing us to any existing or delivered case management or HelpDesk reports or dashboards …Chandramouli Yangareddy 81 views 7 comments 0 points Most recent by Angel Jimenez-Support-Oracle Reporting & Analytics for Fusion Service
-
On hand quantity with null is not appearing on the OTBI pageHi Community Need help on below - @Yann Consolin-Oracle @Lynn Warneka-Oracle @Adnan Siddiqui-Oracle@Shyam Patel @Victor Martin In OTBI (subject area: Inventory Balance R…
-
Issue With Notification Templates - Logo Breaks Approve, Reject, and Request Info ButtonsSummary: Editing the Logo in the Workflow Notification Subtemplate referenced in other notification reports e.g. Journal Approval Notification Report causes the approve/…Matthew - Town of Aurora 11 views 2 comments 0 points Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP
-
What table to query for Individual Balance adjustments in PayrollSummary: Hi, I am looking for the table in OTBI that can be used to query any manually keyed Individual Balance Adjustments. If anyone has an SQL, it would also be great…Bonnie Lafferty 371 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
Oracle Recruiting Cloud – Talent and Candidate Pool (Pool entry date)Summary: Hi Experts, We urgently need Global Talent Pool and Candidate Pools reporting in Oracle Recruiting Cloud (ORC) to meet business demands. I would appreciate clar…
-
EBSR12 : Purchasing columns mapping issueSummary: Trying to map EBSR12 Purchase tables »Fusion Cloud (PO/POR) EBSR12 EBSR12-Column Name po_cwk_associations status po_headers_all closed_code org_id po_line_locat…
-
R12Table/HCM/FND & AP Approvals mapping issueSummary: How it is mapped on oracle fusion Cloud R12Table/HCM/FND : wf_item_activity_statuses Columns: CTIVITY_STATUS ASSIGNED_USER BEGIN_DATE END_DATE & R12TABLE: AP_in…
-
Can we report on when Learning and Evaluations are accessed?Summary: We are thinking about using the Oracle Mobile App, can we report on when Learning and Evaluations are accessed in OTBI? Content (please ensure you mask any conf… -
TRC Code in Time cardsSummary: Can you please suggest how to get the TRC codes associated with the time card and the identifier field.Pratyusha Koduri 21 views 0 comments 0 points Most recent by Pratyusha Koduri Reporting and Analytics for HCM
-
OTBI To fetch the Requisition NumbersSummary: I have a requirement to fetch the Recruitment Number & Recruiter Full Name . The Subject Areas used ( Individually) 1. Recruiting - Recruiting Real Time 2. Recr…Mohammed Ehteshamuddin 1 view 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Can we restrict jobs based upon roles?Summary: Hi Team, We are looking for a possible solution which might help us to satisfy the below requirement Step 1: A Custom roles to be created and assigned to a user…Dileep Varanasi 92 views 4 comments 0 points Most recent by Aniket S C Reporting and Analytics for ERP
-
AR Invoice Transaction Descriptive field - Date Type - Date - Table column not showing in the LOVHi Subject: DFF “Column Assignment – Date” LOV is empty on Invoice Transaction Summary: While configuring a Descriptive Flex field (DFF) on the Invoice Transaction objec…
-
customize a seeded dashboard with otbiSummary: I want to add three parameters in trial balance report which is a seeded dashboard I have customized it but not able to add the parameters that are cost center …
-
Encountering below error while adding Segment Description columns.Summary: Encountering below error while adding Segment Description columns. State: HY000. Code: 77031. [nQSError: 77031] Error occurs while calling remote service ADFSer…Gangadhara S Ariga 23 views 0 comments 0 points Most recent by Gangadhara S Ariga Reporting and Analytics for ERP
-
HCM OTBI subject areas to database lineage mapping spreadsheetThis spreadsheet documents HCM OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Oracle OTBI Development…Raghavendra Raghunath-Oracle 47.6K views 197 comments 128 points Most recent by Kalyankar Tota-Oracle Reporting and Analytics for HCM -
Procurement - Procure To Pay Real Time subject area: No data showing for Invoice MeasuresSummary: No data is coming for Invoice Measures for few users. Content (please ensure you mask any confidential information): Hi, OTBI report has been built using "Procu…Malleswara_Rao_P 21 views 2 comments 0 points Most recent by Malleswara_Rao_P Reporting and Analytics for ERP
-
Need to find a Learning OTBI subject Area for Audience Occurrence ColumnSummary: Hi Team, I need the assistance to get the "audience occurrence" column in Learning OTBI subject Area. we have tried the below subject areas but we are unable to…
-
MSC_SYSTEM_ITEMS table missing in BICC PVOHi CCC, I have a requirement to extract the MSC_SYSTEM_ITEMS table from BICC PVO. But, when I browsed through the BICC PVO documentation, I couldn't find it. Am I missin…VishnupriyaSelvakumar 1 view 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration
-
GL Transaction - OTBISummary: We are exploring an OTBI alternative, or reviewing the limitations within the subject areas, as a result of ongoing issues with the current report in BI publish…
-
The Payee Email Address is always appearing as blank in the OTBI report for onetime PaymentOrganization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of): Description (Required): We would like…NarasimhaPalla 1 view 0 comments 1 point Most recent by NarasimhaPalla Payables, Payments & Cash Management
-
Guided Journey - Analystic Report how to filter a columnSummary: We want to have a Supplier Active Report with product and service category. The report is big, and we want to see an option to include the prompt, or be able to…diego m schenquerman 1 view 0 comments 0 points Most recent by diego m schenquerman Visual Builder Studio
-
Categories in Assign rules not shown in OTBI reportSummary: I am using OTBI to extract the list of assignment rules, that are used to assign SRs to the correct queue. I want to have the list of categories that are includ…Alessandra Ippedico-Oracle 11 views 0 comments 0 points Most recent by Alessandra Ippedico-Oracle Reporting & Analytics for Fusion Service -
Country of Origin values are not appearing on the OTBI pageHi Community Need help on below - @Yann Consolin-Oracle @Lynn Warneka-Oracle @Adnan Siddiqui-Oracle@Shyam Patel @Victor Martin In the Country of Origin field, the values…
-
Physical Inventory Adjustment ReportSummary: Physical Inventory Adjustment Report Content (please ensure you mask any confidential information): Is there any Seeded report to view the adjustment made durin… -
We are unable to create OTBI report for "Physical Inventory Adjustments" Pending Adjustment statusSummary: As per the user’s request, they require a report for “Approve Physical Inventory Adjustments” that identifies the items that were rejected. User reviewed OTBI (…
-
Derived Standard Working Hours - SQLHi all, we're looking to add the following field to a SQL built report using BIP. 'Derived Standard Working Hours' (we can see this in Work Relationship - Assignment Det…MikeW 1.6K views 12 comments 0 points Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM
-
Why are expenses in my OTBI report multiplied?Summary: I'm trying to build a report in OTBI that details the status of corporate card transactions. We would like to see what transactions have not been placed on an e… -
Process Imported Shifts log file SQL queryHi Team, We are using the REST API to load shift data and running the Process Imported Shifts job to process the imported records. We would like to understand which data…Nalsoft Pvt Ltd 31 views 2 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM