Fusion Procurement reporting
Discussion List
-
Can I edit the template of FYI notification myself?Summary: Would you please let me know whether I can edit the templates of FYI notification myself? If yes, where can I find these templates? Thanks. 1, the FYI notificat… -
Which table does PO notification report extract data fromDear support, I found in Purchase Order Notification report, sometimes the data is extracted from table PO_HEADERS_ALL and PO_LINES_ALL, sometimes the data is from table…
-
PO Change Order Amount Changed column detailsSummary PO Change Order Amount Changed column detailsContent Hi Friends, Can you please help me to get Amount Changed column details when PO Change Order action performe…Sudha KOVURU 218 views 6 comments 1 point Most recent by Matthew - Town of Aurora Reporting and Analytics for ERP -
Purchasing Documents Pending ApprovalSummary A Report showing purchasing documents which are currently pending approval and the person they are currently assigned to.Content - If you want a report that simp…Ifeanyi Katchy-Oracle 3.4K views 52 comments 20 points Most recent by Ifeanyi Katchy-Oracle Reporting and Analytics for ERP
-
TIP: Relative deep links / drilldowns on BIP report. Relative deeplink path.Summary: You can use this trick to make your deeplinks working without instance hardcoding and make them working also on email templates and e.g. excel extracts. Content…alexey.shtrakhov 59 views 3 comments 3 points Most recent by alexey.shtrakhov Reporting and Analytics for ERP -
TSA SQL filter not working when field has date AND timeSummary: Report requirement for all supplier sites set up in last 30 days - issue with TSA SQL filter Content (please ensure you mask any confidential information): I ha…
-
Is there a Supplier Open Balance Letter report in Fusion Payables?Summary: I need a report to list supplier's invoice amount, payment amount, discount amount, prepayment amount applied and remaining balance. Content (please ensure you …Dennis_0427-Oracle 52 views 2 comments 0 points Most recent by Sigrid B. Reporting and Analytics for ERP
-
Which subject area can we locate the consumption advice details?Summary: I'm trying to create an analysis which will me if the consumption advice line is open for invoicing or already invoiced. ex. Consumption Advice Number - PO Numb…
-
query of Negotiation modifications IP addressSummary: Need to report on Negotiation's modifications IP address Content (please ensure you mask any confidential information): Hi All, I would like to know, is it poss…
-
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.1K 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 256 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 99 views 4 comments 1 point Most recent by Nalsoft Pvt Ltd Reporting and Analytics for ERP -
List of all seeded reports for SCM , Procurement and Procurement contractsI am going to the below navigation for getting the list of all the seeded reports. Below is the example for procurement but could not find the right link. could you plea…Santosh Kumar,Rayudu 236 views 3 comments 0 points Most recent by Bhaskar Konar 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 324 views 4 comments 0 points Most recent by User_ZR4R1 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 25 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 205 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
-
The report output isn't available. You must schedule the report to run.Summary: Hello, I am trying to create a BI Publisher report for users under the custom folder so that they can run it from FRC. I am able to run it but when uesrs are ru…