Reporting
Discussion List
-
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 174 views 5 comments 0 points Most recent by Rasheed - Fusion Support Engineer-Oracle 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 11 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management
-
ACTION REQUIRED notification still appears on the bell icon of the approver for weeksThe approver has approved the approval notification and the invoice is now pending with other approver in the workflow. The Action required notification still appears on…KanikaGupta 156 views 5 comments 0 points Most recent by Shakkir K.K Payables, Payments & Cash Management
-
how to check Invoice is Accounted or not in Invoice Header Table AP_inovices_AllSummary: how to check Invoice is Accounted or not in Invoice Header Table AP_inovices_All Content (required): Business wants to see the list of invoices in BI Report whe… -
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 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 29 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 22 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 54 views 4 comments 2 points Most recent by Krishna Rao Mankari 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 1 view 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 33 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 81 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… -
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 178 views 4 comments 0 points Most recent by Shanmukha.Chitraju Payables, Payments & Cash Management
-
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 184 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 3 views 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 133 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 2 views 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 14 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 6 views 1 comment 1 point 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 -
Client request to provide report/job information on recent releases for financialsSummary: Client request to provide report/job information on recent releases for financials, is there way to check Content (please ensure you mask any confidential infor…
-
How to include attribute defined in Manage Legal Entity in Separate Remittance Advice Report.Summary: We are creating a custom template for Separate Remittance Advice Report. I want to include attribute defined in Manage Legal Entity in Separate Remittance Advic…Binod Kumar 61 views 2 comments 1 point Most recent by User_L4A7A Payables, Payments & Cash Management