R12.2:JL: Colombian Payables Withholding Certificate Shows No Data

(Doc ID 2188192.1)

Last updated on SEPTEMBER 29, 2016

Applies to:

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

Symptoms

On : 12.2.1 version, Colombian Payables

Colombian Payables Withholding Certificate shows not data.


Expect to see data in the report.


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

1. Responsibility: Oracle Payables - Colombia localization
2. Path: Other -> Requests -> Run
3. Run the Colombian Payables Withholding Certificate ( JLCOPCWT.rdf)

There is no information in the report.

The issue occurs for all suppliers, invoices and periods.
The withholding taxes are calculated correct.
The issue is ONLY in the report.
The issue occurs in ALL instances and it has always occurred for Colombia.

It is working fine for Argentina.
The suppliers that appear in jl_ar_ap_awt_certif_all belongs to Argentina.

The issue has the following business impact:
Due to this issue, users cannot generate the withholding certificates for Colombia.

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