My Oracle Support Banner

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

Last updated on APRIL 02, 2018

Applies to:

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

Symptoms

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.



Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.