My Oracle Support Banner

Error In Calculating Withholdings AP Invoice (Doc ID 1526039.1)

Last updated on AUGUST 19, 2020

Applies to:

Oracle Financials for the Americas - Version 12.1.2 and later
Information in this document applies to any platform.


On : 12.1.2 version, Brazil AP Globalization

Invoice Distribution Withholding shows no data.

Expect to see data in the Invoice Distribution Withholding

The issue can be reproduced at will with the following steps:

1. Responsibility: Oracle Payables - Colombia localization
2. Path: Invoices -> Entry -> Invoices
3. Create an invoice and save.
4. Go to the Distributions
5. Go to Invoice Distribution Withholding

There is no data.

The issue occurs for all transactions without purchasing order, and for all with taxes.

6. Customer's analyses

The trace has led to APPS.JL_ZZ_AP_AWT_DEFAULT_PKG package. Specifically Supp_Wh_Def_Line procedure.

If he confront the invoice line against a purchase order It generates the withholding tax, otherwise it creates no withholding tax.
The difference is in the structure descriptive of invoice distributions, when using purchase order there is no need to fill it.
But when you fill it (not using purchasing orders), It does not generate the withholding tax. He has seen that this set values JLCO_AP_THIRDPARTY_ID,
record the vendor number in the GLOBAL_ATTRIBUTE2, but the procedure Supp_Wh_Def_Line expects a number.
The system saves an varchar, but the function expects a number.

In the test environment he has passed a null to the parameter p_tax_payer_id in procedure Supp_Wh_Def_Line, and It calculates the withholding tax in all cases.

The issue has the following business impact:
Due to this issue, users cannot calculate the withholding tax.


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

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