OTBI
Discussion List
-
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 19 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 43 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 12 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 350 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM -
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…Venkatesan vs 18 views 2 comments 0 points Most recent by Abhilash K - Deloitte USI Receivables & Collections -
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… -
GL Analytics dashboard in OTBIHas anyone created a GL analytics dashboard that they are wanting to share? I am trying to create a dashboard that gives our finance department/CFO all the information w… -
Is there a way to trigger an atom feed event when using spreadsheet loader?Summary: When we do position updates via Spreadsheet loader, there doesn't seem to be an atom feed event triggered. Is there a way to achieve that? Content (please ensur…Stella Kaszab 7 views 2 comments 0 points Most recent by Stella Kaszab Reporting and Analytics for HCM -
Table to use to get the project and task details under Supply and PlanningHi, We have created a SQL query to get some details under the Supply and Planning. We are almost done but we get stuck on the project and task column. We already checked…Rohan Gonsalves 3 views 1 comment 0 points Most recent by Manikandan S R-Support Oracle-Oracle Costing -
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… -
Table : Table : ZX_LINES (EBSR12 TABLE) -line_number (column) how it is mapped in fusion cloudSummary: Table : ZX_LINES (EBSR12 TABLE) -line_number (column) how it is mapped in fusion cloud Content (please ensure you mask any confidential information): Version (i… -
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. -
Person Number column is blank when creating an analysis using Project Costing Subject AreaSummary: Wehave created a report using the Project Costing Actual Costs Real Time subjectarea. In that report we have selected the Person Number and Person Name fields,b…anandg465_cshs 2 views 2 comments 0 points Most recent by anandg465_cshs Reporting and Analytics for ERP -
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 7 views 1 comment 0 points Most recent by Abhishek Premchandra Reporting and Analytics for HCM -
Reporting on SCORM & HACP Learner Interactions in Oracle LearningSummary: Learning departments often want to understand how learners are responding to questions included in their SCORM-based courses, to assess whether there are proble… -
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 73 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 7 views 0 comments 0 points Started by Gangadhara S Ariga Reporting and Analytics for ERP -
Feasibility check: OTBI report for supplier registration resubmissionsSummary: Hi Team, We received a customer requirement to understand which suppliers have the most difficulty during the supplier registration process, along with their vo… -
Unable to identify the Pick slip status and quantity exception values in the backend tablesSummary: Hi CCC, I was trying to identify the Pick slip status - Open / Confirmed and quantity exception reason in case of short pick from the backend tables. I couldn't…VishnupriyaSelvakumar 1 view 0 comments 0 points Started by VishnupriyaSelvakumar Supply Chain Planning and Collaboration -
Requistion Approval email data model does not retrive details using (Requistion ID) parameterSummary: I want to customize requistion approval email notification, data model does not retrieve the requistion details in case to export sample data Content (please en… -
Recurring Learning Assignment subject area in analysis reportSummary: Hi, Post 26A upgrae Learning Assignment got upgraded to redwood. Now as per the Oracle doc Learning initiative got replaced with Assignment profile.In assignmen… -
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 45.7K views 197 comments 126 points Most recent by Kalyankar Tota-Oracle Reporting and Analytics for HCM -
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…Ernesto Hassan Lopez 11 views 0 comments 0 points Started by Ernesto Hassan Lopez Project Management