My Oracle Support Banner

Duplicate Records Getting Populated In Im_ap_stage_head While Prepay Of The Invoice (Doc ID 2964392.1)

Last updated on JULY 31, 2023

Applies to:

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

Symptoms


We could see duplicate records getting posted in im_ap_stage_head while user prepaying the invoice. Please find below the steps to replicate the issue.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create an invoice/pick an existing invoice which is present in unresolved match.
2. Search for the invoice in document search screen
3. Open a duplicate tab/different browser and search for the same invoice using document search screen.
4. Verify whether the invoice search result is retrieved in both the tabs/browsers.
5. Click on the pre-pay invoice in one of the tab and after 20 to 30 secs try to pre pay the invoice in the other tab/browser.
6. Now notice that the invoice prepaid using 1st tab is successful.
7. Once the 1st tab is prepaid successfully then we will receive the error in the 2nd tab/browser stating " Header amount of 0 does not equal to total detail amount of 12646.12". But we will get duplicate posting in im_ap_stage_head with the same doc_id.


ERROR
-----------------------
"Header amount of 0 does not equal to total detail amount of 12646.12". But we will get duplicate posting in im_ap_stage_head with the same doc_id.

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
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.