My Oracle Support Banner

Addition/Adjustment APIs are Failing with ORA-00942 When Using Non-APPS User to Execute the APIs (Doc ID 2665369.1)

Last updated on APRIL 30, 2020

Applies to:

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

Symptoms


When attempting to run addition and adjustment API using a Non-APPS user the following error occurs

fa_addition_pub.do_addition
fa_adjustment_pub.do_adjustment


For Addition API:
ORA-00942: table or view does not exist
Error: function fa_cache_pkg.fazcbc returned failure
Error: function fa_addition_pub.do_addition returned failure
FAILURE

For Adjustment API:
ORA-00942: table or view does not exist
Error: function fa_cache_pkg.fazcbc returned failure
Error: function fa_adjustment_pub.do_adjustment returned failure
FAILURE


ERROR
-----------------------
ORA-00942


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Run APIs using non-apps user.
fa_addition_pub.do_addition
fa_adjustment_pub.do_adjustment



Changes

 

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!


In this Document
Symptoms
Changes
Cause
Solution


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