R12:JL:AP:CE:GL:JLMXJENT Some Fields Are Not Populated in Mexican Journal Entries XML File

(Doc ID 2048378.1)

Last updated on APRIL 06, 2018

Applies to:

Oracle Payables - Version 12.1.3 and later
Oracle Financials for the Americas - Version 12.1.3 and later
Oracle Cash Management - Version 12.1.3 and later
Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

There are two issues in the Mexican Journal Entries XML File:

a) The values from Payables Mexican global flexfield are not seen in the report output as the below columns are blank:

INVOICE_CFD_CBB_SERIES 
INVOICE_CFD_CBB_NUMBER 
FOREIGN_INVOICE_NUMBER

Note: The global flexfield values are populated in the front-end AP Invoices, AP Payments, AR transactions, AR Receipts.

 

b) The values from Cash Management fields below are also not seen in the report output:

BanEmisNal
BanEmisExt
BancoOriNal
BancoOriExt
BancoDestNal
CompExt

As per Mexico SAT authorities, data for these fields should be based on the government bank catalog published by SAT. 

 

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

1. Responsibility: General Ledger
2. Path: Other -> Requests -> Run
3. Run the Mexican Journal Entries XML File (JLMXJENT.xml)

 

 




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