Custom Package Body ASO_QUOTE_CUHK invalid after patching
Last updated on OCTOBER 23, 2017
Applies to:Oracle Quoting - Version 12.1.3 and later
Oracle iStore - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
How to resolve compilation errors on custom package body for ASO_QUOTE_CUHK?
This package body for ASO_QUOTE_CUHK is custom created.
Only the package specification of custom hooks is seeded in the application.
After applying a patch containing asocqtes.pls version 120.1.12010000.2 or higher, the custom package body has compilation errors
Errors for PACKAGE BODY ASO_QUOTE_CUHK can include the following:
PLS-00323: subprogram or cursor 'CREATE_QUOTE_PRE' is declared in a package specification and must be declared
PLS-00323: subprogram or cursor 'CREATE_QUOTE_POST' is declared in a package specification and must be declared
PLS-00323: subprogram or cursor 'CREATE_ORDER_PRE' is declared in a package specification and must be defined in the package body.
ORA-06508: PL/SQL: could not find program unit being called
errors when the hook is called.
Reference Note 373923.1 - Order Capture User Hooks
for details on how user hooks are enabled/disabled.
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