My Oracle Support Banner

Posting Job Failing With ORA-01427 Error (Doc ID 2889321.1)

Last updated on AUGUST 06, 2024

Applies to:

Oracle Retail Invoice Matching - Version 19.0.1 and later
Information in this document applies to any platform.

Symptoms

Reimposting batch failed with ORA-01427 error when converting late Credit Note Request (CNR) into a debit memo.

ERROR
-----------------------
"ORA-01427: single-row subquery returns more than one row"

Steps to Recreate:

  1. Choose a supplier with SEND_DEBIT_MEMO = 'L'.
  2. Create a Credit Note Request (CNR) with multiple items.
  3. Ensure that Due Date is past vdate.
  4. Run reimposting batch and notice the below error:
    "ORA-01427: single-row subquery returns more than one row"

Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution
References


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