My Oracle Support Banner

Addition API fa_addition_pub.do_addition Fails With ORA-1403 (Doc ID 1325444.1)

Last updated on OCTOBER 11, 2019

Applies to:

Oracle Assets - Version to 12.1 [Release 11.5 to 12.1]
Information in this document applies to any platform.

***Checked for relevance 12-Nov-2012***


When trying to add an asset by running the Addition API , it fails with the following error:

ORA-0000: normal, successful completion
Cache: Error retrieving row from FA_CATEGORIES table for:
Category ID:
Cause: You have a database problem.
Action: Contact your system administrator.
ORA-01403: no data found
Error: function fa_cache_pkg.fazcat returned failure

Same asset with same category can be successfully added from the Asset Workbench.


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.