Chile Payables "Document Type" Values Missing From LOV (Doc ID 1590744.1)

Last updated on JUNE 12, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, Chile Payables


Some Chile Payables "Document Type" values are missing from LOV.

Note:  This LOV is for the  Invoice Sub-Type in the invoice Header.
     Ref:  Why GDF JG_AP_INVOICES Is Not Available Anymore? (Doc ID 1619560.1)



Expect to see additional values


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

1. Responsibility: Oracle Payables - Chile localization - 12.1.3
Production and Test

2. Path: Invoices -> Entry -> Invoices (APXINWKB 12.0.601.12010000.39)
3. Query an invoice
4. Go to the Invoice Sub-Type field

The list of values for this field does not have all expected values.

5. Go to the GDF "Additional information for Chile"

Some Chile Payables "Document Type" values are missing from LOV.
There is nothing for ‘Exempt’ invoices.

4. For example

The following two document types do not exist in the drop-down menus for “Document Type” and “Document Subtype”:

• Type 32: Factura Exenta Nacional (“National Exempt Invoice”)
• Type 34: Factura Electronica Exenta (“Electronic Exempt Invoice”)


Current LOV values in Oracle Payables (Chile) - nothing for EXEMPT

select classification_type_name, language, classification_code, classification_name, segment2, concat_classif_name, segment2_name, zfc.*
from apps.zx_fc_codes_denorm_b zfc
where zfc.classification_type_code = 'DOCUMENT_SUBTYPE'
and country_code = 'CL' and language = 'ESA';

Document Sub-Type ESA JL_CL_INVOICE_ELECTRONIC Factura Electronica
Document Sub-Type ESA JL_CL_INVOICE_ELECTRONIC_FIJO Electronic Invoice FA
Document Sub-Type ESA JL_CL_INVOICE_FA Factura A Fijo
Document Sub-Type ESA JL_CL_SERVICE_FEE Honorarios de Servicios Profesionales
Document Sub-Type ESA JL_CL_SERVICE_PARTICIPATE_FEE Servicios Profesionales y Participación
Document Sub-Type ESA DOCUMENT TYPE Document Type
Document Sub-Type ESA JL_CL_CREDIT_MEMO Nota Credito
Document Sub-Type ESA JL_CL_CREDIT_MEMO_ELECTRONIC Nota Credito Electronica
Document Sub-Type ESA JL_CL_DEBIT_MEMO Nota Debito
Document Sub-Type ESA JL_CL_DEBIT_MEMO_ELECTRONIC Nota Debito Electronica
Document Sub-Type ESA JL_CL_DOMESTIC_INVOICE Factura Nacional
Document Sub-Type ESA JL_CL_FOREIGN_INVOICE Factura Extranjera
Document Sub-Type ESA JL_CL_IMPORT_DECLARATION Declaracion Importacion
Document Sub-Type ESA JL_CL_INTERNAL Interna


select meaning
from FND_lookups
where lookup_typ = 'JLCL_AP_DOCUMENT_TYPE'

Credit Memo
Debit Memo
Domestic Invoice
Domestic Invoice FA
Electronic Credit Memo
Electronic Debit Memo
Electronic Invoice
Electronic Invoice FA
Foreign Invoice
Import Declaration
Internal
Professional Service Fee
Professional Services and Participation



Application Object Library Lookups

Type: JLCL_AP_DOCUMENT_TYPE

Code Lookup Code Meaning Lookup Code Description
JL_CL_CREDIT_MEMO Credit Memo Credit Memo
JL_CL_CREDIT_MEMO_ELECTRONIC Electronic Credit Memo Electronic Credit Memo
JL_CL_DEBIT_MEMO Debit Memo Debit Memo
JL_CL_DEBIT_MEMO_ELECTRONIC Electronic Debit Memo Electronic Debit Memo
JL_CL_DOMESTIC_INVOICE Domestic Invoice Domestic Invoice
JL_CL_FOREIGN_INVOICE Foreign Invoice Foreign Invoice
JL_CL_IMPORT_DECLARATION Import Declaration Import Declaration
JL_CL_INTERNAL Internal Internal
JL_CL_INVOICE_ELECTRONIC Electronic Invoice Electronic Invoice
JL_CL_INVOICE_ELECTRONIC_FIJO Electronic Invoice FA Electronic Invoice FA
JL_CL_INVOICE_FA Domestic Invoice FA Domestic Invoice FA
JL_CL_SERVICE_FEE Professional Service Fee Professional Service Fee
JL_CL_SERVICE_PARTICIPATE_FEE Professional Services and Participation Professional Services and Participation



The issue has the following business impact:

As a result, manual efforts required to submit government reporting.
Very time consuming and increases likelihood for errors.

Chile users feel they don't have all document types required to properly break out
transactions ultimately required for government reporting through the Purchase Ledger.
As a result, they have been completing time-consuming, manual processes to submit accurate information to government.

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