ReIM Posting Error: ORA-01427: Single-row Subquery Returns More Than One Row From REIM_WRAPPER_SQL

(Doc ID 2237715.1)

Last updated on MARCH 01, 2017

Applies to:

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


When running the ReIM Posting process for Debit Memo's associated to deals, the following error is thrown:

Steps to Reproduce:

1. Deal income (Can be bill back, bill back rebates, or fixed deals).
Note: Deal has to generate a debit memo.
2. The supplier parent has to have the supplier site with more than one address for the type '06'.

1. Run reimfixeddealupload to generate the debit memo in ReIM.
2. Run reimposting process.




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 hundreds of Community platforms