Reporting
Discussion List
-
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…Kumar 57 344 views 2 comments 0 points Most recent by Basavaraj N Payables, Payments & Cash Management -
Which is the table that will contain all the details of the Payment Templates created in FusionSummary: We have a requirement to write a report to pull all the details of all the payment templates created in Fusion. Would someone be able to help us with which tabl… -
How to get box 7 on 1099-MISC checked?I'm unable to find a way to get box 7 on form 1099-MISC checked. It looks like before the 2020 change, this was supported through the use of the MISC9 tax code. Looking …JessicaSF 31 views 4 comments 0 points Most recent by JessicaSF Payables, Payments & Cash Management
-
US 1099 Invoice Exceptions Report Showing Incorrect/Weird Formats for the AmountsHello, Does anyone know how we can correct the column formatting for the US 1099 Invoice Exceptions Report? US 1099 Invoice Exceptions Report – The Invoice Amount and Li…Julia Looi 2 views 1 comment 0 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management -
US 1099 Payments Report Showing Incorrect/Weird Formats for the DateHi, Has anyone come across the following issue? Our US 1099 Payments Report is showing weird values for the Date field. The look like merge field values but I do not kno…Julia Looi 1 view 1 comment 0 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management
-
How to update US 1099 Report for custom Format layoutSummary: My team has a requirement to add some custom updates to the Oracle generated US 1099 report. The need is to have multiple sections. The top 1/3 of the page bein…Tim Smith99 233 views 2 comments 0 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management
-
Is there anyone who is open to sharing step-by-step instruction how to prepare 1099 filing report?Hello, We have almost new Oracle end users support Accounts Payable. We need help or instruction how to prepare or create US 1099 Tax report for 2023 tax filing. Detail …Cris_Yee_Allenite 31 views 2 comments 0 points Most recent by Cris_Yee_Allenite Payables, Payments & Cash Management -
How to resolve no State for International address for 1099 FilingHi, On the 1099 Supplier Exception report, we have an exception message of 'No State' and the address we have on file is correct as it is an International address. Other…Cris_Yee_Allenite 11 views 2 comments 0 points Most recent by Cris_Yee_Allenite Payables, Payments & Cash Management
-
How to configure AP Level Tax if the PO Bill to location is not same as ship to location in PO LevelSummary: Hello Oracle Experts! As per our business process, in all the cases the Bill to Location (state) is not same as the Ship to Location (state) which is captured a…Lokesh_619 21 views 1 comment 0 points Most recent by Lokesh_619 Payables, Payments & Cash Management
-
Which Table Stores 'Payment Number' in Manage Payments TaskSummary: We need table details which stores 'Payment Number' in Manage Payments task. Content (please ensure you mask any confidential information): Version (include the…Sunghpark 32 views 4 comments 0 points Most recent by Sunghpark Payables, Payments & Cash Management
-
Country for Foreign Addresses Not Displaying on 1099 FormsHello, Does anyone know how I can get the Country to display for Foreign Addresses on the 1099 Forms? Thank you, JuliaJulia Looi 11 views 2 comments 0 points Most recent by Julia Looi Payables, Payments & Cash Management
-
Requirement to bulk update Remittance Advice Delivery Method & appropriate 'Email' to all suppliersSummary: Requirement to bulk update Remittance Advice Delivery Method as 'Email' and corresponding Remittance Advice Delivery Email ID for all suppliers. I have seen an …Pradeep T H 147 views 7 comments 0 points Most recent by Alex D-Oracle Payables, Payments & Cash Management
-
How to extract payables data in external serversWe have a requirement to store the payables data in the external servers. So right now we are able to send the data into the UCM. From UCM how can we transfer data into …Dara Nagasai 11 views 3 comments 0 points Most recent by ThomasKorbecki Payables, Payments & Cash Management -
Various Types of Invoice Status for PayablesSummary: We have a requirement to build a custom report which shows various types of Invoice Status from Payables. Can anyone please share the list of all type of status…MihirS 22 views 1 comment 0 points Most recent by Sowmya Bonala-Oracle Payables, Payments & Cash Management
-
Provision for taxes withheld in APSummary: Is there a temporary table that shows the taxes to be withheld in an NF in AP? Since the tax will be withheld at the time of payment, but there is a need to kno…Ísis Franco 2 views 2 comments 0 points Most recent by Ísis Franco Payables, Payments & Cash Management
-
Items Revaluation ReportSummary: Hi, How to list all documents associated with Revaluation Report (Receivables and Payables) in a single(custom) output?. We need to print additional information…Camilo Reyes 22 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
Payables Invoice and Supplier Balance Aging reports complete in ErrorSummary: Content (required): Hi, We have created a custom role to run AP related reports. It includes the below privileges and duty roles; Privileges Submit Payables Inv…Sheneli98 191 views 7 comments 0 points Most recent by CA Nirmal Choudhary Payables, Payments & Cash Management
-
PAIN002 Banking Acknowledge ProcessingSummary Bank Acknowledge Process using the PAIN002 xmlContent Hi, I have never used the Bank Acknowledge Process using the PAIN002 xml format. I want to know if we can u…User_Nag 59 views 5 comments 3 points Most recent by Nahuel Borrelli-Oracle Payables, Payments & Cash Management
-
Check Print alignment issueSummary Check Print alignment issueContent We came across situation where when we are printing multiple cheks (Here we get direct option in application to print the chec…Vaibhav DL 197 views 6 comments 2 points Most recent by Glen Ryen Payables, Payments & Cash Management
-
Audit report for bypass approvalsSummary: Is there a report available in Oracle that can provide bypass approval details ( approver and date) for requisitions and non-PO backed invoices? Content (requir…Madhuri Kota 36 views 1 comment 0 points Most recent by Sowdha Murugan Payables, Payments & Cash Management
-
How can we define. aba format file for payments?We have a third-party vendor who validates the payment file in ABA format before a payment file is shared with the bank. So, our request is how do we generate an. aba fo…
-
1099 Legal addresSummary: Purposes on 1099 legal address Content (required): I can see in Doc ID 1999746.1 that the Tax Reporting Site is the site that has its address used for printing …G777 14 views 3 comments 0 points Most recent by Dhaval Patel-Oracle 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…PoojaK 32 views 2 comments 1 point Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management
-
1099 template customizationWe are using external software to report 1099 but data will be extracted from the existing Oracle 1099 data model. We would like to create new template but we are unable…Priti Davda 21 views 1 comment 0 points Most recent by Dhaval Patel-Oracle Payables, Payments & Cash Management
-
How To Update the CFDI Number on AP Payments for MexicoSummary: How to update the CFDI in Payments not in a manual way. Content (required): As requirement in Mexico, it is required to capture information related to the elect…Padmajarani 1 view 1 comment 1 point Most recent by NancyR_Bravo Payables, Payments & Cash Management
-
Additional 1099 after electronic filingSummary Need to know how to create elec file for additions/corrections for 1099sContent We have already filed our 1099s for 2018 with the IRS electronically, and have ne…User_II3DX 58 views 4 comments 0 points Most recent by Veerasekhar Divvi Payables, Payments & Cash Management
-
province tag is missing in Payee/Address/ level in Payment xml though value exists in setupSummary: In Oracle Cloud, Not able to see Province tag in Payee/Address/ in the Disbursement Payment File Format standard xml output even though value exists in the supp…Chowdari Malapati Monika 22 views 5 comments 0 points Most recent by Chowdari Malapati Monika Payables, Payments & Cash Management
-
How to setup an Invoice approval for new line type "Rate Based Services" ?Summary: How to setup an Invoice approval for new line type "Rate Based Services" ? Content (please ensure you mask any confidential information): Hello We have two diff…Cesar Saveedra 25 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management
-
Request that the US 1099 Electronic Media Report Republish in necessary txt format for the IRSSummary Republish US 1099 Electronic Media Report in txt format necessaryContent The IRS requires the US 1099 Electronic Media Report be uploaded to the IRS FIRE system …jamiewilmoth 51 views 2 comments 0 points Most recent by Dahlia Gaggan Payables, Payments & Cash Management
-
Last Update Date at APlines is not changing after project information is updated at AP invoice linesSummary: Last Update Date at invoice lines is not changing after project information is updated at AP invoice lines, Is it Oracle intended functionality? Content (please…MANOJVERMA090908 12 views 1 comment 0 points Most recent by Vinay Galithoti-Oracle Payables, Payments & Cash Management