How to Perform a Mass Update of NULL Income Tax Types for Federally Reportable Suppliers (Doc ID 987031.1)

Last updated on MARCH 01, 2016

Applies to:

Oracle Payables - Version 11.5.10.2 and later
Information in this document applies to any platform.
APXT7UTT.rdf

Goal

Many Invoices are not being reported in the 1099s. The Invoice Exception report shows that these invoices are listed in the section "Invoice Distribution Lines for 1099 Suppliers with No Income Tax Type". 

Further research indicates that the field Income Tax Type in the distributions window, which maps to the column AP_INVOICE_DISTRIBUTIONS_ALL.Type_1099, are blank.

Is there some way to populate these distributions with the default defined in the Supplier record without having to query each invoice and distribution separately?

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms