Argentine Payables Withholding Certificate (JLARPCWT) Shows No Output (Doc ID 1599567.1)

Last updated on OCTOBER 02, 2024

Applies to:

Symptoms

• Argentine Payables Withholding Certificate (JLARPCWT) shows no output.
   
• There is no record in JL_AR_AP_AWT_CERTIF_ALL table even though Argentina Localization is working fine and calculating withhold tax correctly.
       Note:  If there are records in JL_AR_AP_AWT_CERTIF_ALL, check the supplier to confirm that it has been defined as a Legal Address.
   
• The issue occurs for both, quick payments and payment batches (payment is confirmed).
   
• It occurs for new invoices/payments.
   
• There is no workaround available.

Steps to Reproduce:
1. Responsibility: Oracle Payables - Argentine localization 
2. Path: Other -> Requests -> Run
3. Run the Argentine Payables Withholding Certificate

Changes

Run following SQL statement (which is the Main SQL Query in report) and check if it returns any record:

Select
jaac.awt_type_code awt_type_code, rtrim(substr(jaac.bank_account_num,1,15),' ')||
' - '||rtrim(substr(jaac.payment_document_name,1,15),' ')||
' - '||rtrim(substr(jaac.check_number,1,15),' ') payment_reference,
jaac.payment_document_name payment_document_name, jaac.check_number check_number, jaac.certificate_number certificate_number, jaac.certificate_number certificate_number_NUM, jaac.awt_date withholding_date, jaac.tax_name tax_name,
(jaac.withholding_amount*(-1) + nvl(jaac.credit_amount,0)) withholding_amount, jaac.credit_amount * (-1) credit_amount, abs(jaac.taxable_base_amount) taxable_base_amount, (jaac.withholding_amount* (-1)) total_awt_amount, jzat.jurisdiction_type jurisdiction_type, jzat.description description, jzat.taxable_base_amount_basis taxable_base_amount_basis, jzat.certificate_header certificate_header, jzat.credit_letter_flag credit_letter_flag, atc.global_attribute7 zone, atc.description description_tax_name,
jzat.description withholding_type_description, xle.name Company_name, xle.address_line_1 Company_address_line_1, xle.address_line_2 Company_address_line_2, xle.address_line_3 Company_address_line_3, xle.country||'-'||xle.postal_code||'-'||fl.meaning Company_address_line_4, xle.registration_number CUIT_or_Tax_Id_Number_13, pv.vendor_name Supplier_Name, pvs.address_line1 Supplier_address_line_1, pvs.address_line2 Supplier_address_line_2, pvs.address_line3 Supplier_address_line_3, pvs.city||' - '||pvs.zip||' - '||pvs.country Supplier_address_line_4, substr(replace(nvl(papf.national_identifier,nvl(pv.individual_1099,pv.num_1099 )),'-'),1,2)||'-'||substr(replace(nvl(papf.national_identifier,nvl(pv.individual_1099,pv.num_1099)),'-'),3)||'-'||pv.global_attribute12 Supplier_CUIT, jzat.province_code province_code, xle.registration_number comp_primary_id_number, jzat.tax_authority_id comp_tax_authority_id, jcat.tax_authority_type comp_tax_authority_type, nvl(papf.national_identifier,nvl(pv.individual_1099,pv.num_1099))
supp_primary_id_number, jzat.tax_authority_id supp_tax_authority_id, jsat.tax_authority_type supp_tax_authority_type
from
jl_zz_ap_supp_awt_types jsat, po_vendor_sites_all pvs, po_vendors pv, jl_zz_ap_awt_types jzat, jl_ZZ_ap_comp_awt_types jcat, xle_firstparty_information_v xle, ap_tax_codes_all atc, jl_ar_ap_awt_certif_all jaac, fnd_lookups fl,
(select distinct person_id ,national_identifier from
per_all_people_f WHERE trunc(sysdate) BETWEEN effective_start_date AND
effective_end_date) papf
where
nvl(pv.employee_id, -99) = papf.person_id (+)
and jaac.status <> 'VOID'
and atc.name = jaac.tax_name
and atc.org_id = jaac.org_id
and jaac.awt_type_code = jzat.awt_type_code
and jcat.awt_type_code = jzat.awt_type_code
and pvs.global_attribute17 = 'Y'
and pvs.vendor_id = pv.vendor_id
and pvs.org_id = jaac.org_id
and jsat.awt_type_code = jzat.awt_type_code
and jsat.vendor_id = pv.vendor_id
and pv.vendor_id = jaac.vendor_id
and xle.legal_entity_id = jcat.legal_entity_id(+)
and jaac.legal_entity_id = jcat.legal_entity_id
and fl.lookup_type = 'JLZZ_CITY'
and NVL(fl.start_date_active, SYSDATE) <= SYSDATE
and NVL(fl.end_date_active, SYSDATE) >= SYSDATE
and fl.enabled_flag = 'Y'
and (upper(fl.lookup_code) = upper(xle.town_or_city) OR upper(fl.meaning) = upper(xle.town_or_city))
ORDER BY pv.vendor_name,
jzat.awt_type_code,
jaac.certificate_number;

If NO RECORDS are retrieved, remove WHERE-clauses one by one until some record is returned - last WHERE-clause removed is responsible for no records to be retrieved.

Cause

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