My Oracle Support Banner

Unable To Delete Unposted Reversal Journals in Primary Ledger Due to Error: ORA-01403: no data found (Doc ID 2996860.1)

Last updated on JANUARY 16, 2024

Applies to:

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


A primary ledger exists in the system with a secondary ledger attached. The users are unable to delete unposted reversal journals in primary ledger as an error is thrown on the form.

The corresponding journals exist in the secondary ledger and they are also unposted. Deleting non-reversal journals in the primary ledger works fine, also deleting any unposted journals in the secondary ledger works fine.

ORA-01403: no data found

1. General Ledger Responsibility with access to the primary ledger > Journals > Enter > Find > Query for an unposted journal which was reversed
2. Get on the screen on attempting to delete: 'Decision: Do you want to delete the entire batch or just the current journal entry?'
3. Click on the batch option, get a new message on the screen: 'Note: The action will delete the reversal journal in the secondary ledger as well, if not posted. If the corresponding journal in the secondary ledger is manually reversed or already posted then it will not be deleted.'
4. Click 'Ok'
5. Get error on the form, ORA-01403: no data found


Journals reversed in the system. 


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.