My Oracle Support Banner

Last Update Date Of Price List Line Is Updating Even Though The Line Is Not Updated (Doc ID 3061760.1)

Last updated on DECEMBER 03, 2024

Applies to:

Oracle Advanced Pricing - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.10 version, Price List

ACTUAL BEHAVIOR
---------------
When updating any line in a price list, the last_update_date of other lines are updated even though there is no update in those lines.

EXPECTED BEHAVIOR
-----------------------
The last_update_date value is only updated on the line that is being updated.


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

1. Go to Oracle Pricing Manager Responsibility or equivalent.
2. Navigate to MENUPATH > Price Lists > Price List Setup
3. Query any price list, click on any list line (e.g. Line 1)
4. Create a new list line and Save
5. The last_update_date of line 1 also gets updates even though there are no changes to the line 1.

This issue can also be seen when checking the last_update_date of the list lines by using the below query:

 

Changes

This issue is observed after upgrading to Version 12.2.10

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.