Fusion Project reporting
Discussion List
-
From which customer table can we find order_type fieldSummary From which customer table can we find order_type fieldContent Please suggest from which customer table can we find order_type fieldNageshwaran1 53 views 6 comments 0 points Most recent by Pradvin Prabhakar Reporting and Analytics for ERP -
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…Lucky Sharma 29 views 4 comments 0 points Most recent by Lucky Sharma Reporting and Analytics for ERP -
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 Reporting and Analytics for ERP -
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 tableNageshwaran1 94 views 5 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
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…Koteswararao Yenikepalli 93 views 3 comments 0 points Most recent by Vikas Tiwari Reporting and Analytics for ERP -
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 …Senthilrajan V 69 views 9 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
Time entry Third Party System integration with oracle PPMContent Hi All, we are planning to intergeate our third party time entry system with oracle project costing and for project resource management dashboard to view the act…User_2025-02-06-13-19-17-977 37 views 2 comments 0 points Most recent by User_2025-02-06-13-19-17-977 Project Management
-
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 cloudNageshwaran1 20 views 1 comment 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
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…Dasaradh CHenji 82 views 3 comments 1 point Most recent by User_2025-02-01-06-00-17-051 Reporting and Analytics for ERP -
How to control the folder permissions in Reports and Analytics to user levelSummary Need to control users to access the folders within the permissions provided and controlled at the user level, Please provide the details how to control this fold…
-
Subledger Accounting (Setup) Configuration for PPM and Grants - Project AccountingContent Hello Peers, Do we have any document/video that illustrates PPM SLA Setups ? I wish to know "Project Accounting" setup and business processes. Could someone sugg…User_2025-02-05-07-43-41-391 157 views 9 comments 0 points Most recent by User_2025-02-05-07-43-41-391 Project Management
-
Tables in which Printer name and details are savedSummary Tables in which Printer name and details are savedContent Whenever any Customer facing document/report is sent through a BIP report to the printers, is there any…
-
How to create custom XML output formatSummary How to create custom XML output formatContent Hi All, We have to generate a custom .xml output file from ERP cloud . How can we generate XML output file from BIP…Najeeb_ACN 308 views 5 comments 0 points Most recent by Sahil_Makhiza Reporting and Analytics for ERP
-
R13 Query Open AR InvoicesSummary AR Cloud ReportContent Hello : I was wondering if you can hep me about an AR Invoices Report for Cloud. Please Advise Below is the SQL but it only works for EBS …gabriel kinovisques-163562 544 views 7 comments 0 points Most recent by gabriel kinovisques-163562 Reporting and Analytics for ERP
-
Table name and column for transfer order status of the projectSummary Table name and column for transfer order status of the project Content Hello, what could be Table name and column for transfer order status of the project. in ma…
-
Table name and column for Contract NumberSummary Table name and column forContract NumberContent Table name and column for Contract Number for poject commited cost, this is visible in manage commited cost but i…
-
Multi-Year Project numberSummary Do we need to reset the Multi-Year Project number every fiscal year?Content If we have projects that span for more than 1 fiscal year, Do we need to reset the Mu… -
Master Project and Sub ProjectContent Hi All, We have a requirement to create a master project and sub project, Could any please help how do we create a Master project and its sub project in Oracle P…User_2025-02-06-13-19-17-977 350 views 10 comments 1 point Most recent by Kumar 57 Project Management
-
What is the obj Type and obj key and Action to achieve drill down to 'Manage Project Page' from theSummary What is the obj Type and obj key and Action to achieve drill down to 'Manage Project Page' from the OTBI report.Content Hello Experts, I have followed https://ww…
-
Project Revenue Calculation MethodContent Hi All, We have a requirement to calculate the revenue amount based on the below formula. Contract Name: Contract2 Contract Value: INR 3,00,000 Parent Task: INR …User_2025-02-06-13-19-17-977 50 views 4 comments 0 points Most recent by User_Q93J8 Project Management
-
How to register ESS Jobs in R13 20B?Summary How to register ESS Jobs in R13 20B?Content Hi Everyone, Can you please share your thoughts on How to register ESS Jobs in R13 20B? Thanks, -
Distribution Email List for ESS JobsSummary Distribution Email List for ESS JobsContent Hi Everyone, Can you please share your thought on , how to setup distribution Email List for ESS Jobs? Thanks,
-
Drill Down in OTBI for code combination balance to journal linesSummary Drill Down in OTBI for code combination balance to journal linesContent Use case: We need to build a report listing all the account code combination balances and…Sumanth Kunimakki-21932 73 views 3 comments 1 point Most recent by Arun Raj Reporting and Analytics for ERP
-
Sourcing data for BI Publisher Reports from External Data sources including Oracle DBCS/DBAASSummary Building a BI Publisher report in Oracle Fusion Cloud ERP that shall source data from Fusion cloud database and some external data.Content We need to build a BI …Senthilrajan V 177 views 12 comments 0 points Most recent by Manjunathan S-Oracle Reporting and Analytics for ERP
-
Future Terminations and Project CostingSummary Transactions associated with employees that have future dated terminations are excluded?Content We are having an issue with the subject area, Project Costing - A…
-
Is there a SOAP/Web service to make bulk updates to the Contract Billing tab attributes?Summary Is there a SOAP/Web service to make bulk updates to the Contract Billing tab attributes?Content Hi Everyone Is there a SOAP/Web service to make bulk updates to t…
-
BI Query to get Difference between Dates in numeric formatSummary We have requirement to get the Average time required to complete particular ESS Job in Minutes or Seconds.Content Here are more details - We need to calculate th…