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
-
Fixed Page LayoutContent Hi, In the report the header display customer and invoice header details and the below table display invoice lines. I would like to restrict displaying number of… -
Comprehensive Reporting Role in Fusion CloudSummary Role that has Access to all the Subject Areas/Dashboards/Reports. (Object Level as well as Data Level)Content Do we have a role other than BI Administrator that … -
Fixed FooterContent Hi, Please suggest how to have set of fields fixed to be displayed at the bottom of the page as the report can have single to multiple pages. In all the pages th…
-
ERP-FINANCIAL-Data Migration-CHECK LISTSummary ERP-FINANCIAL-Data Migration-CHECK LISTContent Dear Team, Can you please share the ERP-FINANCIAL-Data Migration-CHECK LIST to avoid challenges. -
Session user for bursting BIP reportSummary Session user for bursting BIP reportContent How can i burst BIP report to the session user ( the user that run the BIP report ) ? what parameter i should add aft… -
Fixed LayoutContent Hi, In the invoice report irrespective of number of invoice lines how can I make the particular section to be printed always at the bottom of the page. Is there …
-
Unable to view audit data in _ tablesSummary Unable to view audit data in _ tablesContent Hi All I have enabled audit for user roles and able to view the data from Tools -> Audit reports. I want to extract … -
financial report studio & smart viewContent 1- i will start study financial report studio & smart view . 2- what are the documents available ? and what is the contents ? 3- what is the forum available fina…ghrbia 64 views 1 comment 0 points Most recent by Abhijit Dhakephalkar Gr Manager Financials Product Management-Oracle -
I can't join suppliers tables and ZX tables through the withholding Group IDSummary I have a retention group code. Do you know how do I get to the PERCENTAGE RATES by query,Content I have a retention group code. Do you know how do I get to the P…
-
Tables related to ESS JobsContent Hi, I need to develop a BIP report on certain GL ESS jobs that have been run/scheduled. Is anyone aware of the tables that need to be queried to obtain this info… -
Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudSummary Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloudContent Need JAI_OM_OE_RMA_LINES table and its references in oracle fusion cloud -
Add note text of an invoice in OTBI/BIPSummary Add note text of an invoice in OTBI/BIPContent Hello, My need is the following : create a report which will show the comments of invoice which are rejected This … -
EBS to Fusion Migration - Impact on BI ReportingSummary Re-map EBS interfaces with FusionContent We have build DWH from Oracle EBS which has several reports on top of it. We are migrating to fusion and want to retain …
-
supplier balance detailsContent i need to create supplier balance details report . can i find seeded report for supplier balance details ? if not can i find query ?
-
Otbi report on Asset BookSummary Otbi report on Asset BookContent I need to create a report that shows the change in asset life. Which field names do I need to add to reflect the asset life befo…
-
Any add on to connect oracle Fusion DBContent Hello, Is there any add on to connect Oracle Fusion DB. Because direct database query option is no more 20A update. So how can i query to extract data. I used cl… -
Integrated Fusion Help - Library available?Summary Is there a topic library availble?Content we are looking into enabeling the Integrated Fusion Help functionlaity and I have a question: Is there a library availa…
-
Restrict OTBI reports data by Projects by logged in Project ManagerSummary Can we restrict OTBI Reports projects data such as cost,revenue by logged in project manager or any other role assoicated to the projectContent Hello All, We are…
-
Roles for BI Analysis ReportContent Hi For an user EMPLOYEE and RESOURCE role is provided is there any other role required to run the BI Analysis Report of the reports related to subject areas of A…
-
Need to extract all OTBI/BI reports in custom folderSummary Can we use sql to extract OTBI/BI reports metadata?
-
How to idenitfy attached expense at line levelSummary Need to find query for attached expense at line levelContent Hi, I am trying to create a table which shows the expense line and it's attachment. Currently I have…
-
Can read-only users download Excel reports from Report&Analytics menu?Summary Is it possible for read-only users to output OTBI reports?Content I am considering to devide users into two role groups to minimize account licence fee. 1. read0…User_2025-02-08-06-23-38-301 49 views 3 comments 0 points Most recent by User_2025-02-08-06-23-38-301
-
customer balanceContent i need to create customer balance details report .can i find seeded report for customer balance details ?if not can i find query ?
-
Querying CST_COSTED_ONHAND_DAILY brings nothing.Summary CST_COSTED_ONHAND_DAILY is empty.Content I do retrieve data from other CST tables but querying CST_COSTED_ONHAND_DAILY brings nothing. Any suggestion? Thanks! Ve…
-
Need Help with a Deep Link for RequisitionSummary Trying to Create Drill down from a Simple OTBI report to the Requisition ScreenContent Hello. Looking for some help on what we think is a simple deep link from a… -
Best strategy for weighed FIFO item cost.Content Hi. In Oracle EBS we had FIFO layers that each one was being consumed. The item cost at a time was the weighted average of the value of the unit value of the lay…User_2025-02-07-06-48-26-537 44 views 0 comments 0 points Most recent by User_2025-02-07-06-48-26-537
-
Descriptive Flexfields on Business Unit definitionContent Does anyone know how we can define descriptive flexfields on Business Unit definition? I can't the relevant object in the Manage Descriptive Flexfields task and …
-
User Logon IP AddressSummary User Logon IP AddressContent Hi Experts Is there any table where Oracle stores the IP Address of an user logon ? We are looking to putting some controls on the I…
-
Emailing report based on field on data model?Summary Send report to destination based on field on DM?Content Hi. I'm working on a simple report to show the quantity on hand of items based on subinventory. Each subi…User_2025-02-07-06-48-26-537 35 views 3 comments 0 points Most recent by User_2025-02-07-06-48-26-537
-
GL Journal Workflow notification template customizationSummary GL Journal Workflow notification template customizationContent In latest release oracle allows editing the workflow notification template. We are trying to custo…saravana maneeian subhramaniun 43 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle