ORA-30926 Error Occurs When Posting a Credit Note
(Doc ID 2720086.1)
Last updated on OCTOBER 27, 2020
Applies to:
Oracle Retail Invoice Matching - Version 15.0.1 and laterInformation in this document applies to any platform.
Symptoms
Reimposting batch fails with below error when trying to post a credit note. This happens when both Return To Vendor (RTV) and Purchase Order (PO) share same number.
ERROR
-----------------------
ORA-30926: unable to get a stable set of rows in the source tables@2REIM_POSTING_SQL.UPDATE_POSTING_DOC_SOB
Steps to Recreate:
- Create a RTV and ensure that a PO exists with same number as RTV.
- Ship the RTV.
- Run edidlinv batch to generate EDI file.
- Run EDIinjector batch to upload the credit note request.
- Create a credit note against the above credit note request.
- Run reimposting batch and notice the error:
ORA-30926: unable to get a stable set of rows in the source tables@2REIM_POSTING_SQL.UPDATE_POSTING_DOC_SOB
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 |