OBIEE Answers
Discussion List
-
Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to FuContent Supplier Profile syntax has been excluded from the most recent version of the "ERP OTBI Report to Fusion App Drill-Down Actions" white paper (which had most rece…User_2025-01-28-16-10-52-033 25 views 1 comment 3 points Most recent by User_2025-02-06-21-15-08-830 Reporting and Analytics for ERP -
Due Date Calculation Formula based on Terms Date and Terms Name in OTBI ReportSummary Looking for a formula to derive Due Date based on Terms Date and Terms Name in OTBI RepoertContent Hi All, I have a requirement to derive Invoice Due Date based … -
What is the risk of copy any seeded report, add two columns on a table already in the data model, keSummary What is the risk of copy any seeded report, add two columns on a table already in the data model, keeping in the custom folder with a new name and new ESS Job on…Sam Samaddar 47 views 4 comments 1 point Most recent by Sam Samaddar Reporting and Analytics for ERP
-
How to display data of a column horizontally in RTF?Content Hi all, I have a requirement where I need to display some data that comes from a column horizontally on RTF.Hereby, I'm attaching a screenshot of the RTF and wha…Sushan Peiris 367 views 7 comments 2 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP -
Query to check if an invoice have a prepayment included or notContent Hi all, I want a query that can provide me with a flag whether an invoice has an applied prepayment or not. I checked if a flag is available in the invoice table…Sushan Peiris 64 views 3 comments 2 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…Swapnil Kashid 73 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Need a query to get Period name for asset addition transactions in FA in ORACLE FUSIONContent Hi all, Can someone provide me with a query in which I can take the period name relevant to the asset addition transaction? I want to get the name of the period …Sushan Peiris 1.1K views 3 comments 3 points Most recent by User_2025-03-07-05-10-47-928 Reporting and Analytics for ERP
-
Need a query to derive current cost, Netbook value in Oracle Fusion Fixed assets module with the peContent Hello all, I need a query that gives me the current cost and the netbook value for a specific asset within a period range. Need a parameter too to run the query.…Sushan Peiris 1.8K views 7 comments 3 points Most recent by Sushan Peiris Reporting and Analytics for ERP
-
Convert OTBI analysis / report to BI Publisher reportSummary Convert OTBI analysis / report to BI Publisher reportContent At our company the OTBI reports are running slow and long. I am tasked to convert OTBI analysis / re…User_5F4G3 494 views 10 comments 0 points Most recent by User_2025-02-11-18-46-39-346 Reporting and Analytics for ERP
-
Struggling to Find Expense Report Line DetailsSummary Can't Find Receipt Date and Number of Days in "Expenses - Expense Transactions Real Time"Content We are seeking the following fields for Expense Report Items: -R… -
Selecting multiple column headers for styling in OTBI analysisContent Hello all, May I know, if there is an option to select all the column headers and apply a certain style rather than selecting each and every column and applying …
-
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 226 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
BI Publisher report should send email with Digital signatures in email body.Summary We have a business requirement to digitally sign the email while transmitting transaction prints to customers. Basically, the email body needs to have the digita…User_85V95 42 views 4 comments 2 points Most recent by Skolli-Oracle Reporting and Analytics for ERP
-
Configuring Key Flexfield Segments in Oracle Financials Cloud to leverage OTBI for ad-hoc analysesSummary Configuration Steps to enable OTBI reporting of Key Flexfields (KFF's) in GL, Budgetary Control and Fixed Assets (Rel 11)Content To report on Key Flexfield Segme…Anand DN-Oracle 1.7K views 8 comments 12 points Most recent by Chris Lynch - AST Reporting and Analytics for ERP
-
Budget balances not available in General Ledger subject areasSummary Can we query budget balances in General Ledger subject areas?Content Budget balances not available in General Ledger subject areas like 'General Ledger - Balance… -
Missing account coding data for Invoices in Workflow tables in PRODContent Hello, We have a custom BI report that tracks the Account coding details for AP Invoices. We are using the workflow tables to get these details. Per my understan…Shruthi Ramesh 60 views 3 comments 1 point Most recent by Nishanth B Jain Reporting and Analytics for ERP -
OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject ArContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". The analysis has a column "Time"."Accounting Period Name" OR "Time"…
-
Inventory Reconciliation with GL - ReportContent All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requi…Hari Thyagaraj 49 views 2 comments 0 points Most recent by Ahmed Eldemerdash Reporting and Analytics for ERP
-
Unable to preview BI Publisher output in RTF:Summary Unable to preview BI Publisher output in RTF:Content Hi Guru, I am facing one strange issue in BIP Desktop , i am able to load and design the RTF but when i am t…Rohit Soni-259808 683 views 6 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subjSummary Extract Cost Center from "Code Combination Descpription" fieldContent I am using "Code Combination Description" field as one of my select columns from (Procureme…UjasB 232 views 5 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
Tables to query files imported to ERPSummary We want to create a report that list the files imported to the ERP from external systems for reconciliation purposes.Content Hello evryone, Anyone can hep me to …User_B9AX9 69 views 1 comment 0 points Most recent by Christian Guidibi Reporting and Analytics for ERP
-
Updating non-logical OTBI to Logical SQL OTBI without rebuilding?Summary Updating non-logical OTBI to Logical SQL OTBI without rebuilding the original OTBI?Content I need to update an existing OTBI (non-Logical SQL) to use Logical SQL…User_BUU5W 38 views 3 comments 0 points Most recent by Andrew_Schmitz Reporting and Analytics for ERP
-
Depreciation reserve of assetContent We're building a Fixed Asset Balances report out of Subject area Fixed Asset Balances - Real Time'. But we are not able to get the balances for Accumulated Depre…JL-JL 65 views 1 comment 0 points Most recent by Greg Jonovich-Oracle Reporting and Analytics for ERP
-
Power BI and OBIEESummary How to create a connection between Oracle Cloud (FIN and/or SCM)?Content Hello, we would like to start using Microsoft Power BI for BI Reporting, instead of OTBI…User_2025-01-30-21-34-16-665 137 views 8 comments 6 points Most recent by Tessy Reporting and Analytics for ERP
-
R13.18A OTBI BI Catalog LockdownSummary With 13.18A release customers will no longer be able to modify the shipped BI catalog content.Content R13.18A OTBI Product Alert This product alert is published …User720640-Oracle 383 views 8 comments 14 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP -
Raw data extraction from Oracle Fusion to Datalake/SFTP serverSummary Exporting data from Oracle Fusion to SFTP Server - Unable to handle systematic deletesContent Hi All, We have a requirement where we need to push raw data into a…Kalyan Reddy 47 views 1 comment 0 points Most recent by User_2025-01-28-08-43-27-760 Reporting and Analytics for ERP
-
How to create custom OTBI Subject Areas in Oracle CloudSummary How to create custom OTBI Subject Areas in Oracle CloudContent Hi Experts, My client is Oracle cloud 20 C. My client have non oracle application that contain pro…User_2025-02-10-14-23-02-910 161 views 5 comments 1 point Most recent by Anca A-Oracle Reporting and Analytics for ERP
-
Using Task Number instead of Task IDSummary I want to use Task Number as a Prompt but when i am searching with task number. system search with task IDContent Hi, I am using Task Number value in a Prompt. M…User_2025-02-05-02-38-04-251 25 views 1 comment 0 points Most recent by Rich Merkel Reporting and Analytics for ERP
-
How to restrict Data Model options to avoid users to access directly to the tables (SQL Query)?Summary Power users and contracts need to create data models based on BI Analysis, but this will also give them access to run SQL Queries. We want to restrict SQL Query … -
Project Number is still seeing wrongSummary I changed project number in the system. I am seeing old number for the project in analyticsContent Hi Dear All, We are using an Analytics using Procurement - Pur…User_2025-02-05-02-38-04-251 46 views 1 comment 0 points Most recent by User_2025-02-05-02-38-04-251 Reporting and Analytics for ERP