Value of PRECO_UNITARIO Is Null In FM_SPED_FISCAL_DOC_DETAIL Table (Doc ID 2152161.1)

Last updated on JUNE 24, 2016

Applies to:

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

Symptoms

Value of preco_unitario is null in fm_sped_fiscal_doc_detail table.

Steps to Reproduce:

  1. Execute the cursor C_GET_CORRECTED_COST in program unit FM_SPED_SQL.
  2. Note that query returns more than one row and first value returned is null.

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