Reporting
Discussion List
-
Prepayment Status ReportSummary: Is there any seeded Oracle report which gives the list of all prepayment invoices for all suppliers with the details like total number of prepayment invoices, l…MihirS 536 views 8 comments 0 points Most recent by Geo Narvaez Payables, Payments & Cash Management -
Query to find the approver name for AP invoicesWhat is the query or table name where we can find the approver name and approval date(action date) for an AP invoice. The table ap_inv_aprvl_hist_all gives the approver …KanikaGupta 6K views 4 comments 2 points Most recent by User_QTQ8P Payables, Payments & Cash Management
-
Not able to find Void Payment Register Report in fusion PayablesSummary: We are not able to find Oracle seeded 'Void Payment Register Report' in fusion Payables Content (required): We need a report which shows who void the payment, V…Suresh Kothapalli 139 views 4 comments 4 points Most recent by DeepM Payables, Payments & Cash Management
-
Prepare Payable to general ledger reconcilation subprocss errorSummary: I scheduled the "Prepare Payables to General Ledger Reconciliation" ESS job to run for one month. However, the "Payables to General Ledger Reconciliation" repor…NarasimhaPalla 23 views 1 comment 0 points Most recent by MiaM-Oracle Payables, Payments & Cash Management
-
US 1099 Electronic Media Report ends up in errorSummary: We tried to run US 1099 Electronic Media Report. But it ends in error. Content (required): We tried to run US 1099 Electronic Media Report. But it ends in error…HiteshChugh 80 views 6 comments 0 points Most recent by Surbhi Jaiswal Payables, Payments & Cash Management
-
Payment File name with Date/Time Stamp in Payment Process ProfileSummary: Payment File name with Time Stamp in Payment Process Profile Content (required): Business would like to send Payment file along with Date & Time Stamp. I update…Kumar 57 1.2K views 6 comments 0 points Most recent by Ravi Guda Payables, Payments & Cash Management -
Table with error messages and warnings of Supplier Bank Accounts FBDI ImportContent Does anyone know if the error messages and warnings of the Supplier Bank Accounts FBDI Import are stored in a base table of which we can report through BI Publis…User_CR41D 725 views 8 comments 2 points Most recent by Ankit.K Payables, Payments & Cash Management
-
How to Schedule a Report (.rep) File in Oracle Fusion?Summary: -How to Schedule FR Reports When Report Is Not Visible in the Selection Step? Content (please ensure you mask any confidential information): Hello, Before posti…Chuleeporn Janthorn 14 views 1 comment 0 points Most recent by Anca A-Oracle General Ledger & Intercompany
-
AP to GL Recon report- Previous month "Accounted invoices" showing as variance if any manual holdsSummary: AP to GL Recon report- Previous month "Accounted invoices" showing as variance if any manual holds Content (please ensure you mask any confidential information)…
-
Schedule Payables Exception Listing ReportSummary: Hi Team is there a way to schedule Payables Exception Listing Report? The report can only be run from Invoice task area and it does not show any scheduling opti…ShrutiSood 20 views 9 comments 0 points Most recent by ShrutiSood Payables, Payments & Cash Management
-
IDR invoice rejected in import reportSummary: Hi all, we have sent one invoice for IDR processing, the invoice pdf was more than 30 MB because of which IDR didnt process it, as it has mximun size limitation…Harshika Sethi 19 views 1 comment 0 points Most recent by Pete Park-Oracle Payables, Payments & Cash Management
-
Custom Remittance Advice Template not appearing in Manage formatsSeparate Remittance advice do not have a data model. I have created a custom template that in BI publisher in custom folder custom>financials>payments, but my custom tem…KanikaGupta 144 views 2 comments 0 points Most recent by GIRIJA BODLA 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 115 views 11 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management -
EMPLOYEE supplier type not generating 1099 reportsSummary: 1099 reports will not generate for employees of supplier type EMPLOYEE. Should employees of supplier type EMPLOYEE be able to have 1099 MISC and 1099 NEC report…Alexinmn 16 views 1 comment 0 points Most recent by Edgar Nieto-Oracle Payables, Payments & Cash Management
-
We need show Invoice Distribution COA Account segment values on AP CheckSummary: We need to show Invoice Distribution COA Account segment values on AP Check in Fusion Cloud Accounts Payable. These fields are not available in XML. I cannot ad…Ibrahim Konak 26 views 1 comment 0 points Most recent by AnamariaRoman-Oracle Payables, Payments & Cash Management
-
Payment template informationSummary: Looking for a SQL query that will give me all the information selected on our payment templates rather than returning 'Specify' or 'All' ie indicating which pay…Clare Farris 9 views 2 comments 0 points Most recent by Clare Farris 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_2025-02-11-20-21-37-906 1.8K views 21 comments 3 points Most recent by Ranga Swamy Ediga Payables, Payments & Cash Management -
OTBI Report for Current Invoice ApproverSummary: I am trying to build an OTBI report that shows invoices that are pending approval along with the name of the current approver. For the most part, I have been ab…Neal Foley 517 views 5 comments 0 points Most recent by MLubbert Payables, Payments & Cash Management
-
How do we produce a single 1099 for a vendor despite having balances in legacy and Fusion?Client wants to produce a single 1099 at year-end for each eligible vendor, despite cutting over to Fusion mid-year. Wanting to find out if we have any options to do thi…jeff.ziemer 1 view 1 comment 0 points Most recent by James McBride 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…
-
Add an Email Body to Separate Remittance Advice Emails with attached PDF by using BI ?Summary: Since there's still no Email Body feature available when using Separate Remittance Advice Emails with attached PDF -but- is it maybe possible to add an Email Bo…Marcus S. 35 views 3 comments 0 points Most recent by Sankalp Gupta Payables, Payments & Cash Management -
How to get XML extract "Funds Capture Payer Notification" ReportIs there any way or SQL query to get XML extract for Funds Capture Payer Notification There is a sample provided from Oracle but we want actual one. Is Any XML Output Fo…CA Nirmal Choudhary 4 views 1 comment 0 points Most recent by CA Nirmal Choudhary Receivables & Collections -
any report available for Third-Party Payment RelationshipsSummary: Is there any standard Oracle report available that captures Third-Party Payment Relationships, including payments made on behalf of others (TPA), with details s…
-
Supplier Balance Aging Report Fix for As-of-DateSummary: Supplier Balance Aging Report Fix for As-of-Date says Code fix is included in 11.13.20.04 via Bug 21330471 but data model still does not show the change Can som…Mona Mantry 12 views 0 comments 0 points Started by Mona Mantry Payables, Payments & Cash Management -
requirement to track spends for certain suppliersSummary: Hello All, We have a requirement to track spends for certain suppliers in which client wants to tag suppliers with certain keywords (related parties). Additiona…
-
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 88 views 4 comments 0 points Most recent by Antony N123 Payables, Payments & Cash Management -
Check Printing OverflowHi All, We have a client requirement to print checks and their respective invoices in two different printer trays. And the format is one check page followed by one or mo…NagarajM 22 views 1 comment 0 points Most recent by GSrikanth -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… -
IBY - Include PRIMARY National ID in Disbursement XML /Payment File to bankContent Requirement - To include NATIONAL ID in the payment file sent to certain banks. * NATIONAL ID is then used by banks to do validations at their end before making …
-
Fusion Expenses - Expense Clearing AccountSummary Expense Clearing AccountContent Hello : I have the following document regarding fusion expenses, however the accounting is still not very clear. Can you send me …gabriel kinovisques-163562 233 views 5 comments 0 points Most recent by NikitaLarson Payables, Payments & Cash Management