OTBI
Discussion List
-
Project Period Close Exceptions DashboardSummary Project Period Close Exceptions DashboardContent Project Period Close Exceptions Dashboard - Anybody created as shown in release document. Attached screenshot -
Report combining Subject areas Project Costing - Actual Costs and Project Costing - CommitmentsHi, Has anyone created an OTBI report that lists all costs related to a specific project and the tasks designated to that project? I was able to get almost all the field… -
How to use 2 subject areas in same formulaSummary: Using Analysis Report type, is it possible to have data from both subject areas in the same formula? Content (please ensure you mask any confidential informatio…Justine Klemetson 16 views 2 comments 0 points Most recent by Yves_Guyon-Oracle Reporting and Analytics for ERP -
Create custom notification with Agents in OTBISummary: We are looking to create custom notifications utilizing Agents in OTBI. We have specific use cases where we need users to receive notifications (i.e. project co…
-
difference balances xla_ae_lines and xla_ac_balancesSummary: We created an OTBI report in the "Subledger Accounting - Supporting Reference Real Time" subject area, and it doesn't contain a value for a supporting reference…
-
How to calculate EOD balance for the last day of Previous month based on accounting date in OTBII'm trying to calculate the End of the day balance for the last day of previous month based on accounting date which I'm passing as a parameter in the OTBI Analysis. Sub…Sri Sai Kiran Tekumudi 46 views 2 comments 0 points Most recent by Sri Sai Kiran Tekumudi Reporting and Analytics for ERP
-
Need Sample and Confirmation of AnalysisSummary: Hi We have requirement to create analysis of procure to pay process (PR-PO-Receipt-Invoice-Payment). We need your help to give sample how to create analysis wit…
-
Fusion BI Report Time zone issues in report output related queriesOur users are in PST Timezone and has raised concerns about report outputs being in UTC Timezone. We are trying to update report code and wanted to clarify few queries b…Abhilash K - Deloitte USI 415 views 8 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
How to hide "set ownership of this item" from properties option in Report and Analytics ?We have a requirement where business is asking to hide "set ownership of this item" for users with specific roles. we tried to hide from "Manage Privileges" but some how…
-
In OTBI the table view window presented is too small. How to resizeSummary In OTBI the table view window presented is too small. How to resizeContent In OTBI the table view window presented is too small. How do I resize this preview win…User_2025-02-05-22-11-22-331 914 views 6 comments 4 points Most recent by otavio.teixeira Reporting and Analytics for ERP -
Question about Infolet on ERPHi Team, Our client is currently undergoing a process to revalidate user privileges. During this process, we observed that simply accessing the pages and viewing the Inf…Oscar Chahestian-Oracle 25 views 4 comments 0 points Most recent by Oscar Chahestian-Oracle Reporting and Analytics for ERP
-
How to default a Prompts selection in OTBI dashboard from Lookup code based on logged in UsernameWould like to reach out to you on how to set the default value of a Prompt with a value from lookup code which is related to the logged in User name. We have an Analysis…Dinesh R 1 view 1 comment 0 points Most recent by Shradhanjali_Oracle-Oracle Reporting and Analytics for ERP
-
Is it possible to split a concatenated segment (accounting combination) in an OTBI reportSummary: I am trying to split the concatenated accounting combination into different columns, each column should be displaying a segment separately Content (please ensur…Eva Mirzoyan 100 views 5 comments 0 points Most recent by Rich Merkel Reporting and Analytics for ERP -
Plsql procedure from a Saas Report or Saas page?Summary: Invoking pl-sql procedure from SaaS Report or through a SaaS link on a page Content (please ensure you mask any confidential information): We haven't OIC. We'd …Luca Nobili PWC 21 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to customize standard OTBI ReportSummary: How to customize standard OTBI Report Content (please ensure you mask any confidential information): I need to customize one of the standard OTBI reports in Fus…
-
Cost Center from subject area "Payables Invoices - Transactions Real Time"Content Hi. I'm struggling to figure out how to find the field, where I can see the cost center, outside the concatenated segment... Whenever I use the Cost center descr…Anders W. Langholm 79 views 13 comments 0 points Most recent by Piyush_Sinha Reporting and Analytics for ERP -
Otbi report to compare budget revenue, baseline cost to project funded amountI am triying to create a report to ocmpare project planned cost, budget revenue against the funded amount in contracts module by combining Project Finacial plan with Pro…
-
How to save an OTBI report into Reports and Analystics Favorites of Job Managers role in ERPI have developed some OTBI and BIP reports and I would like to centrally save this report in the Reports and Analystics Favorites for list of users / role. (Instead of e…
-
Disability CategorySummary: We are building a report that displays a summary of Disability Categories Specifically the "Workforce Management - Person Real Time" subject area - Person Disab…
-
How to hide parameters in scheduled process ?Hi, we want to hide some parameters that we don't populate in a scheduled process. For example, we want to hide source locator and destination locator from "Print moveme…Daniele Landinetti 3 views 0 comments 1 point Started by Daniele Landinetti Reporting and Analytics for ERP
-
OTBI Custom Report Scheduling -- Date Parameter IncrementSummary How to increment date parameter to run with sysdate for Scheduled OTBI reportContent OTBI Custom Report has PO Date which is a parameter with in between operator…User_2025-01-28-17-34-41-546 554 views 2 comments 1 point Most recent by Shyam Patel Reporting and Analytics for ERP
-
How to schedule BIP report with increment date and timestamp?Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Lalit Sinkar 114 views 4 comments 0 points Most recent by Shyam Patel 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 182 views 3 comments 0 points Most recent by Marko Puskac Reporting and Analytics for ERP
-
SQL query or oracle table names to extract the actual values of supplier change request detailsHi, Business requirement is to see the actual values that got changed on all of those tabs under supplier i.e. organization details/Addresses/Banking/Business Classifica…
-
OTBI - can we apply case condition on columns from different subject areas ?Summary: CASE WHEN SA1.COl1 = 'Y' THEN SA1.COL2. ELSE SA2.COL1 END ; The above is not working as expected. Does OTBI supports CASE condition on multiple subject areas or…Sridhar Gupta Yerram-Oracle 14 views 2 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to create dependent Parameters in OTBI (Oracle Fusion ERP)?Summary: How to create dependent Parameters in OTBI (Oracle Fusion ERP)?Sridhar Gupta Yerram-Oracle 2 views 1 comment 0 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Why Fusion and OTBI report gives different Validation StatusIn OTBI I use the MATCH_STATUS_FLAG from AP_INVOICE_DISTRIBUTIONS_ALL to get the validation status. A - Validated Null - Never / Not Validated T - Needs Revalidation Is …Alvin 14 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
MOT_REF_ENTITIES custom object table not pulling dataSummary: There is a OTBI report built using custom object subject area whose dimension and fact tables are populated with data thorugh some integration reports through s…
-
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