To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Reporting and Analytics for ERP
Discussion List
-
Procurement Procure to Pay Real Time and Invoice Line Amount from Payables Invoices - Transactions RSummary I am combining 2 subject areas Procurement Procure to Pay Real Time and Payables Invoices - Transactions Real Time. I don't get an error but I get an invoice Lin… -
Risk Management Users with Access Violations by Control ReportSummary Lists users that have violated a specified control.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file and pdf example o… -
Risk Management Access Violations within a Single Role (Intra-Role) ReportSummary List of roles, users and conflicting access points with conflicts by control. Only roles that contain violations within itself are listed.Content * Download the …
-
Risk Management Entitlements ReportSummary A listing of entitlements and the access points they are composed of.Content * Download the zip file attached to this post * Unzip and you'll find a catalog file…
-
Audit Concerns - Unknown ESS jobs triggered by System/Delivered IDsSummary Unknown ESS processesContent Hi, 1. Can someone explain what are these processes and where they are being documented ? ESS process to check Search Cloud Service …User_2025-02-05-22-16-49-759 177 views 4 comments 2 points Most recent by Kishore Padala-Support-Oracle -
GL Valueset DFF's are not available in OTBI subject areasSummary GL Valueset DFF's are not available in OTBI subject areasContent I confirmed the context and segments are BI enabled then ran the processes: Create Rules XML Fil…User_2025-02-06-00-15-19-515 52 views 3 comments 2 points Most recent by User_2025-02-06-00-15-19-515
-
BI Publisher Output File NameSummary BI Publisher output file name Suffixes Template/Layout NameContent BI Publisher report output file from Oracle Fusion cloud suffixes the Template/Layout name at … -
otbi reports - how do i find out you last modified report?Summary otbi reports - how do i find out you last modified report?Content otbi reports - how do i find out you last modified report? i only see owner and that is person … -
How to best analyze ESS Job Schedules?Summary How to best analyze ESS Job Schedules?Content We have a basic need which we are struggling to find an answer to: How do we best analyze the jobs from ESS schedul… -
Financial reporting studio report using a custom heading repeats when expandingContent We are using a custom heading with expansion enabled, the member and its children are renamed as well. How can we edit this so that the Custom heading only appea…User_2025-02-06-00-15-19-515 36 views 6 comments 2 points Most recent by User_2025-02-05-07-43-41-391
-
BI Report using Saas and Paas DataSummary How to access Paas Database data from SaasContent Hi, I have a requirement to develop a BI Report in ERP Saas using data from the ERP and also from a custom we'v…
-
Fetch large volume of data in BI publisher reportSummary Fetch large volume of data in BI publisher reportContent HI We have a requirement to extract data for GL code combinations using BI publisher and burst the outpu…
-
Amending SQL slightly brings me: ORA-01427: single-row subquery returns more than one rowSummary ORA-01427Content I am using Oracle Fusion, the finance/payables reporting side of things I have the following code: SELECT DISTINCT PHA.SEGMENT1 FROM AP_INVOICES… -
SQL Table to bring in Audited by from the AP module to a BI reportSummary SQL Table to bring in Audited by from the AP module to a BI reportContent I am searching for the SQL table to bring in Audited by from the AP module to a BI repo…
-
OTBI computed field and graphSummary creating computed field and graphContent Hi all, I am very new to Oracle Fusion business intelligence. Background: * Fusion 19C * try to analyze the company's em…User_2025-02-06-11-24-12-541 39 views 0 comments 2 points Most recent by User_2025-02-06-11-24-12-541
-
Syntax Error While Using Evaluate in OTBI AnalysisSummary Evaluate function generates a syntax error when using REGXP_SUBSTRContent I am attempting to trim the following column in the General Ledger - Journals Real Time…User_2025-02-05-07-37-39-271 55 views 10 comments 2 points Most recent by User_2025-02-05-07-37-39-271
-
XML Structure of BIP reportContent Hi, I need to create a BIP report which is extracted as an XML. Below is the sample xml structure and sample XSD. How do I define an attribute of an element whil…
-
Begin/End Balance for Accumulated depreciation of an AssetSummary Begin/End Balance for Accumulated depreciation of an AssetContent Customer asks: We're building a Fixed Asset Balances report out of Subject area Fixed Asset Bal…
-
How can user hide, add or remove content from Dashboard PagesSummary Dashboard Page seem to allow you to remove content but no way to add the report backContent I am in 19B/R13. Looking at the Payable Dashboard, I can click on x t…Prateek Parasar - GTUK, ACE Pro 28 views 0 comments 2 points Most recent by Prateek Parasar - GTUK, ACE Pro -
Balance Sheet in OTBISummary Balance Sheet in OTBIContent I have a requirement to build out a balance sheet specifically in OTBI. Some folks have recommended using the subject area for Gener…
-
BIP Expense Report ApproverSummary Looking to find the appropriate SQL that will give me the approver name for Expense Reports using BI PublisherContent The goal of this report is to utilize burst…
-
Database table details for content stored in UCMSummary Need to extrat details of UCM content in BIPContent Hi Experts , UCM contents has some properties like comments, owner , account , security group etc. Do we have… -
How to generate and view the trace file for a BIP Report submitted thru ESS Job Scheduler.Summary How to generate and view the trace file for a BIP Report submitted thru ESS Job Scheduler.Content Can anyone guide us on how to generate and view the DB trace fi… -
Parameters Appear Under Data_DS in CSV FormatSummary How to remove the Parameters appearing as fields in CSVContent Hi, We are currently working in a report and the data model is bringing through the fields require…
-
Need Audit tables list in Oracle cloudSummary Enabled Audit feature for Supplier header and supplier sitesContent Hi, Need help in Audit tables list for Oracle cloud, as per the requirement we enabled the au…
-
Multiple Fusion sessions (tabs) opened in the same internet browserSummary Any issues in having multiple tabs opened in the same internet browser with Fusion single sign-onContent When we first implemented Fusion Cloud several years ago…
-
OTBI RequirementSummary Setting a Flag By Updating Attribute Column in Invoice Header TableContent Hi, We designed a report which send notification for cancelled invoices to vendors sho… -
BI Publisher Report printing in PCL PrinterSummary PCL PrinterContent Good People, How to use BIP to print documents in PCL Printer ? I mean how to convert PDF to PCL in BIP ? or Generate the PCL output using BIP… -
BIP Report to get the Payment pending for ApprovalSummary BIP Report to get the Payment pending for user ApprovalContent Hi All, We have enabled a Workflow approval for Payments in ERP Cloud. We have a created a Specifi…
-
Ignore Skipped Instances on resuming paused report BIP JobSummary Ignore Skipped Instances on resuming paused report BIP JobContent Hello all, We have almost more than 100+ Reports and ESS Jobs that are scheduled and as part of…