After Running the Pre Processor Program for an API User Hook, the Status in HR_API_HOOK_CALLS Table Did Not Change to 'V'. (Doc ID 1457575.1)

Last updated on DECEMBER 21, 2016

Applies to:

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

Symptoms

After running the Pre Processor program for user hook, the status in HR_API_HOOK_CALLS table did not change to 'V'.

After running the Pre Processor program for user hook status in HR_API_HOOK_CALLS table should change to 'V'.

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Write one PL/SQL procedure for user hook

2. Register the user hook for table HR_API_HOOK_CALLS

3. Run the Pre Processor program

4. Verify the value is 'Status' column of table HR_API_HOOK_CALLS

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms