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 170 views 12 comments 1 point Most recent by Michael_ Payables, Payments & Cash Management -
US 1099 report ESS job continues to end in error statusSummary: Attempted to run the US 1099 report and it has failed three times in a row. The associated "US 1096 Report" (APXTRF96) report as well as the "US 1099 Payments R…User_2025-02-05-22-11-22-331 101 views 2 comments 0 points Most recent by Paramkusa Payables, Payments & Cash Management -
In Oracle Fusion, what is the impact of Renaming Business Unit on Cash Management?Summary: We are currently implementing Oracle Fusion for one of our clients. The implementation includes multiple Legal Entities, with one Business Unit (BU) per Legal E…Jers Agbanlog 21 views 3 comments 0 points Most recent by Shouryadeep12-Oracle Payables, Payments & Cash Management -
Getting Error when trying to print 1099sSummary: When I run the US 1099 Media Report it fails and I receive this message below. I have checked the supplier record and it is 9 digits and correct. How can I corr…Kendra Patterson 1 view 1 comment 0 points Most recent by RVohra Payables, Payments & Cash Management -
US 1099 ReportPlease note we are unable to see data in any of the seeded US 1099 template but see data in XML download. Let us know if anyone noticed similar issue. We are on 23C rele… -
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… -
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… -
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 111 views 4 comments 0 points Most recent by Hector Martinez PWC Payables, Payments & Cash Management -
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 1 view 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 392 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 66 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… -
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 879 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 12 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 91 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 302 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