Reporting
Discussion List
-
Why is my 1099 Copy B masking the receipient TIN incorrectly?Summary: When we run the US 1099 Report, the Copy Bs are masking the recipient TINs incorrectly. It is showing the first 4 digits of the TIN at the end of the asterisks.…Ashley Raymer 1 view 1 comment 0 points Most recent by Ashley Raymer Payables, Payments & Cash Management -
How to enable "AP Analytics" tile/feature in Payables Oracle Cloud?New Oracle Demo instance shows an "AP Analytics" tile under Payables tab in Oracle Cloud, though I cannot find any information online on how to enable it. Does anyone ha… -
Can we create custom reports for IDR recognition report?Summary: The seeded report contains merged fields which prevents us from sorting and gathering data which would allow us to target suppliers that have a lower recognitio…Lisa Poore 102 views 4 comments 0 points Most recent by Hector Martinez PWC Payables, Payments & Cash Management -
Tax Audit Report - Std report not following the data access setHello Everyone, I was running this standard report and noticed that it did not respect Data access set. To replicate this issue we can do the below: Navigate to schedule…Keerthy Ashish 10 views 0 comments 0 points Started by Keerthy Ashish Payables, Payments & Cash Management -
AP invoice scripts -how to Link item line with tax lineSummary: AP invoice scripts -how to Link item line with tax line Content (please ensure you mask any confidential information): Invoice #1 got 3 item lines and 3 tax lin… -
Supplier Balance Aging Report oracle standard report customizationSummary: We are experiencing issues while exporting the report in excel format when there is huge volume of invoice data and output xml file size is exceeding 1gb. We ar…Swapnil_Mangnalikar 2 views 0 comments 0 points Started by Swapnil_Mangnalikar Payables, Payments & Cash Management -
How to process 1099 DIV, 1099 INT, 1099 K and 1099 S from Oracle FusionSummary: How can we process 1099 DIV, 1099 INT, 1099 K and 1099 S forms from oracle fusion? Content (please ensure you mask any confidential information): Version (inclu…Pranav7607 381 views 10 comments 2 points Most recent by Krishna Kanth Kommuru Payables, Payments & Cash Management -
2025 changes to 1099 MISC and NEC formats not delivered in 25D releaseThere are changes to US 1099 Report for MISC and NEC formats for 2025. We were expecting Oracle to deliver the updates by 25D release. However, we observed that the upda…Pawan.Shetty 37 views 0 comments 0 points Started by Pawan.Shetty Payables, Payments & Cash Management -
Exclude payments in voided status from the create accounting process reportHi, For year-end closing, we have AP invoices in the "Cancelled" status and payments in the "Voided" status. To exclude these invoices from the "Create General Ledger" r…ElenaVM 1 view 3 comments 0 points Most recent by HD - Fusion ERP-Oracle Payables, Payments & Cash Management -
Customize Seeded Infolets as per business requirementSummary: Customize Seeded Infolets as per business requirement Content (please ensure you mask any confidential information): Business would like to see Recent Invoice c… -
Is it Possible to e-mail Selected Installments Report When User Initiates Payment Process Request?Summary: Is it possible to automatically e-mail the Payables Selected Installments Report when a user initiates a Payment Process Request? The report generates automatic…Brian Burns 2 views 1 comment 0 points Most recent by Glen Ryen 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 21 views 3 comments 0 points Most recent by EmmaAndersonTX Payables, Payments & Cash Management -
Income Tax Region population at Invoice Distribution levelhi Folks, I have income Tax region column populated at Invoice distribution level. Which is causing multiple records for a supplier in 1099 EMF report. When I tried to r…BalabhadruniBharat 1 view 0 comments 0 points Started by BalabhadruniBharat Payables, Payments & Cash Management -
1099B reportingSummary: As there is a requirement for suppliers to generate the 1099-B form, is it possible to handle 1099-B reporting within Oracle Fusion? If so, how can this be achi… -
Check print using Dot Matrix printer on Oracle FusionSummary: Unable to print a check on a Dot Matrix printer. Content (please ensure you mask any confidential information): We are attempting to print a preprinted bank che…Dinesh_Mani 51 views 2 comments 3 points Most recent by Shwetha Shankar Payables, Payments & Cash Management -
subledger period close Exception Report in terms of Ledger ViewHi Team, we have a Primary Ledger (A) and many associated Secondary ledgers like B, C, D etc. When we create any Transactions in subledger modules like AP, AR, leases et…Santosh Kolisetty 1 view 0 comments 0 points Started by Santosh Kolisetty 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 21 views 4 comments 0 points Most recent by Clare Farris Payables, Payments & Cash Management -
Can we rerun the BIP report automatically from Reports and Analytics when its is failedSummary: Some of our BIP reports that are scheduled from Reports and analytics (No ESS jobs created) fails during SFTP connections while transferring the report output t… -
List of Import Payables Invoices Report Rejection MessagesSummary: Is there a document or a listing that provides the list of rejection messages when interfacing invoices? Content (please ensure you mask any confidential inform…Christian Roxas - PWC 21 views 1 comment 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management -
Table to extract taxpayer id details for suppliers of individual typeSummary: Table to extract taxpayer id details for suppliers of individual type Content (required): Table to extract taxpayer id details for suppliers of individual type.…Vinothini 861 views 2 comments 0 points Most recent by User_FXECS Payables, Payments & Cash Management -
Query to fetch Approvals Groups Across Workflow ModulesSummary: We need to update a workflow approval group. I’d like a query that shows, by module, every workflow rule that will be affected by this change. Exemple: Approval…usr_a.nv 41 views 6 comments 0 points Most recent by Kate D.B-Oracle Payables, Payments & Cash Management -
Could you please share any OTBI AP Dashboard ?Summary: Could you please share any OTBI AP Dashboard ? Content (please ensure you mask any confidential information): Hello Could you please share with me any seeded OT…martingabriel Kinovisques 11 views 1 comment 0 points Most recent by RVohra Payables, Payments & Cash Management -
How to join CE_STATEMENT_LINES, CE_RECON_HISTORY, CE_RECON_HISTORY_ITEMS, AP_CHECK_ALLWe are building a BI publisher report to list Bank Statement Number, Bank Statement Line, Statement Line Amount, AP Payment Number Using the tables CE_STATEMENT_HEADERS …Pradeep Kumar Reddy V 81 views 3 comments 0 points Most recent by luke.syv8 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 301 views 7 comments 0 points Most recent by Mehak Soni Payables, Payments & Cash Management -
1099k reportingSummary: As there is a requirement for suppliers to generate the 1099-K form, is it possible to handle 1099-K reporting within Oracle Fusion? If so, how can this be achi…Dhruba 41 views 3 comments 0 points Most recent by SherameAnderson Payables, Payments & Cash Management -
FOS Source Intercompany AP invoice is not same as the converted AR invoice number due to Doc sequThe FOS source transaction when sent In Receivables to create invoices, the FOS Intercompany AR invoice number is getting converted to a new Txn number based on the docu…Sudhanshu Rai 31 views 1 comment 2 points Most recent by Abhinav Garud Payables, Payments & Cash Management -
Is there a way to exclude certain conversion transactions from showing up CashtoGLRecon report?There are Conversion invoices from April 2022, that are automatically getting reconciled with current period transactions, and when unreconciled they show up in the Cash…Ameen Shoaib 11 views 0 comments 0 points Started by Ameen Shoaib Payables, Payments & Cash Management -
Create Tree nodes using global DFFSummary: I am planning to use global DFF field manage values as Tree node values on a custom Tree hierarchy. I have downloaded DFF Flex field archive to get the business… -
Is there any report for Remittance Advice Delivery Email ID by supplier siteSummary: Report for remittance advice delivery email ID by BU Content (please ensure you mask any confidential information): Hi Team We required to update and add more e…JL-JL 111 views 5 comments 0 points Most recent by Emily Downum Payables, Payments & Cash Management -
Validate Payables Invoices process to exclude manual invoicesHi Team, One of our customers requesting to exclude manual and IDR invoices from validation through Validate Payables Invoices process. Could you please confirm whether …Chanikya Neelam-Oracle 26 views 2 comments 0 points Most recent by Chanikya Neelam-Oracle Payables, Payments & Cash Management