Fusion Procurement reporting
Discussion List
-
Unable to access OTBI dashboard for Procurement - PurchasingSummary: An user can not access to a dashboard for Procurement - Purchasing on OTBI, the user has assigned the purchase analysis role Other user with te same role can ac… -
Open Purchase Orders & Goods Received Not Invoiced reportsSummary Various OTBI reports showing Open Purchase Orders & Goods Received Not InvoicedContent Import the attached catalog files into your environment using the "Unarchi…Andy Gough 2.3K views 19 comments 14 points Most recent by Khalid Mahmood Reporting and Analytics for ERP -
Otbi analysis filter for budget date greater than creation dateSummary: We are looking for advice on the most effective way to set up an analysis that lists all requisitions that have a budget date of more than 30 days from their cr…
-
Issue Number formating causing reporting issuesDear All, The format of numbers in the purchase order standard report are not displayed correctly, because the NLS_NUMERIC_CHARACTERS setting is not configured at the da…George Mattar 31 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Why OTBI report output file in excel is not showing morethan 25000 recordsSummary: Is there any OTBI Developer can help me resolve this issue. If the output excel file of AD PO ALL PURCHASE ORDERS Report is morethan 25003 records it is skippin…
-
Navigation to ERP AnalyticsSummary: Hi All We have client that buy ERP Analytics license. How to navigate to this ERP Analytics? You can check the screenshot using this link : But, I dont know how…
-
open PO report with receipt datesSummary: We are trying to build a report with open POs and their associated receipts. Content (please ensure you mask any confidential information): Requirements are ori… -
Execute SQL Query against Cloud ERP/HCM without using DataModel/BI ReportSummary: Hello, Usually Oracle Fusion BI Report/Data model was used to create SQL(like "select * from poz_suppliers_int") against Fusion DB ( like ApplicationDB_FSCM,App…Vetrivel J 570 views 10 comments 0 points Most recent by Shyam Patel Reporting and Analytics for ERP
-
OTBI scheduled reports/analyses "From" email changedHas anyone else noticed a change in the "From" email address for scheduled reports/analyses from OTBI? I have rules in my Outlook to filter these to a specific folder an… -
Requisition Approval Rule Report that includes all other tasksSummary: The requirement of This report should include: Requisition Approval Rule Report that includes rules for “requisition approvals” task and all other tasks related…
-
Report for supplier invoice with address not pullingWe are developing a supplier invoice report BIP report using the below listed tables. Admin users are able to get the data, but the end user with access to just this BIP… -
How to get 'Payment date' on the Procure to Pay Real Time subject areaSummary: How to get 'Payment date' on the 'Procure to Pay Real Time' subject area Content : I am trying to build a report using the 'Procurement - Procure to Pay Real Ti…Sergio F Oliveira 145 views 4 comments 1 point Most recent by Nalsoft Pvt Ltd Reporting and Analytics for ERP -
Adding a parameter to custom data model of a seeded reportSummary: We need to customize a seeded report and add a new parameter. But when we create a copy of seeded Data model and add a parameter in the custom data model, it gi…Ashu Raj-Oracle 393 views 4 comments 0 points Most recent by HARSH0891 Reporting and Analytics for ERP -
I did customize a standard notification. But the change i did was not appreadSummary: PO notification Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any…S.A.A Dinoli 21 views 5 comments 0 points Most recent by S.A.A Dinoli Reporting and Analytics for ERP -
Report to show Document Types enabled for B2B Communication for each Supplier and its Supplier SitesSummary: Under OTBI subject area "Supplier - Supplier Real Time", I am unable to find and add Associated Collaboration Documents for each Supplier Site. I can only add w…Ruthvik Ramesh-IH 11 views 6 comments 0 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP
-
Lead times reportsSummary: The client is asking me for two reports, and I can't find anything standard. Could you confirm for me? The reports are: Standard report that evaluates the agree…Santiago Fazio 11 views 3 comments 0 points Most recent by Nathan CCC Reporting and Analytics for ERP
-
How to query the latest pdf contract from purchase agreements after a change orderSummary: Content (please ensure you mask any confidential information): Hi Everyone, I currently have a query where I am selecting the Contract Number, Description, Star…Steph96 11 views 1 comment 1 point Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
Query or report to show B2B Communication details for each supplier siteSummary Query or report to show B2B Communication details for each supplier siteContent Is there a query/analysis/report/data model, etc. available in OTBI to show which…Jennie Wortman 233 views 3 comments 3 points Most recent by Ruthvik Ramesh-IH Reporting and Analytics for ERP
-
Does anyone have a Procurement Purchase Order dashboard they could share?Summary: Wondering if anyone has a (more recent) Procurement / Purchase Orders OTBI Dashboard they could share. Content (please ensure you mask any confidential informat…Greg Aulson 11 views 1 comment 0 points Most recent by Bharat Agrawal Reporting and Analytics for ERP
-
what is the link between main negotion number with negotion number whic has multiple rounds 2 or 3oracle fusion 11.13.23.10.0 for e.g in my system i have negotition number with this RFX-CSC-230022 this is main one RFX-CSC-230022-2 this is 2nd round RFX-CSC-230022-3 t…Abdur Rehman 21 views 2 comments 0 points Most recent by Abdur Rehman Reporting and Analytics for SCM -
We want to provide a deep link in email to supplier for purchase order acknowledgementSummary: We want to provide a deep link in email to suppliers for purchase order acknowledgement so that supplier can click on the URL and PO acknowledgement page opens …Amit Sutar 41 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
BI Publisher Notification - PO ApprovalSummary: I have amended the BI Publisher approval but only certain users see the body of the notifications, others just get an attachment and approval buttons Content (p…Robert of STAU 21 views 2 comments 1 point Most recent by Robert of STAU Reporting and Analytics for SCM
-
Manage Internal Supplier Profile Change ApprovalsCannot find Underlying Oracle Tables For The Setup And Maintenance Task - approval management Looking for the underlying Oracle tables for the Approval Management tasks,…NZ-user999 33 views 1 comment 0 points Most recent by Santhosh Cholleti-Support-Oracle Reporting and Analytics for SCM
-
R12 ERP OTBI subject areas to database tables mapping spreadsheetsSummary R12 Financial and Supply Chain Management OTBI subject areas to database tables mapping spreadsheetsContent These spreadsheets are published by Oracle OTBI Devel…User720640-Oracle 2.1K views 14 comments 15 points Most recent by Bea Reporting and Analytics for ERP -
Currency Conversion in OTBI report from Procurement - Procure to Pay Real time subject areaSummary: We have a custom OTBI report created from Procurement - Procure to Pay Real time subject area. The report currently shows all open POs in different currencies. … -
How to create a BIP Report in excel with a drill down option?Summary: I would like to create a BIP Report of the list of the BPAs. Click on BPA I would extract the list of the POs linked, click on PO I would extract the lines and …Giuseppe Galluzzo 16 views 2 comments 0 points Most recent by Giuseppe Galluzzo Reporting and Analytics for ERP
-
Is there a way to create a deep link from OAC into the invoice attachments in ERP?We've created a dashboard in OAC for invoice details. Users are able to click a deep link in that dashboard that will open an invoice in ERP. They are then able to click…Steven Woods 21 views 2 comments 1 point Most recent by Steven Woods Reporting and Analytics for ERP
-
how to fetch current schedule process start time of any Oracle Fusion scheduled reportSummary: I have a requirement to fetch incremental data. I am using below query. but due to frequent transaction. Few transactions are getting picked by 2 consecutive sc…Grab.saurabh 72 views 2 comments 0 points Most recent by Grab.saurabh Reporting and Analytics for ERP
-
How we get difference of two sum from the same table?Summary: Content (please ensure you mask any confidential information): Hi, We would create a column in a report who get a difference of two sum from the same table. Wha…Ylenia Gentile 21 views 1 comment 0 points Most recent by Andreea Brem-Oracle Reporting and Analytics for ERP
-
Requisition Life-cycle report (OTBI)Summary Simple report showing creation date, approval date, PO creation date etc for purchase requisitionsContent See attached screenshot for details. Unarchive the atta…Andy Gough 871 views 10 comments 8 points Most recent by JLogan-EncoreGlobal Reporting and Analytics for ERP