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…Ernesto Hassan Lopez 11 views 0 comments 0 points Started by Ernesto Hassan Lopez Project Management -
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 4 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 7 views 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 6 views 0 comments 1 point Started 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 6 views 0 comments 0 points Started by diego m schenquerman Visual Builder Studio
-
Need Guidance on Mapping Employee Numbers in OTBI Expense-to-Payables ReportingSummary: We have developed an OTBI report using the Payables subject area to retrieve invoices imported from Expenses and to track the payment status of those expense-re…Sai Ambareesh D 6 views 2 comments 0 points Most recent by saurabh.dixit Reporting and Analytics for HCM
-
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 6 views 0 comments 0 points Started 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 (…
-
How to Fetch the PO Revised Amount in oracle fusionSummary: Hi Kindly Suggest the tables or provide any sample query to fetch the PO Revised Amount in Oracle Fusion Content (please ensure you mask any confidential inform…
-
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.5K views 12 comments 0 points Most recent by Kuldipsinh Rajput Reporting and Analytics for HCM
-
OTBI Learning Records Real Time Subject Area: Example reportshttps://community.oracle.com/customerconnect/discussion/647682/learning-records-subject-area Summary: Workforce Learning - Learning Records Real Time Subject Area Provid…Abdul Rauf Mohammad-Oracle 6K views 55 comments 21 points Most recent by Jamie Rancourt-Oracle Learning
-
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 21 views 2 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
OTBI Dashboard Prompt Not Filtering Correctly When Mixing Person and Assignment Subject AreasSummary: OTBI Dashboard Prompt Not Filtering Correctly When Mixing Person and Assignment Subject Areas Content (please ensure you mask any confidential information): We …Jeeva - Cloud Vantage 11 views 0 comments 0 points Started by Jeeva - Cloud Vantage Human Capital Management
-
Customize the Organization Chart ReportSummary: Hi All, Can you please helps us with any Sample BI or OTBI Report for Employee Organization Chart Content (please ensure you mask any confidential information):…Vamsi Jeela 13 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Please help to locate the fields in the Subject Area "Inventory - Inventory Transactions Real Time"Please below screenshot, I found there exist a column ‘Transaction Value’ in Subject Area ‘Inventory – Inventory Transactions Real Time’ , I suggest it is the Inventory … -
where can we find the PDF document OTBI_Cross_Subject_Area_Reporting_Guidelines ?Summary: this document is mentioned in few conversations but the link is broken ; Please provide a valid link to the PDF Content (please ensure you mask any confidential…Carmen Marinescu 17 views 2 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
Conditional Syntax or IfElse Syntax for excel template in Oracle Fusion Cloud SCMSummary: How to include condition on any attribute to generate the output in xls template? need correct syntax for Content (please ensure you mask any confidential info…
-
ZATCA verified XML embedded inside PDF/A3Summary: We have a requirement to generate the invoice output in PDF/A-3 format. Specifically, we need to embed a ZATCA verified XML file (generated from another report)… -
Learning records - courses without any enrollmentsSummary: I have just found out that the learning management real time subject area will be deprecated so we need to rebuild our report using the learning records subject…
-
Department Hierarchy data in the "Workforce Learning - Learning Records Real Time" subject areaSummary: we are combining the "Workforce Learning - Learning Records Real Time" and "Workforce Management - Worker Assignment Real Time" subject area's to get the count …Sreekantha M 3 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM
-
Are the Infolets available in the Analytics section be available by default?Summary: Are the Infolets available in the Analytics section of the Oracle Fusion application be available by default or are we required to do configuration to make it a…
-
What is table of Supplier Address Transaction Tax?Content Hi all. I need to know what is name of table that stores datas of Supplier Address Transaction Tax. Manage Supplier - Address Details - Transaction Tax. See atta…