My Oracle Support Banner

Delete Daily Rates Deletes all but First Row in First Try (Doc ID 2313863.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

Oracle Fusion General Ledger Cloud Service - Version and later
Oracle Fusion General Ledger - Version and later
Information in this document applies to any platform.


On : version, Functional Setup Manager

The ADFDI Create Daily Rates spreadsheet is showing the following behavior:

When trying to delete daily rates from the Create Daily Rates spreadsheet, all the rows are getting deleted except the first one.
The first row gets status Insert failed but when just clicking on Submit again without any changes the row gets processed successfully.
The expectation is for all the rows to be deleted in the first attempt instead of having to submit twice.

The issue can be reproduced with the following steps:
a. Setup and Maintenance > Manage Daily Rates
b. Create Rates in Spreadsheet.
c. Insert a few rows via the Create Daily Rates spreadsheet successfully.
d. Verify the daily rates were created in the Daily Rates UI.
e. With the same spreadsheet open change the action of the rows from Insert to Delete and submit.
    All except the first row in the spreadsheet where deleted successfully. The first row has status Insert failed.
f. Check in the Daily Rates UI and the one row still shows.
g. Click on Submit again in the Create Daily Rates spreadsheet as the first record still shows as Changed and this time the row was deleted successfully
without making any changes to it.
f. Verify in the UI that the row was deleted.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.