OTBI
Discussion List
-
Expenditure Type Details for OTL Timecards not traceable in BIP Reports.We are trying to extract timecard details for employees in BIP Report with major components as timecard measures, project, task and expenditure type. We are able to abst… -
AR Invoice Email Delivery with AttachmentHi I am attempting to send an Accounts Receivable (AR) invoice with an attachment to a customer via email. I followed all the steps outlined in Document ID: KB92757, and…
-
How to capture Tax Classification Code at Supplier Address level in OTBI report.Hello Experts, we want to capture the Tax Classification Code at Supplier Address level using an OTBI report. We are checking on Supplier Real Time subject area. Is ther…
-
Learning Outcomes Skills in OTBII am trying to create an OTBI report that retrieves the skills associated with learning items. Within the Workforce Learning - Learning Management subject area, there is… -
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 61 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 361 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.
-
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 72 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 1 view 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 46.7K views 197 comments 126 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
-
SQL to fetch learning catalog profileSummary: In which database table(s) can I find the learning catalog profile ID and learning catalog profile number Content : Background information: In version 25D Oracl… -
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