R12: APXWTGNR: Withholding Tax By Tax Authority Report Displays Wrong Amount Subject (Doc ID 1310218.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Payables - Version: 12.0.1 to 12.1.3 - Release: 12.0 to 12.1
Information in this document applies to any platform.
Withholding Tax By Tax Authority Report - APXWTGNR

Symptoms

The following Withholding Tax reports are displaying wrong amount_subject_to_withholding:
    -Withholding Tax By Invoice Report
    -Withholding Tax By Payment Report
    -Withholding Tax By Supplier Report
    -Withholding Tax By Tax Authority Report

There are several cases which are not handled by the existing code of the report and they must be fixed:
    1) When the withholding group used against any invoice is of type amount ranges and the invoice
         amount falls in 2 amount ranges, then system will create two AWT distributions.

    2) Consider a Standard invoice with two item dists having same awt_group_id, then system will create
         two AWT dists each having different awt_related_id, but the awt_gross_amount value will be sum
         of  two item dists.

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