Alias Fields Are Defined Incorrectly In Package FM_NFE_PUB_SQL (Doc ID 2070574.1)

Last updated on OCTOBER 28, 2015

Applies to:

Oracle Retail Fiscal Management - Version 14.1.1 to 14.1.1 [Release 14.1]
Information in this document applies to any platform.

Symptoms

Alias fields cod_mun and city are incorrectly defined in package FM_NFE_PUB_SQL.

Steps to Reproduce:

  1. Create and approve a NFe (Nota Fiscal Electronica) of Sale Type.
  2. Note that city code is returned both for field cod_mun and city.The alias field for city should be municipality description.

 

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