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
-
Cycle query for Structures and Components.Content Hi there. I'm trying to get a by level BOM with tables EGP_STRUCTURES_B and EGP_COMPONENTS_B. It's not so easy to relate as in EBS, you guys have any good cycle … -
How to get invoice_number against transaction in RA_CUSTOMER_TRX tableSummary How to get invoice_number against transaction in RA_CUSTOMER_TRX tableContent Please help us to get invoice_number against transaction in RA_CUSTOMER_TRX table -
BIP report deployment by using web service with object permissionContent Hi, Experts. I would like to deploy BIP report and data model by BIP web services from Test instance to Production instance. Each Object has specific permissions… -
Custom ESS job not visible to all EmployeesContent Hello, We have created a custom ESS Job , but its not visible to all employees. We need it to be visible for all employees. We have referred the following docume…User_2025-02-07-08-53-49-914 1K views 2 comments 0 points Most recent by User_2025-02-07-08-53-49-914
-
How to give an accees to a user to run custom ess jobSummary How to give an accees to a user to run custom ess jobContent Hello , I have created one custom report and i have creates custom ess job as well , Now i want to g… -
Display The Limited Values Only On LOV Through User POV SettingSummary User would like to control the values that can be selected in the user POV of Financial Reporting StudioContent User would like to display the limited values on …
-
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 59 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 44 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…