My Oracle Support Banner

Custom Package Body ASO_QUOTE_CUHK invalid after patching (Doc ID 1459485.1)

Last updated on APRIL 04, 2025

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.

Goal

 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.

If there are user hooks enabled that reference this package, you may also see
    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.

Solution

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
Goal
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.