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
-
ESS Administrator / Monitor / Operator rolesContent Hi I'm trying to find information on what exactly entails the roles: * ESS Administrator Role * ESS Monitor Role * ESS Operator Role Trying to give a user access… -
Where can we get Percent Complete in Contracts Associated ProjectsContent Hello all, From where can I get the highlighted field . This is from which table? I checked contract lines tables there Percent Complete is coming NULL. Please s… -
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 …User_2025-01-29-02-09-34-137 163 views 9 comments 1 point Most recent by User_2025-02-05-23-22-15-856 -
Can we create a multiple selection paramter in the custo ess job?Summary Can we create a multiple selection paramter in the custo ess job?Content Hello , We have create a one custom job for the BIP report and now the users are excepti… -
Set background color on subtotal lines in OTBIContent Hi, I would like to set background color on subtotal lines in OTBI Analytics. Does anyone know how to configure about this? regards, Version BIP 11.1.9 bundled w… -
COA value missing in the LOV in Payables invoices - Transactions real time subject areaSummary COA value missing in the LOV in AP invoices real time subject areaContent Hi Gurus, We defined a cost center long ago and had AP transactions created against it.…
-
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 60 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…