Fusion Procurement reporting
Discussion List
-
Date format issue with Excel template in BIPSummary Date format issue with Excel template in BIPContent Hi Friends, We have date format issues while using Excel template in BIP so could you please suggest if anyon…Sudha KOVURU 92 views 9 comments 0 points Most recent by Hariharan Sekaran Reporting and Analytics for ERP -
OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumenSummary OTBI Procurement Subject Area shows Communication Date same for Original and Change Order PO DocumentContent Hi, We got to see that PO Communication date to supp…User_2025-02-10-05-51-05-868 18 views 1 comment 2 points Most recent by Anca A-Oracle Reporting and Analytics for ERP -
How to restrict Data Model options to avoid users to access directly to the tables (SQL Query)?Summary Power users and contracts need to create data models based on BI Analysis, but this will also give them access to run SQL Queries. We want to restrict SQL Query … -
Project Number is still seeing wrongSummary I changed project number in the system. I am seeing old number for the project in analyticsContent Hi Dear All, We are using an Analytics using Procurement - Pur…User_2025-02-05-02-38-04-251 46 views 1 comment 0 points Most recent by User_2025-02-05-02-38-04-251 Reporting and Analytics for ERP
-
Different PR - PO Matched in AnalyticsSummary for one pr has multiple po one of them cancelled the other one closed but i saw cancelled one. I cannot reach the closed oneContent Hi Dear All, We had a PR and …User_2025-02-05-02-38-04-251 13 views 0 comments 0 points Most recent by User_2025-02-05-02-38-04-251 Reporting and Analytics for ERP
-
Limit number of lines per pageSummary I have an invoice where I want to limit the number of lines that appears per pageContent Is there an IF statement that could limit the number of lines that appea…Mohammad Alhindawi 53 views 3 comments 0 points Most recent by RichardChan Reporting and Analytics for ERP -
How to fetch invoice_no and invoice_date from wsh_ tablesSummary Need to fetch invoice_no and invoice_date from wsh_ tablesContent Need to fetch invoice_no and invoice_date from wsh_ tables or from doo_ tablesNageshwaran1 24 views 3 comments 1 point Most recent by Nageshwaran1 Reporting and Analytics for ERP -
Cross posting this idea in ERP Reporting and Analytics forum - ability to Audit OTBI report configurSummary Cross posting this idea - ability to Audit OTBI report configurationsContent Here is an Idea posted in Financials - General that I thought would be of interest t…Jeff Hare CPA CISA CIA 31 views 0 comments 0 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Cash bases accouting reportsSummary Cash bases accouting reportsContent Hi - Any one come across reports requirement on cases bases?if yes, how you Achieved? pls suggest..Sandeep Kumar-245021 26 views 1 comment 0 points Most recent by SandeepPaspunuri Reporting and Analytics for ERP
-
Dyanmic BI Publisher Page EntrySummary Page Entry for BI Publisher ReportsContent Hi, We need to have a dynamic page entry(one click navigation for report) to be created dynamically i.e it should not …Sahil Makhiza 58 views 3 comments 0 points Most recent by SantoshKumarBhairi Reporting and Analytics for ERP
-
Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersSummary Need Logic/Query to create below KPI's for Purchase Requisitions/OrdersContent Need Logic to create below KPI's for Purchase RequisitionsWe have been trying to c…User_2025-02-10-05-51-05-868 77 views 2 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Join between wsh_deliveries and rcv_shipmentsSummary Join between wsh_deliveries and rcv_shipments to fetch shipment_num, invoice no & dateContent Join between wsh_deliveries and rcv_shipments tables to fetch shipm…Nageshwaran1 111 views 4 comments 0 points Most recent by Nageshwaran1 Reporting and Analytics for ERP
-
Is it possible to add a calculated SQL-based column in an OTBI Analysis?Summary Need to return a segment value name in a column from an OTBI analysis using a SQL QueryContent Hello, Our Financial users have created several OTBI reports based…
-
Is it possible to create a data source for ERP Cloud from Oracle Analytics Cloud (OAC)?Summary My company is moving to Oracle ERP Cloud, but end users want to still use OAC as the primary source for Reporting and AnalyticsContent My company is moving to Or…
-
20c- BI Publisher Data Models No Longer Support Passing Dynamic SQL Parameters in Reference CursorsSummary 20c- BI Publisher Data Models No Longer Support Passing Dynamic SQL Parameters in Reference CursorsContent All, 20c- BI Publisher Data Models No Longer Support P…Amarnath 301 views 6 comments 0 points Most recent by User_2025-02-05-17-23-19-130 Reporting and Analytics for ERP
-
Supplier Spend ReportSummary Supplier Spend ReportContent Hi, As stated, we would like to ask for your help if there is a standard supplier spend report in Oracle. What we need is the actual…Gene Garcia 506 views 2 comments 0 points Most recent by Kent Sarmiento Reporting and Analytics for ERP
-
Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report CataSummary Unable to open/view the xdmz format ( data model) and xdoz format ( report ) uploaded in Report Catalog pageContent Hi Team, I'm new to reporting area and need s…User_2025-02-10-05-51-05-868 47 views 3 comments 1 point Most recent by User_2025-01-30-00-54-17-530 Reporting and Analytics for ERP
-
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
-
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
-
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 996 views 2 comments 0 points Most recent by User_2025-02-07-08-53-49-914 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 72 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 59 views 9 comments 0 points Most recent by Senthilrajan V Reporting and Analytics for ERP -
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
-
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…User_2025-02-07-06-48-26-537 46 views 3 comments 0 points Most recent by Sahil Makhiza Reporting and Analytics for ERP
-
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 40 views 0 comments 0 points Most recent by User_2025-02-07-06-48-26-537 Reporting and Analytics for ERP
-
Procurement - Pending Change Order - Pending ApproverSummary Procurement - Pending Change Order - Pending ApproverContent Hello All, I am trying to get the the "Pending Approver" of a pending Change Order. Let me know if a… -
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…
-
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 pass field value(s) from Page to OTBI (for report or dashboard generation) ?Summary An iFrame is created in an existing Page layout in order to accommodate a OTBI report. How to pass field value(s) from Page to OTBI (for report or dashboard gene…