Hooks Were Disabled Automatically After Upgrade From 11i To 12.2

(Doc ID 2314967.1)

Last updated on OCTOBER 06, 2017

Applies to:

Oracle Quoting - Version 12.2.5 and later
Oracle Order Capture - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
Hooks were Disabled automatically After Upgrade from 11i to 12.2

EXPECTED BEHAVIOR
-----------------------
Hooks enabled in 11i should be left as-is.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Implement hooks in 11i
for example, enable below hooks by updating execute_flag. Confirm number of hooks enabled using below SQL:

SELECT api_name, processing_type
FROM JTF_USER_HOOKS
WHERE product_code = 'ASO'
AND user_hook_type = 'C'
AND pkg_name = 'ASO_QUOTE_PUB'
AND execute_flag = 'Y';

Above returns 5 rows

CREATE_QUOTE B
CREATE_QUOTE A
COPY_QUOTE A
UPDATE_QUOTE B
SUBMIT_QUOTE A

2. Check result of above SQL after upgrade to 12.2, and see it does not return any row

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
DBA has no idea on manual step to enable the hooks.

Changes

 

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