ORA-01427 "Single Row Subquery Returns More Than One Row" Error Occurs When NF Has More Than One Requisition Number

(Doc ID 2128709.1)

Last updated on APRIL 24, 2016

Applies to:

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


If the same NF (Nota Fiscal) has more than one requisition number, the fiscal header screen throws the following error:

Steps to Reproduce:

  1. Create a shipment with at least 2 allocations/transfers.
  2. Verify that table FM_FISCAL_DOC_DETAIL has two or more FISCAL_LINE_DOC_IDs with different requisition numbers for the same FISCAL_DOC_ID.
  3. Open the fiscal header screen and note the error.


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