Fusion Supply Chain Management reporting
Discussion List
-
SQL Statement for AR invoice including attachment line informationSummary Receivables Transactions ExtractContent Hello I am wondering if you can share with me any SQL to extract AR information, including attachment information. I have…gabriel kinovisques-163562 67 views 4 comments 0 points Most recent by Sudha KOVURU Reporting and Analytics for ERP -
OTBI Issue - Costing - Receipt Accounting Real TimeSummary OTBI Receipt Accounting -- Concatenated SegmentsContent Hi All, Appreciate your inputs or suggestions on the below issue. OTBI Report having timeout issue Subjec…Swapnil Kashid 14 views 4 comments 1 point Most recent by Swapnil Kashid Reporting and Analytics for ERP -
Archive/Unarchive buttons missing in Catalog ReportsSummary Archive/Unarchive buttons missing in Catalog ReportsContent Hi All, Archive/Unarchive buttons missing in Catalog Reports Thanks, Dev Thota. Version 21BDevendra Thota 34 views 1 comment 3 points Most recent by Noelle Bartlam-Oracle Reporting and Analytics for ERP
-
How do we distinguish between custom reports and standard reports?Summary We want to know how many custom reports are created in reporting center. How do we distinguish between custom reports and standard reports?Version Oracle Fusion …Patrick Chrabieh 25 views 2 comments 7 points Most recent by Skolli-Oracle Reporting and Analytics for ERP -
OTBI Analysis: Using TIMESTAMPADD to derive last day of the month based on Period Name in Subject ArContent Hello There, I have an OTBI analysis for Subject Area: "General Ledger - Balances Real Time". The analysis has a column "Time"."Accounting Period Name" OR "Time"…
-
Inventory Reconciliation with GL - ReportContent All - I have a requirement to show the Inventory Reconciliation with GL and I see two OOB reports (Costing balances and Inventory Valuation) to satisfy the requi…Hari Thyagaraj 40 views 2 comments 0 points Most recent by Ahmed Eldemerdash Reporting and Analytics for ERP
-
Source Code for the Fusion Audit Reports which will be access via Tools > Audit ReportsSummary Source Code for the Fusion Audit Reports which will be access via Tools > Audit ReportsContent Hello Team, I am looking for the source code or Data base tables w… -
BICC - Selecting Columns from Data Stores Impacts other reportsSummary How to configure BICC reportsContent We are currently working on our migration to Oracle Fusion. I am tasked with looking at extracting data via BICC. How can I …
-
OTBI data modelSummary Is there a place where we can understand the data model (tables) for OTBI reports?Content Is there a place where we can understand the data model (Tables) for OT…Jeff Hare CPA CISA CIA 70 views 5 comments 3 points Most recent by Jeff Hare CPA CISA CIA Reporting and Analytics for ERP -
Unable to preview BI Publisher output in RTF:Summary Unable to preview BI Publisher output in RTF:Content Hi Guru, I am facing one strange issue in BIP Desktop , i am able to load and design the RTF but when i am t…Rohit Soni-259808 49 views 6 comments 3 points Most recent by Lucky Sharma Reporting and Analytics for ERP
-
Extract Cost Center from "Code Combination Description" field - (Procurement - Spend Real Time) subjSummary Extract Cost Center from "Code Combination Descpription" fieldContent I am using "Code Combination Description" field as one of my select columns from (Procureme…UjasB 66 views 5 comments 0 points Most recent by Anders W. Langholm Reporting and Analytics for ERP
-
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… -
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 …Eren Göktepe-155015 15 views 0 comments 0 points Started by Eren Göktepe-155015 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 34 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_ tablesuser12240811 15 views 3 comments 1 point Most recent by user12240811 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 22 views 0 comments 0 points Started 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 17 views 1 comment 0 points Most recent by User_4A8FM 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…RAJESH M-226898 39 views 2 comments 0 points Most recent by user12240811 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…user12240811 24 views 4 comments 0 points Most recent by user12240811 Reporting and Analytics for ERP
-
Custom ESS Parameter with TextBox and SearchSummary How can we have a Custom ESS Job with parameter as Textfield with Search option.Content One of the standard ESS Job has a parmeter which is a TextBox with a Sear…Balachander G-Oracle 19 views 2 comments 1 point Most recent by User_WZSBF Reporting and Analytics for ERP
-
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…
-
Error tables in Oracle for Unit of Measure Intraclass Conversion FSM importSummary I am trying to fetch the errors that occured while importing Unit of Measure Intraclass Conversion using FSMContent Hi, I am searching for tables where I can fin…
-
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…RAJESH M-226898 18 views 3 comments 1 point Most recent by Abhishek Gupta1 Reporting and Analytics for ERP
-
Suggest Some Price List table in oracle fusionSummary Please suggest some price list table in oracle fusion and where can we find themContent Please suggest some price list table in oracle fusion and where can we fi…user12240811 11 views 2 comments 0 points Most recent by user12240811 Reporting and Analytics for ERP
-
BIP Report to list all Custom ReportsSummary BIP Report to list all Custom Reports.Content Ho to fetch list of all custom reports from cloud instance (Oracle Cloud SaaS). I know how to fetch them from BIP A…
-
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 field
-
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 …Doron de Jong-57089 134 views 9 comments 1 point Most recent by Ed Higgins Reporting and Analytics for ERP
-
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…Koteswararao Yenikepalli 25 views 1 comment 0 points Most recent by Vikas Tiwari 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 tableuser12240811 25 views 5 comments 0 points Most recent by user12240811 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…Mayur Khandelwal 37 views 2 comments 0 points Most recent by Mayur Khandelwal Reporting and Analytics for ERP