My Oracle Support Banner

Unable To Update Quantity Using OZF_CLAIM_PUB.update_claim_line_tbl Receive Error This Record Has Been Changed Or Deleted By Another User (Doc ID 2944158.1)

Last updated on APRIL 21, 2023

Applies to:

Oracle Trade Management - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.10 version, 

Trying to update Claim line quantity in OZF_CLAIM_LINES_ALL using the API OZF_CLAIM_PUB.update_claim_line_tbl.

API is throwing error,
"This record has been changed or deleted by another user. Please requery to view current data."


Steps
The issue can be reproduced at will with the following steps:
1. Using API OZF_CLAIM_PUB.update_claim_line_tbl



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.