Error ORA-06508 in API module HR_LOCATIONS_ALL at hook after insert
Hi
On creation of new location, we are getting the below error :
APP-PER-51938: The system cannot find the program unit being called. This could be because the application API pre-processor has not been run. Error ORA-06508 in API module HR_LOCATIONS_ALL at hook after insert
On Checking the Knowledge Database, we found the following notes :
1. Creating New Positions, Error's: APP-PER-51938 and Error ORA-06508 in API module HR_ALL_POSITIONS at hook after Insert (Doc ID 1319227.1)
Run the following query :
Select object_name, object_type, owner, status
from dba_objects
where status = 'INVALID';
But nothing found INVALID
2. PERWSLOC: Adding New Location Gives Error APP-PER-51938 (