My Oracle Support Banner

Function Fa_deletion_pub.do_delete Returned Failure While Deleting Assets from a Tax Book attached to a Secondary Ledger (Doc ID 3020949.1)

Last updated on MAY 13, 2024

Applies to:

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


When attempting to run the FA_DELETION_PUB.do_delete on an asset in a Tax Book attached to a Secondary Ledger, while the asset is in its period of addition to that Tax Book,  the following error occurs.

ORA-20001: -: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:

An internal error has occurred in the program xla_events_pkg.delete_event. No event exists for the document represented by
Error: function fa_xla_events_pvt.delete_transaction_event returned failure
Error: function fa_delete_pub.delete_asset_events returned failure
Error: function fa_delete_pub.do_all_books returned failure
Error: function fa_deletion_pub.do_delete returned failure

1) Use the Deletion API to attempt to delete an asset from a Tax book attached to a Secondary Ledger in that asset's period of addition.

Instructions for using this API are available here:  Oracle Assets Deletion API Documentation Supplement (Doc ID 1518310.1)


The same error occurs when attempting to delete via the Asset Workbench, with these steps:

Use responsibility such as Fixed Assets Manager that has access to the Asset Workbench.

Menu path:  Assets -- Asset Workbench

A)  Query an asset that is in its period of addition and exists in a Tax Book with a Secondary Ledger.

B)  Choose the Open button.

C)  Click the Delete icon in the Toolbar.


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.