R12:JL: JLMXAAUX Mexican Accounts Auxiliary Report - XML Captures Text Value Journal Name Which Is not Unique for "NumUnIdenPol"

(Doc ID 2101099.1)

Last updated on JANUARY 28, 2016

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, Mexico GL Globalization

In Mexican Accounts Auxiliary Report - XML,
currently "NumUnIdenPol" captures text value Journal Name which is not unique and as per Exhibit 24of Miscellaneous Tax Resolution 2014 NumUnIdenPol column should carry a Unique Identification No. of Journal Voucher. 


Need “NumUnIdenPol” to capture a unique value.

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

1. Responsibility: General Ledger
2. Path: Other -> Requests -> Run
3. Run the Mexican Accounts Auxiliary Report - XML (JLMXAAUX.xml)

Currently "NumUnIdenPol" captures text value Journal Name which is not unique and as per Exhibit 24 of Miscellaneous Tax Resolution 2014 NumUnIdenPol column should carry a Unique Identification No. of Journal Voucher.

4. For example :

Currently report is capturing value as below:

 NumUnIdenPol="JMOLINA Reclass recibos PGS CCL_ACCOUNTING_ONLINE " .
But tax authorities expects a unique value instead of text .

5. Legal requirement

Attached is the Annex 24 in English and this is the legal requirement from tax authorities. Check page 62 (Anexo_24_041214_ENGLISH.DOCX)

This is the link of the government's web site:
http://www.sat.gob.mx/fichas_tematicas/buzon_tributario/Paginas/contabilidad_electronica.aspx

The issue has the following business impact:
Due to this issue, users cannot use the report properly.

Wrong value captured in the file to sent for Mexican SAT accounting.

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