Cannot Run Hr_assignment_api From Custom Schema
(Doc ID 602705.1)
Last updated on SEPTEMBER 08, 2022
Applies to:
Oracle Human Resources - Version 11.5.9 to 11.5.10.2 [Release 11.5 to 11.5.10]Information in this document applies to any platform.
Symptoms
On Production instance, when attempting to run the api, HR_ASSIGNMENT_API.update_emp_asg, in the custom XXXX user, get the following error
ORA-00942: table or view does not exist
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 10849
ORA-06512: at "APPS.HR_ASSIGNMENT_API", line 9366
ORA-06512: at line 14.
EXPECTED BEHAVIOUR
Expect to be able to run the api without error
STEPS TO REPRODUCE
The issue can be reproduced with the following steps:
1. log into XXXX user in sqlplus
2. execute the api, HR_ASSIGNMENT_API.update_emp_asg
BUSINESS IMPACT
Due to this issue, user cannot use API to do updates through custom applications.
It is needed to execute by custom schema/user.
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 |
| Cause |
| Solution |
| References |