My Oracle Support Banner

LAD Add-on Localizations – Colombian Electronic Invoice (Doc ID 2275991.1)

Last updated on MARCH 20, 2020

Applies to:

LAD Add-on Localizations - Version 12.0 and later
Information in this document applies to any platform.
Historic

Create Date 12-Jun-2017
Last Update Date 12-Jun-2017

Purpose

This documentation update note applies to LAD Add-on Localizations and includes information about the Colombian Electronic Invoice.

Electronic invoicing is an evolution of traditional paper invoice. It´s based on the transmission of invoices between the issuer and legal authority (DIAN) using electronic media. Through the remote system enabled by DIAN, an invoice issued electronically has the same legal value as its equivalent on paper.

There are three different document that must be generated and transmitted once the document is issued by Oracle Receivables:

  1. Invoice (“Factura”)
  2. Credit Memo (“Nota de Crédito”)
  3. Debit Memo (“Nota de Débito”)
Each file has its group of information and its proper communication method and rules. All details can be found on DIAN site http://www.dian.gov.co/.

Scope

Electronic Invoice

LAD Add-on Localizations provide:

      1. A MAPPING DOCUMENTATION (Colombian Electronic Invoice - XML Mapping 2017 06 13.xlsx pointing to the source of the information of each field required in the XML files.

          The source of the information will identify the table and column where the information can be obtained inside Oracle E-Business Suite (EBS) and the corresponding views created to facilitate the information extraction.

          In case of necessity, LAD Add-on Localizations will release new fields, through the extension technology, allowing customer to enter the required information. (Tables: CLL_F043).

          In the mapping documentation we will have a column named Source of the Information to identify where the information is located. There are the following possibilities to consider:

           The information classified as Core and Add-on Localization are available on views created by Add-on Localizations, to support the data extraction to the XML generation. The views will provide the information as it is in EBS, and will not have any kind of transformation.
 

The solution requires that the EBS customers work together with a DIAN communication provider, getting under their control the following actions:

  1. Access the views released by LAD Add-on Localizations, develop a criteria mechanism to select which invoices must be communicated to DIAN.
  2. Create the XML file, generate the digital communication.
  3. Control and monitoring the send and return XML files from DIAN.

 

Follow a file mapping the XML files, pointing to the source of the information in EBS.

This file should be used as reference to each customer be able to understand the source of each information that Add-on Localizations will release through the views in order to allow the integration with the DIAN communication provider and also to identify the information that must be mapped by each customer.

MAPPING DOCUMENTATION (Colombian Electronic Invoice - XML Mapping 2017 06 13.xlsx

 

Solution Released:

Patch 26093567 - R12.CLL Colombian Financials Pack 47 released 07/Jun/2017.

Warning

After assessment Oracle understand that all EBS customer will need an homologated solution to proceed the communication with DIAN.

Since each communication partner homologated by DIAN has its own architecture and layout to receive the information, Strategy will be only provide the mapping and the views. Implementation project should consider efforts to develop the integration between Oracle and customer selected partner.

 

Details

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
Purpose
Scope
Details

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