OTBI
Discussion List
-
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 3 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 46.2K 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 14 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 2 views 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 3 views 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 14 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 (…
-
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.6K 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 6.2K 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 34 views 2 comments 0 points Most recent by Nalsoft Pvt Ltd Reporting and Analytics for HCM
-
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 11 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 15 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)…Shatha Bin-Nooh 23 views 0 comments 0 points Most recent by Shatha Bin-Nooh Receivables & Collections -
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 4 views 1 comment 0 points Most recent by Gail Langendorf-Oracle Reporting and Analytics for HCM