Error "ORA-01086: Savepoint 'CREATE_API_HOOK_CALL' never established in this session or is invalid" While Registering Custom User Hook
(Doc ID 2907006.1)
Last updated on DECEMBER 01, 2024
Applies to:
Oracle Self-Service Human Resources - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
While trying to register a Custom User Hook the following error occurs
ERROR
-----------------------
ORA-01086: savepoint 'CREATE_API_HOOK_CALL' never established in this session or is invalid
ORA-06512: at "APPS.HR_API_HOOK_CALL_API", line 115
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "APPS.HR_AHC_SHD", line 252
ORA-06512: at "APPS.HR_AHC_INS", line 282
ORA-06512: at "APPS.HR_API_HOOK_CALL_API", line 66
ORA-06512: at line 15
01086. 00000 - "savepoint '%s' never established in this session or is invalid"
*Cause: An attempt was made to roll back to a savepoint that was never
established in this session, or was invalid.
*Action: Try rolling back to the savepoint from the session where it is established.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to SQL PLUS
2. Run the below script to register the user hook
3. The above mentioned error is showing
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 |
References |