My Oracle Support Banner

Charges Page : Duplicate Records Result When One Line Has Error (Doc ID 1549334.1)

Last updated on OCTOBER 28, 2016

Applies to:

Oracle Enterprise Asset Management - Version 12.1.1 and later
Information in this document applies to any platform.


On : 12.1.3 version, Enterprise Asset Management > Resource transactions


Duplicate records are being created when 2 lines are entered on Charges page and one of the records has an error. In this situation, the first record is saved. Then when the errored record is corrected, the corrected record is saved - but the first record is saved again resulting in 2 entries for the first record.

Expect that there should be no duplicate charge entries.

The issue only happens when several records are entered and when one record errors out and has to be corrected.

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

1. Navigation :Maintenance Super User > Work Orders Tab

2. Open a work order.

3. Select Charge Time from Operation Details tab and click go.

4. Enter 2 charges lines :

- Line 1 - valid record with correct date.
- Line 2 - enter an invalid record - make the Work Performed Date before the Job Release date.

5. Click Save.

6. Line 1 is saved and Line 2 errors out saying : Error : Work performed date cannot be Work order released date.

7. The problem is that BOTH lines should now be ignored - but in fact line 1 is saved to the database.

8. Now correct the second record and enter a valid work performed date. Click save.

9. Both records are now saved to the database.

10. As a result, there are 2 entries for line 1. The Charged units are duplicated for the resource on line 1.


To view full details, 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 a vibrant support community of peers and Oracle experts.