OBIEE Answers
Discussion List
-
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 50 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 329 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 234 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 70 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 40 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… -
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 48 views 1 comment 0 points Most recent by David Pellegrino 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…Rama Pedamallu-249453 165 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…Eren Göktepe-155015 26 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…Eren Göktepe-155015 48 views 1 comment 0 points Most recent by Eren Göktepe-155015 Reporting and Analytics for ERP
-
Different PR - PO Matched in AnalyticsSummary for one pr has multiple po one of them cancelled the other one closed but i saw cancelled one. I cannot reach the closed oneContent Hi Dear All, We had a PR and …Eren Göktepe-155015 16 views 0 comments 0 points Most recent by Eren Göktepe-155015 Reporting and Analytics for ERP
-
R13 Risk Management OTBI subject area to database lineage mapping spreadsheetSummary This spreadsheet documents R13 Risk Management OTBI subject area to database lineage mapping and subject area security. Content This spreadsheet is published by …Noelle Bartlam-Oracle 541 views 8 comments 4 points Most recent by Feras Ahmad Reporting and Analytics for ERP
-
Limit number of lines per pageSummary I have an invoice where I want to limit the number of lines that appears per pageContent Is there an IF statement that could limit the number of lines that appea…Mohammad Alhindawi 53 views 3 comments 0 points Most recent by RichardChan Reporting and Analytics for ERP
-
ce_available_transactions_vSummary Recreate ce_available_transactions_v in OACContent Hello all I'm trying to recreate 'ce_available_transactions_v ' in Oracle Analytics Cloud (either via replicat…Elisa Fernandez 53 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
Analysis is missing the promptsSummary Missing prompt on Expense ReportContent We have a report called 'Expense Type Report' It was created with the 'Analysis' tool. This report has prompts when you g…Jennifer Wolfe 38 views 1 comment 0 points Most recent by Nathan CCC Reporting and Analytics for ERP -
How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tablesNageshwaran1 25 views 3 comments 1 point Most recent by Nageshwaran1 Reporting and Analytics for ERP -
AR Account Profile ClassSummary Linking 2 AR Subject Areas.Content The AR Account Profile Class is not available in the 'Receivables - Payment Schedules Real Time' subject area (19C) and it is …
-
Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersSummary Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersContent Need Logic to create below KPI's for Purchase RequisitionsWe have been trying to c…RAJESH M-226898 77 views 2 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Join between wsh_deliveries and rcv_shipmentsSummary Join between wsh_deliveries and rcv_shipments to fetch shipment_num, invoice no & dateContent Join between wsh_deliveries and rcv_shipments tables to fetch shipm…Nageshwaran1 119 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Syntax help for a BI ReportSummary Need field to display 'All' when nothing is selected, but also need to format this field as a date.Content Hello all. I'm looking for a bit of help with my synta… -
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…
-
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type fieldNageshwaran1 53 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP
-
Report needed for default expense accountSummary Report needed for default expense accountContent Hi I am trying to get a report of all users on oracle and their default expense account on OTBI but cannot find …Doron de Jong-57089 170 views 9 comments 1 point Most recent by Ed Higgins 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 170 views 2 comments 0 points Most recent by Kunal Daya-175386 Reporting and Analytics for ERP