My Oracle Support Banner

Error: "ORA-01403: No Data Found" in Reclassification Via Asset Workbench and Mass Reclassification (Doc ID 2411998.1)

Last updated on AUGUST 07, 2018

Applies to:

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

Symptoms

On : 12.2.6 version, Reclassification

When attempting to Run Mass reclassification or Reclassification through Asset Workbench,
the following error occurs.

ERROR
-----------------------
Run Mass reclassification:
-------------------------
Error:
ORA-01403: no data found
Error: function FA_INS_ADJUST_PKG.fadoact returned failure
Error: function FA_INS_ADJUST_PKG.faxinaj returned failure
Error: function FA_TRANSFER_XIT_PKG.fadotfr returned failure
FA_TFR_BOOK_INFO
User-Defined Exception
Error: function FA_DISTRIBUTION_PVT.do_distribution returned failure
Error: function fa_reclass_pvt.do_reclass returned failure
Error: function FA_RECLASS_PUB.do_reclass returned failure
Mass Reclass failed for this asset.


Reclassification through Asset Workbench
----------------------------------
APP-OFA-48398: Program entered with errors
ORA-01403: no data found
Error: function FA_INS_ADJUST_PKG.fadoact returned failure
Error: function FA_INS_ADJUST_PKG.faxinaj returned failure
Error: function FA_TRANSFER_XIT_PKG.fadotfr returned failure
FA_TFR_BOOK_INFO
User-Defined Exception
Error: function FA_DISTRIBUTION_PVT.do_distribution returned failure

STEPS
-----------------------
The issue can be reproduced while performing :
1. Run Mass Reclassification
as well as
2. Reclassify Asset category from Asset Workbench

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot update category of an Asset.

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!


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