Reporting
Discussion List
-
SQL queries to find default bank account selected in Manage installment on AP Invoice interface.How to find out table details of bank account selected in manage instalment in invoice .Jeetesh Singh 61 views 2 comments 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management -
Cash to General Ledger reconciliation report snapshotSummary: Understand that cash to general ledger reconciliation report shows latest positions always. Has someone developed a custom data model which shows snapshot posit…Vicky Adwani 11 views 2 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
In EBS, there is an Unclaimed Properties Report. Is there something similar in ERP cloud?Summary: Our client is using the Unclaimed Properties Report in EBS currently. They would like to use it in the cloud, however, I could not find a standard report that c…Lou Maroney 11 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
AP Invoice Hold workflow notification to PO Requestor/ BuyerSummary Looking for a AP Invoice hold workflow notification to PO Requestor / BuyerContent Hi Experts, I am looking for an option to send the workflow notification to PO…
-
Invoice Documents Recognition Rate Report, Puchase order % recognition is worngSummary: The Attribute % recognition rate calculation for PO is wrong for us. Is anybody else have the same issue? Content (please ensure you mask any confidential infor…SuniChacko 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Not able to find the link which we can connect to GPA PO & GPA intercompany invoice.Hi All, We have developed a custom Report to display Purchase orders and Invoice details. We can able to view Supplier PO's and their invoice details. Second kind of PO'…Shilpa Pekade 11 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
AP Reporting Questions - Basic Reporting InfoHi - I have a query about 22D. I am investigating out of the box reports available in Fusion Financials, specifically for Payables. We have 2 requests from a customer: I…u20240321 31 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Webservice or REST API to fetch Data from OTBI Seeded ReportSummary: We are in need of a Webservice or REST API to fetch data from OTBI Report Content (required): We are trying to get data from seeded OTBI Report through webservi…Neha Bhatt 41 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
What is the column name for Assignment Inactive Date on Vendor Bank Account?Summary: What is the What is the column name for Assignment Inactive Date on Vendor Bank Account? Content (please ensure you mask any confidential information): We have …John Angelo Galang 11 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
add remittance message to remittance adviceSummary: I downloaded the XML payload and see Remittance Message in the payload, but is isn't available as a field when I try to add it in the field browser? Anyone succ…Alex Glose 31 views 7 comments 0 points Most recent by Glen Ryen Payables, Payments & Cash Management -
Oracledatatable for supplier masterdata fieldsSummary: In an external application, we are creating checks on Supplier master data information combined with data from other sources. For 2 checks we need the data fiel…Daniel.Hut 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Unable to preview attachment without download the attachment in ReportHi All, Unable to preview the attachment without download the attachment Below steps are we following:- step1:- we have made one custom report step2:- we have added the …J_Rambabu 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle BI Publisher Learning Center
-
Import of goods and Spain Online VAT ReportingSummary: Dear all, How to register in Fusion import of goods in Spain LE: supplier invoice - all clear (no VAT) DUA - customs documents, where is stated import VAT, addi…Stefi-Oracle 21 views 6 comments 0 points Most recent by Stefi-Oracle Payables, Payments & Cash Management
-
reporting access such as BICC and BIP - what roles are needed to assign ??Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…joelroshan92 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Best practices on supplier name for DAS2Summary: As per the DAS2 constraint to register the supplier SIRET at supplier profile level (and not at the supplier address level). The risk of having several supplier… -
Payables Open interface rejects all records....The Transaction business category code isnt validSummary: We are uploading Bulk AP Invoices using FBDI, Payables Open interface rejects all records....saying ..The Transaction business category code isnt valid on the t…Raoof Ahmed 21 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
Performance issue with import payables InvoicePerformance issue with import payables Invoice request....The Request is running for 12 to 14 hours and then erroring out without any log. When we loaded 5 records it to…Raoof Ahmed 11 views 1 comment 0 points Most recent by Shivam Chauhan-Oracle Payables, Payments & Cash Management
-
Run report privilege not found after creating a job definitionSummary: I created a job definition to run a report by schedule process however, I am not able to find the privilege to assign to users in order to grant them access to …
-
Anyone having issues post 24A upgrade with OTBI analysis using the Payables Invoice subject area?We have several reports using the Payables Invoices - Transactions Real Time subject area that are not working as they did before the 24A upgrade. As soon as a filter is…Kristina P 161 views 7 comments 1 point Most recent by Kristina P Payables, Payments & Cash Management -
Aakash Banka 11 views 1 comment 0 points Most recent by Aakash Banka Payables, Payments & Cash Management -
Payment Report with Discount AmountContent Hi All, Do you know if Oracle provides a seeded report that shows the discount taken on a payment due to a discount payment term? Thanks, Amy Version 20D -
How to get the PO number from AP Distributions in OTBI?Summary: We are creating an analysis using "Payables Invoices - Transactions Real Time" and when trying to get Purchase Order number from Invoice Lines, it appears blank…Arshad Hanif 31 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Need change in IDR Recognition ReportSummary: We need change in the input parameter option for selecting multiple business units as currently we are able to submit for only one BU Content (please ensure you…Srividya VVR 41 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
The drill down of the Payables reconciliation does not match the summary amount.We run the 'Payables to General Ledger Reconciliation' and then the Summary Amount of non-payables begin balance is $1979, as for the drill down its $11200. did anyone f…Reemalmurbaty 1 view 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
How to populate data in AP_IDR_RECOGNITION_DYD table used for IDR ReportSummary: We have a requirement for some changes in the "Invoice Documents Recognition Rate Report", when we tried to customize the report but AP_IDR_RECOGNITION_DYD tabl…Srividya VVR 31 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Bulk invoice attachment downloadSummary How does your company do when Tax team or Accounting team need to download hundreds or thousands invoice images and attachments for review and audit?Content Curr…User_V86IR 1.1K views 10 comments 2 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Where can I find successful/unsuccessful log in attempts to Oracle FinancialsI am looking for an audit report out of Oracle Financials Cloud (ERP) to capture some of the below information: -Changes to configuration settings within the application…RSkibitzki 21 views 2 comments 0 points Most recent by RSkibitzki Payables, Payments & Cash Management
-
Excel Bursting issues with Payables Payment Register reportSummary: Strange behavior in custom Payables Payment Register report Content (please ensure you mask any confidential information): I have customized the seeded 'Payable…
-
Invoice attachments URL link in AP Invoice reportSummary: User wants to have a URL link in AP Invoice report so that they can click the URL and see the invoice attachments. Content (required): User is not having the ac…
-
How to create positive pay file for outside checks recorded using Manual paymentSummary: Need to create positive pay file for payments recorded using Payment type = Manual while using the "create payment" functionality Content (please ensure you mas…Umakanth Saripalli 21 views 3 comments 0 points Most recent by James McBride Payables, Payments & Cash Management