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:
Oracle Payables - Version 12.1.3 and laterOracle Payments - Version 12.1.3 and later
Oracle Financials for the Americas - Version 12.1.2 and later
Oracle Financials for Asia/Pacific - Version 12.1.3 and later
Oracle Financials for EMEA - Version 12.1.2 and later
Information in this document applies to any platform.
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:
- 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)
- Create an invoice and validate (Invoices -> Entry -> Invoices)
- 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |