ODS Load Completing Normal Even When The Custom Hook MSC_CL_CLEANSE.CLEANSE Ends In Warning
Last updated on JUNE 28, 2017
Applies to:Oracle Advanced Supply Chain Planning - Version 22.214.171.124 and later
Information in this document applies to any platform.
VCP 126.96.36.199 Patch 16974659 in Production and Test
Planning ODS Load will not finish with status Warning when you use custom Hook code msc_cl_cleanse
and return code G_WARNING
the status are defined in the package SPEC - file MSCCLCAB.pls
G_SUCCESS CONSTANT NUMBER := 0;
G_WARNING CONSTANT NUMBER := 1;
G_ERROR CONSTANT NUMBER := 2;
When G_SUCCESS - 0 is returned - there will not be any error and normal completion is expected.
When G_WARNING - 1 is returned - there will not be any error and Warning completion is expected - but get we normal completion.
When G_ERROR - 2 is returned - then error is returned for ODS Load and processing stops
- Get error
- do not get warning status for ODS Load
ODS load will finish with warning
cannot implement custom hook and get back required results when warning condition is triggered in the custom hook
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