ORA-01427 "Single Row Subquery Returns More Than One Row" Error Occurs When NF Has More Than One Requisition Number
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:
- Create a shipment with at least 2 allocations/transfers.
- 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.
- 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
Million Knowledge Articles and hundreds of Community platforms