My Oracle Support Banner

PLS-00323 Error Returned When Running the Order Capture Default Generator Program (Doc ID 1370085.1)

Last updated on MARCH 31, 2020

Applies to:

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

Symptoms

When I run the concurrent request ASODEPGEN "Order Capture Dependency Generator"

an error is returned

ERROR in creating PACKAGE BODY :ASO_QUOTE_HEADER_DEP_HDLR
LINE :9 PLS-00323: subprogram or cursor 'GET_DEPENDENT_ATTRIBUTES_SETS' is declared in a package specification and must be defined in the package body

Changes

On a previous occasion the asodemp.sql was amended to include a non-standard defaulting attribute. (See <Note 780008.1> Ability To Add New Attributes And Sourcing Information To The Defaulting Rules )

The amended script asodemp.sql was run to update the table ASO_DEPENDENCY_MAPPINGS.

However as it's not possible to add additional Defaulting Rule attributes to the seeded list. So the changes made to the asodemp.sql were removed and the script was re-run to restore the original setup.

Cause

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
Symptoms
Changes
Cause
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.