Reporting
Discussion List
-
sql query to get the Tax and Withholding Amount of AP InvoicesI'm working on retrieving the tax and withholding amount for each line in AP invoices. The AP_INVOICE_LINES_ALL table contains a TAX_RATE column that holds the required … -
How to Default First Party Tax Registration Number (FPTRN) on Payables Invoice in Fusion CloudI have followed the steps mentioned in the below links for defaulting FPTRN on Payables Invoice. But it has not worked for Manual & imported both the invoices. We have m…Jagjit Singh Arora 125 views 4 comments 0 points Most recent by Jagjit Singh Arora Payables, Payments & Cash Management
-
Einvoicing requirements for PhilippinesSummary: We have requirement to implement the electronic invoicing for Philippines. Therefore we would require the proper oracle documentation guide for that. Content (p…Jagnnor 3 views 1 comment 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
How to automatically email output of Child ESS Job to usersSummary:We are automating the Invoice Payment Functionality in Oracle Fusion Payables and business needs to get the output of "Payables Selected Installments Report" and…Satya Kr 13 views 1 comment 0 points Most recent by Daniela Petria-Oracle Payables, Payments & Cash Management
-
Ability to retrieve bank account updates from Audit table rest apiSummary: I would like to use the rest api to retrieve the Audit table entries for the Supplier bank accounts: Content (please ensure you mask any confidential informatio…Michael Preston 21 views 2 comments 0 points Most recent by Michael Preston Payables, Payments & Cash Management
-
How to exclude old unreconciled transactions from the Cash In Transit ReportSummary: We have just implemented the Oracle Fusion Cash Management Cloud Service module recently but our Oracle Fusion Payables and Payments Cloud Service, in addition …Juliet Soriao 41 views 4 comments 2 points Most recent by Krishna Rao Mankari Payables, Payments & Cash Management
-
24A Feature Payables Exceptions Listing ReportSummary: 24A Feature Payables Exceptions Listing Report Content (please ensure you mask any confidential information): There is a new feature in 24A Feature Payables Exc…SarahL 61 views 7 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
Is there an alternate way to obtain all records that add up to the Non-Payables Begin Balance?Summary: We are currently unable to obtain the details when we click on the drill down link from the Payables to Ledger Reconciliation to see which transactions make up …Rosa Alvarado 11 views 3 comments 0 points Most recent by Rosa Alvarado Payables, Payments & Cash Management
-
How to handle & symbol in payment file xsl templateSummary: Need to replace '&' symbol with 'and' in payee name and address fields. We have triedsrziffdavis 11 views 1 comment 0 points Most recent by Alexandra Tam -Oracle Payables, Payments & Cash Management
-
how to restrict access Payables Unaccounted Transactions and Sweep ReportSummary: Currently user do not have access specific to ledger he is able to run this report to another ledger - how to restrict access Payables Unaccounted Transactions …Murali Chimata 2 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Need url link for IDR Invoice attachments in AP InvoicesSummary: Need links to IDR Invoices to capture in the Reports. We are unable to get the URLs to the invoice images after the WebCenter is deprecation. Please advise how …Pradeepb 21 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Differences in column Non-Payables Begin Balance during payables to GL reconciliationSummary: Background details: GL Balances Uploaded till Dec-2023 Open AP Invoices Uploaded in Dec-2023 from Legacy Go-Live Date 1st Jan 2024 Now when we run "Payables to …Md Mosharraf Ali Raza 71 views 3 comments 0 points Most recent by Rosa Alvarado Payables, Payments & Cash Management -
Payroll Refernce Number in Cash ManagmentContent FRom where this Number is generated Means from where i can search based on this ? If navigation can be provided it will be helpful thanks Highlighted in attached… -
We need the ability to download Payables bulk invoice attachments for auditingWe need the ability to download Payables bulk invoice attachments for auditing. Can you please advise on the best method to do this?Baji.Guntupalli-Oracle 22 views 1 comment 0 points Most recent by Meghana Gaddam-Oracle Payables, Payments & Cash Management
-
Is There a Way to Customize the Payables Unaccounted Transactions and Sweep Report Output?Summary: Is it possible to customize the output of the Payables Unaccounted Transactions and Sweep Report that is run out of Scheduled Processes? We wanted to add some a…Brian Burns 11 views 1 comment 0 points Most recent by MariusS-Oracle Payables, Payments & Cash Management -
How is the Legal Entity (LE) field determined and populated in the AP interface table for IDR.Summary:Hi Team , How is the Legal Entity (LE) field determined and populated in the AP interface table/AP_INVOICES_INTERFACE specifically for invoices with the source '…Najeeb_ACN 161 views 4 comments 0 points Most recent by Shanmukha.Chitraju Payables, Payments & Cash Management
-
Localisation Patch for MexicoCould anyone tell if there is any localisation patch available for Mexico Implementation?
-
What is SrcDescriptiveFlexField?We are using the standard Oracle data model TransactionDocumentExtractDm to review Payment files for XML and standard remittance template building but are not sure what …Cam Mistry 21 views 1 comment 0 points Most recent by Stephen Westerfield-Oracle Payables, Payments & Cash Management
-
How to view invoice images after the deprecation of webcenterSummary: How can we view invoice images after webcenter is deprecated Content (please ensure you mask any confidential information): Looking for an alternative way to op…Mark Di Ponio 182 views 5 comments 0 points Most recent by Ahmad Alawneh Payables, Payments & Cash Management
-
invoice approval report with signatures of all approversHi, Business requirement is to create a payable invoice pdf template with signatures of all approvers. Currently we are having signatures on PO pdf output but only of la…Rahim Azam Butt 1 view 1 comment 0 points Most recent by Bogdan Nita-Oracle Payables, Payments & Cash Management
-
Can we customize the Collections Dashboard in the AR module to display a new column?Summary: We are exploring the possibility of customizing the Collections Dashboard in the Accounts Receivable (AR) module to display a new column. This column would cont… -
Table details to get Business unit for a tax code definedSummary: We need table or query to fetch business unit name for the given tax rate code. Content (required): Version (include the version you are using, if applicable): …Nishanth B Jain 121 views 4 comments 0 points Most recent by Nishanth B Jain Payables, Payments & Cash Management -
Report to Identify all Team Members who have Coded in APSummary: We are trying to free up licensure in ERP and need to remove people who are not a part of AP or no longer coding invoices for thier departments. Is there a way …THawkins_LGI 1 view 1 comment 0 points Most recent by Catalina Dragu-Oracle Payables, Payments & Cash Management -
Is there a report I can run in Oracle that can tell me who is submitting invoices/wiresSummary: Is there a report I can run in Oracle that can tell me who is submitting invoices/wires? Content (please ensure you mask any confidential information): Version …Pablo Schenquerman 1 view 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
Load and Import Bank Statement Warning messageSummary: Hi Team, We are loading the bank statement using SOAP Services to run the "Load and Import Bank Statement" process. We are using a BI report to fetch the error …Rajeev Nayan 11 views 3 comments 0 points Most recent by Neha Garg-Oracle Payables, Payments & Cash Management
-
Is it possible that Accounting date as Last approval date instead of invoice date?Summary: Accounting date will be the last approval date can we achieve this requirement? what is the implications? Content (please ensure you mask any confidential infor…Eswarvoona-Oracle 1 view 2 comments 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
OTBI report - display "in progress" payments process requestsSummary OTBI report - display "in progress" payments process requestsContent Hi, I'm trying to create an OTBI report that shows invoices relating to a payment process re…
-
Unable to track the changes made in BPM rules through audit reports when migrated from SOA composerSummary: We are trying to track the changes made in BPM rules. We are able to get the details in audit report when we are updating the rules manually but when the change…Surendra Rodge 11 views 1 comment 0 points Most recent by Cosmin Nadolu-Oracle Payables, Payments & Cash Management
-
What Disbursement Payment file format can we use for Canadian Payments Association Format - 005?Summary: Which of the available seeded payment file formats in Oracle Cloud can we use if the format required by our client's bank is in CPA-005 format? Content (please …Christian Roxas 1 view 1 comment 0 points Most recent by Lakshmish Rao-Oracle Payables, Payments & Cash Management
-
AP Hold Report that includes Invoice information plus PO numbers, PO line numbersSummary: We need an AP Hold Report that includes PO numbers, PO line numbers, invoice details, and quantity comparisons to identify invoices on hold due to "Billed quant…SBJ_PPM_1210 11 views 2 comments 0 points Most recent by SBJ_PPM_1210 Payables, Payments & Cash Management