NFe Consume Function Returns Success Even If Record Is Locked (Doc ID 2091263.1)

Last updated on DECEMBER 21, 2015

Applies to:

Oracle Retail Fiscal Management - Version 14.1.1 and later
Information in this document applies to any platform.

Symptoms

If the NFe (Nota Fiscal Electronica) is locked at the same time message is being processed, the API returns success and does not update tables correctly.

 
Steps to Reproduce:

  1. Create an exit NFe and approve.
  2. Lock the NFe by opening it from GUI and call the function FM_MS_NFE_SQL.CONSUME to consume the message.
  3. Note that table FM_FISCAL_DOC_HEADER is not updated and the function returns success.

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