R12: AP/IBY/JA/JL/JE: Fully Paid Invoices with Automatic Withholding Tax (AWT) Show on the Accounts Payable Trial Balance Report with a +/- 0.01 Balance (Doc ID 2961609.1)

Last updated on JULY 14, 2023

Applies to:

Symptoms

Fully Paid Invoices show on the Accounts Payable Trial Balance report with  a +/-0.01 amount remaining.

This issue only happens if:

• The payment created AWT (Automatic Withholding Tax)
• The "JG: Product" profile option is set to a value
• At the time the payment was created the version of the AP_CUSTOM_WITHHOLDING_PKG package (apcmawtb.pls) is either 120.3.12010000.8 or 120.8.12020000.6

To get the current version of the package run

 To replicate:

1. From a Payables Responsibility that has the "JG: Product" profile option set and that's setup for localizations (see the localizations guide for full localization setup)
2. Create an invoice and validate (Invoices -> Entry -> Invoices)
3. Pay the invoice (Payments -> Entry -> Payments)

Whether the issue will happen or not depends on the amounts on the invoice, and the Withholding rate applied.  Also, certain countries (like Argentina) have their own AWT calculation so this particular issue will not happen.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.