Posting Batch Fails With "ORA-01427: Single-Row Subquery Returns More Than One Row" Error (Doc ID 2241623.1)

Last updated on SEPTEMBER 13, 2023

Applies to:

Symptoms

While trying to post an invoice where the discrepancies are resolved by using multiple reason codes, ReIM Posting Batch is getting failed with the below error:

Steps to Reproduce:

   1. Create a PO, Ship & Receive.
   2. Create Merchandise invoice with quantity discrepancy.
   3. Resolve the discrepancy using multiple reason codes.
   4. Created Credit Note request by running rollup Batch.
   5. V date is passed, Run Posting Batch.
   6. Merchandise Invoice is posted & created a Debit memo Qty with approve status.
   7. Run again Posting batch Debit memo Qty is posted.

Changes

Cause

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