Error: ORA-01403: no data found in Reclassification Via Asset Workbench and Mass Reclassification

(Doc ID 2411998.1)

Last updated on JUNE 21, 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

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 hundreds of Community platforms