OBIEE Answers
Discussion List
-
SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesSummary SQL script for Roles , Privileges, Inherit roles & Data Security PoliciesContent Trying to built a query to fetch Application Roles, Privileges, Data Security & …Amarnath 5.6K views 17 comments 0 points Most recent by Mostfa Shehata Reporting and Analytics for ERP -
Dyanmic Deep Link in OTBISummary Need to identify mechanis to have dynamic deep links in OTBIContent Hi There, We have developed around 15 reports in OTBI having a deep link embeded in each of t…Sahil Makhiza 467 views 25 comments 0 points Most recent by NeenaS25 Reporting and Analytics for ERP
-
Restricting Person Type LOV on Line Manager Dashboard Without CustomizationWe are currently exploring options to restrict certain values from the Person Type LOV that appears on the Line Manager Dashboard. Since the Person Type Lookup is a syst…Shubham Kadam 11 views 3 comments 0 points Most recent by Shubham Kadam Reporting and Analytics for ERP
-
Add PDF Attachment to Email Bursting MethodSummary I want to attach a specific pdf file as an attachment to emails sent by a bursting methodContent I created a data model that looks at overdue invoices and produc…User_2025-02-06-06-16-56-136 228 views 4 comments 5 points Most recent by BillM Reporting and Analytics for ERP -
Reporting on Payment ApprovalsSummary BI Publisher or OTBI Report to extract Payment ApprovalsContent Hi Community Are there are any BI Publisher or OTBI Reports available to report on Payment Approv…Kunal Daya-175386 180 views 3 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…gabriel kinovisques-163562 1.9K views 7 comments 0 points Most recent by JimCC Reporting and Analytics for ERP
-
Unable to view the Export option while accessing the OTBI report via Performance TileSummary: Hi. I think I have a similar issue to https://community.oracle.com/customerconnect/discussion/561120/unable-to-view-the-export-option-while-accessing-the-otbi-r… -
Ability to create OTBI analysis calling a APISummary: Ability to create OTBI analysis calling a API Content (please ensure you mask any confidential information): Is it possible to invoke a custom API from OTBI to …Jepson Erattuparmbil 22 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…Amarnath 2.3K views 9 comments 1 point Most recent by Praveen Kumar Akkala-Oracle Reporting and Analytics for ERP
-
SQL Query to Extract Accurate Last Login Date for Active Users in Oracle Cloud SCM PlanningDear Oracle Experts, We are seeking assistance in generating a report from the PROD environment that provides a list of all active users across the following Oracle Clou…
-
Need to run the BIP report with one parameter which is having 500k Values .Summary: Hi All, I have a requirement to run the BIP report for 500k records which we will pass as a PARAMETER to the report . Please suggest the ideal way to do it . Is…
-
Tables of ESS/BIP jobs and their parameters in Oracle fusionSummary Please share the tables in which the parameters of the ESS and BIP Jobs submitted are saved.Content Please share the tables in which the ESS and BIP Jobs, and th…
-
Roles and Privelege to access the "Receiving - Purchase Receipts Real Time" subject area dataHello, We’re working on a report that requires access to the "Receiving - Purchase Receipts Real Time" subject area on Oracle fusion. However, some users are unable to a…
-
OTBI Payables Invoices to Subledger joinContent We have a requirement to display Payables Invoices data (Payables Invoices Transactions Real Time) and their corresponding Subledger entries & other Subledger sp…User_2025-02-11-12-16-05-821 116 views 2 comments 3 points Most recent by Roberto de Santos Reporting and Analytics for ERP
-
FTP Files of BI Publisher Report Via Bursting > Defining The Bursting QuerySummary: FTP Files of BI Publisher Report Via Bursting > Defining The Bursting Query Content (required): Hello All, We would like to send a report generated in CSV forma…
-
OTBI Dashboard and Reports for ExpensesSummary An OTBI dashboard with a series of drillable reports for ExpensesContent The attached catalog files can be imported into an ERP Cloud instance to create a dashbo… -
Change Excel Sheet name in BI Publisher TemplateContent Hello, Is it possible to rename the Excel Sheet names of a BI Publisher Template Report [Type xpt] which has default output format as Excel (xlsx) ? I have creat…Nalinee Uppiah 1.2K views 6 comments 1 point Most recent by Shravan S Kumar-Oracle Reporting and Analytics for ERP
-
How can we get the Project information in subject areas 'Fixed Assets - Asset Transactions Real TimeSummary: Hello Team, I am using this subject area to get the asset transactional details. But unfortunately, I am unable to get all the details such as Project informati…Suhitha K-Oracle 21 views 1 comment 0 points Most recent by Nidhi Chhajed Reporting and Analytics for ERP
-
Applying filter to report attribute but keep the rank as unfiltered.I am creating "Rank" function on a calculated measure. It works fine. But when I filter on a column value the rank changes. Is there a way I can apply filter on an attri…Raghu_Nandan 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
Unable to view the Export option while accessing the OTBI report via infoletsSummary Unable to view the Export option while accessing the OTBI report via infoletsContent Hi Guys, I had created the independent OTBI Report with the report links and…SandeepPaspunuri 238 views 6 comments 0 points Most recent by Thiakeswaraa Reporting and Analytics for ERP -
Need PVO details for PER_ROLES_DN? Not able to find one in BICC mapping to Finance/HCM listSummary: I am looking BICC Tag for PER_USER, PER_USER_ROLES , PER_ROLES_DN HAve found following for PER_USER and PER_USER_ROLES and not for PER_ROLES_DN HcmTopModelAnaly…Antony P Patrick -Oracle 101 views 6 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Issue to get PO Lines accounting details from GL sideWe need to retrieve the PO Lines accounting details along with the net balances. But we are unable to obtain the PO Lines accounting details from the GL-level tables. We…Sushan Peiris 73 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
OTBI Report for AP Invoice HoldsSummary Sample OTBI report for ERP Cloud providing a list of AP Invoices on HoldContent Sample OTBI Report for ERP Cloud: AP Invoices on Hold This report provides a list…Andy Gough 1.9K views 17 comments 22 points Most recent by cdreyer.de Reporting and Analytics for ERP
-
Query for Approval DelegationContent Hello, I am looking to build a BIP Report which displays whenever someone has delegated approvals to someone of a lower job level - does anyone know where this i…Elliot Hall-Walker 309 views 3 comments 1 point Most recent by Gopi Krishna Pokuru Reporting and Analytics for ERP
-
How to show 0 value instead of null value in a calculated formula column in OTBI report?Summary: How to show zero value instead of null value in a calculated formula column in OTBI report Content (required): I have a column 'Variance' which has value that i…Abhishek Shukla 1.1K views 6 comments 0 points Most recent by Pooja_hb-Oracle Reporting and Analytics for ERP -
Need PVO details for PER_USER and PER_USER_HISTORY?Summary: I am looking BICC Tag for PER_USER, PER_USER_HISTORY I've found "HcmTopModelAnalyticsGlobalAM.UserAM.UserPVO" this PVO has history id so I assume this is for PE…RameshBabuJambula 43 views 3 comments 1 point Most recent by RameshBabuJambula Reporting and Analytics for ERP
-
BI query as list of values for a dashboard promptHello, We have a request to create a prompt with the names of employees based on a given job title. To access the data in the subject area "Security - Roles and Privileg…Varun Dhondea 52 views 5 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
Group Project Tasks by Task NameSummary Group Project Tasks by Task NameContent We have a standardized work breakdown structure and would like to compare costs for the same task across projects, right …Prasanna Reka-OC 38 views 1 comment 0 points Most recent by Cindi Jacobsen Reporting and Analytics for ERP -
In Event Triggers: Alternative solution for passing multiple values into a single parameterIn event triggers, I need to pass a multiple values to a single parameter and upon research I realized that oracle does not provide such feature. I need a alternative so…navya Nallamotu 11 views 1 comment 0 points Most recent by Cristian Bilibou-Oracle Reporting and Analytics for ERP
-
R13 Financials OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Financials OTBI subject areas to database lineage mapping and subject area security. Content This spreadsheet is published by Orac…Noelle Bartlam-Oracle 33.4K views 92 comments 55 points Most recent by JL-JL Reporting and Analytics for ERP