Fusion Procurement reporting
Discussion List
-
List of All Tables for Oracle Fusion ERP in PDF FormSummary: We need to have a List of All Tables for Oracle Fusion ERP in PDF Form along with its corresponding descriptions Content (required): We need to have a List of A… -
Unable to join Invoice and Procurement Subject Area in OTBI AnalysisSummary I have a requirement to fetch the Purchase order details with corresponding invoice details. Therefore i need to connect two subject areas to fetch the required …Santosh V-228136 107 views 8 comments 0 points Most recent by User_BMLQW Reporting and Analytics for ERP
-
Need help on calculating Hash Total for National Bank of Kuwait EFT templateSummary: is there any ready to use code to calculate hash total logic in oracle etext template to make a payment to National Bank of Kuwait Content (required): Hash tota…SireeshaJaladi 1 view 1 comment 0 points Most recent by SireeshaJaladi Reporting and Analytics for ERP
-
R13.x FSCM BI Cloud Adapter BI View Object to Database Lineage Mapping SpreadsheetSummary This posting includes R13 FSCM BI Cloud Adapter BI view object to database lineage mapping. Content This spreadsheet is published by Oracle BI Cloud Adapter …Rashmi M-Oracle 21.4K views 89 comments 26 points Most recent by Dave Kekish Reporting and Analytics for ERP
-
Data modelling in OTBI?Summary: Hi In Payables (and therefore also in the Procurement subject areas such as Procurement - Spend Real Time) it sometimes happens, that an invoice is matched with…Anders W. Langholm 2 views 0 comments 0 points Started by Anders W. Langholm Reporting and Analytics for ERP -
Bi Publisher - How to read the content of an attachment using sql script in data modelHi, We have a requirement in BI Report, to check for the attachment at Supplier Profile and if the attachment is present then we need to read the content of the attachme…Nepal Bhumireddy 51 views 8 comments 0 points Most recent by Nepal Bhumireddy Reporting and Analytics for ERP
-
Can working days be used instead of calendar days in a standard infolet?Summary: Calculate aging period using only working days instead of calendar days. Content: The aging requisition lines infolet in Purchase Orders area of Procurement mod…Ananda Bhargav Potluri 1 view 0 comments 0 points Started by Ananda Bhargav Potluri Reporting and Analytics for ERP
-
Which function can be used to display only one value from multiple values result?Summary: Display the first value from a result including many values Content (required): We're using an OTBI analysis for delayed PO deliveries and we've supplier's deta…
-
Fusion BI Report Custom LOV description alignment problemSummary: The problem : The description is not properly aligned (see below in yellow) in custom LOV. The user has requested for the description to be left-aligned. Conten…
-
Can the Workflow Transactions Listing report show workflows other than related to invoices?Summary: There is a Scheduled Process called 'Workflow Transactions Listing' which shows pending and rejected transactions related to invoices. Is there something simila…
-
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 10 views 3 comments 0 points Most recent by Waleed Fetoh Reporting and Analytics for ERP -
Developing of a Report to capture Requisition Approval HistorySummary: We require to capture the approval history of Requisitions. Such as who the requisition is currently pending approval, who has completed approval, the next appr…Janitha Perera 81 views 9 comments 0 points Most recent by Janitha Perera Reporting and Analytics for ERP
-
Bank Return Records BIP queryHi All, I m new to fusion finance module, we have a requirement to fetch all the bank return records through BIP query, Can anyone help us with SQL query or the table na…Yuvraj S-Oracle 21 views 1 comment 0 points Most recent by Umamaheswara Reddy Karri Reporting and Analytics for ERP
-
Is there any way to add Item number in seeded account analysis report?Summary: Customer is interested to see Item number in Account analysis report so that he/she can perform GRNI reconciliation Content (required): Version (include the ver…Naga Hari Krishna P-Oracle 21 views 1 comment 0 points Most recent by Dhruvjoshi23 Reporting and Analytics for ERP
-
SUM each Payment row Running Total (YTD) by Vendor ID/Name?Summary: My code succeeds when my query for one Vendor, but needs to be reset for the whole report (muliple Vendors) A running total ( YTD Amount) for each group of Vend… -
Location of Tax Recovery Rate used for requisition or Purchase Orders in data tablesSummary: I'm trying to find where in the data tables the Tax Recovery Rate used on a requisition or a Purchase Order is stored. Content (required): This is the Tax Rate …
-
How to create Dependent List of Values parameter in ESS Job with User-defined (SQL) LOV as SourceSummary: I would like to know if it is possible to create a parameter in an ESS Job that is dependent on another LOV parameter that has a User-defined (SQL) LOV Source. …
-
Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extContent Which BICC PVO should be used to extract Supplier/Vendor 'Name' to match to BICC Invoice Headers extract PVO? Version 21_BJeannieMoore 67 views 1 comment 1 point Most recent by Marc Vermeulen Reporting and Analytics for ERP
-
Oracle BIP or OTBI reports output in Non-English languages in Oracle Fusion Financials (SaaS)Summary: Oracle BIP or OTBI reports output in Non-English languages Content (required): Hi Team , We are looking for the Oracle BIP or OTBI reports output should be in H…
-
How to run seeded PO Dashboard from the Procurement iconSummary: How to run seeded Dashboard from the Procurement springboard icon Content (required): Hello There is one PO Dashboard and the users wants to run from the Procur…Cesar Saveedra 21 views 1 comment 0 points Most recent by Sahithi Kolasani-Oracle Reporting and Analytics for ERP
-
Using a parameter & variable to represent POD name for deeplinksSummary: It is great we can use deeplinks in OTBI but it would be helpful if a variable could be used to populate the current pod name. Otherwise we need to hard code it…Marcus131975 61 views 7 comments 1 point Most recent by Raghavan p-Oracle Reporting and Analytics for ERP
-
Supplier site bank account inactive date field in OTBIContent Hello, Could somebody assist me with the following problem, please: In an OTBI report, I would like to add the end date of a supplier site bank account. These va…User_RI0MI 52 views 4 comments 0 points Most recent by Shabharish, Pasupula Reporting and Analytics for ERP
-
Need the query to get the data on the Review Budgetary Control Balances UISummary: We need a query for a report, which happens to be the details of the Review Budgetary Control Balances UI. Please assist. Please assign this SR to the relevant …Sushan Peiris 31 views 3 comments 0 points Most recent by Catherine_Myrand Reporting and Analytics for ERP -
Analysis/SQL Query behind Standard Purchase Order InfotilesVersion (include the version you are using, if applicable): Oracle Fusion Cloud Applications: 22D (11.13.22.10.0) Summary: How to Get the actual OTBI Analysis behind sta…
-
Is there an option to update Oracle or Vision logo once to reflect in all seeded reports?Summary: Client is asking for one single update of oracle or vision logo so the users doesnt see Oracle /vision logo in out of the box report when run. Client requests t…Abhilash K - Deloitte USI 71 views 5 comments 1 point Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP -
Where is WF_ROUTING_RULES located? Vacation Rules table?Content Hi, I'm trying to do reports for vacation rules and I have read I can use WF_ROUTING_RULES but or the life of me I can't find where these reside Any clues? Do I …King Jack 71 views 9 comments 2 points Most recent by Divya Mangtani Reporting and Analytics for ERP
-
Export Current Page returns all rows i.e, entire dashboard data in OTBI.Summary: Export Entire Dashboard is exporting all rows but "Export Current Page" no longer exports only the rows on the current page. It is exporting all rows. Please ad…Abhilash K - Deloitte USI 31 views 5 comments 0 points Most recent by Abhilash K - Deloitte USI Reporting and Analytics for ERP
-
Extract Fusion Spend Classification Data using BICCSummary: How to extract Spend Classification Data from Fusion? Content (required): As per Fusion 21C, Oracle has introduced Spend Classification Oracle Procurement Cloud…Guillaume Lecouteux. 21 views 1 comment 0 points Most recent by Guillaume Lecouteux. Reporting and Analytics for ERP -
AP Aging reportSummary AP Aging reportContent Is there a standard AP Aging report available online? We were advised that the AP Aging report in Oracle can only be run on the current da…
-
Payment infotile no longer be available from update 22CSummary: The Payment Infotile is no longer available from 22C, and Customers need to apply alternate Options for Supplier Outstanding Balance ( Doc ID 2871676.1 ) on My …AVorster-Oracle 21 views 0 comments 0 points Started by AVorster-Oracle Reporting and Analytics for ERP