My Oracle Support Banner

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 later
Information 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


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