R12: AP: 1099 Payments Report (APXT7RVT) - Poor Performance (Doc ID 1964794.1)

Last updated on JUNE 26, 2015

Applies to:

Oracle Payables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The 1099 Payments Report is taking a long time to complete, 310 minutes in a DEV env.  The report was run with the following parameters

 

Arguments
------------
P_GROUP_BY='Vendor'
P_BREAK_METHOD='Summary'
P_START_DATE='2014/01/01 00:00:00'
P_END_DATE='2014/12/31 00:00:00'
P_TAX_ENTITY_ID='10000'
P_FED_REPORTABLE='Y'
P_MIN_REPORT_FLAG='Y'
P_SET_OF_BOOKS_ID='1001'
P_QUERY_DRIVER='PAY'
------------

Cause

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