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
-
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 46 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 41 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 32 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 31 views 1 comment 0 points Most recent by Gergana Radoutcheva-Oracle
-
Monthly Scheduled report did not runSummary Monthly Scheduled report did not runContent Hi Experts We have a monthly scheduled report scheduled in March and has run fine for first 3 months. The report has …
-
Subject Area for BMP Workflows / How long to approveSummary Subject Area for BMP Workflows / How long to approveContent Is there a subject area for BMP workflow? I'm looking for a query to tell how long project related ap…
-
Goals Report - Quarterly reviewSummary Unable to find columnsContent Hi, I've been asked to build a Goals report that contain the following fields that I cannot seem to find in any of the Goals Subjec…User_2025-02-05-22-44-35-842 35 views 0 comments 0 points Most recent by User_2025-02-05-22-44-35-842
-
White Paper | Using Seeded Data Extract Services for Oracle ERP Financial CloudSummary White Paper | Using Seeded Data Extract Services for Oracle ERP Financial CloudContent I come through this useful white paper and think it will be useful to shar… -
Parameters not available in favouritesContent Hi, If any analysis report is displayed under Favourites it is not displaying with parameters. Is this the actual behaviour please advise Thanks
-
on cx how i get table for custom table ?Content in cx in service when create a work order , we created a field assign to and setup it in custom table. i need to create a report and get value for field assign t…
-
How to Extract Approval Rules Created for Contract Created in BPMContent Hello, We need to extract Contract approval Rules created in BPM. How to achieve that?User_2025-02-07-08-53-49-914 37 views 0 comments 0 points Most recent by User_2025-02-07-08-53-49-914
-
Logo in OTBI AnalysisSummary Getting error when uploading images into OTBI analysis from local driveContent Hi All, I am getting below error when uploading logo image into an OTBI analysis u…
-
Subject Area for Receivables Recurring Bill PlanSummary Looking for debit authorization number in bill planContent Hello: I am looking for the subject area that will house the debit authorization number (bank account …