My Oracle Support Banner

ORA-01427 Error if RTV NF Is Referencing Two Or More Purchase Orders (Doc ID 2379686.1)

Last updated on FEBRUARY 28, 2019

Applies to:

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


When Partner NFe calls FM_NFE_PUB_SQL.GET_NFE_INFO for RTV with balance control referencing two or more NF POs, error ORA-01427: single row subquery returns more than one row occurs.

Steps To Reproduce:

  1. Create a RTV NF with balance control referencing two or more POs NF.
  2. Approve the RTV NF (NFE_P status).
  3. Call FM_NFE_PUB_SQL.GET_NFE_INFO with the RTV fiscal_doc_id.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.