"Defaulting Generator" Log Error "ORA-20000: No package specification found"

(Doc ID 2240596.1)

Last updated on MARCH 05, 2017

Applies to:

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


Defaulting Generator program completes successfully but concurrent program log shows below.

Create defaulting handler for attribute: Q_SALES_CHANNEL_CODE
Call AD_DDL to create BODY of package ASO_D1034_Q_SALES_CHANNEL_CODE
Error :ORA-20000: ORA-20000: No package specification found for package body "ASO_D1034_Q_SALES_CHANNEL_CODE" create_package(APPLSYS, ONT, ASO_D1034_Q_SALES_CHANNEL_CODE, TRUE, 1, 50): create_plsql_object(AP
Error in creating entity def hdlr User-Defined Exception

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

  1. Go into the responsibility: Quoting Sales Manager
  2. Navigation: View > Requests
      Query and run Defaulting Generator concurrent program
      Parameters "Order Capture", "Quote Header", "Sales Channel"
  3.  Open Concurrent Program Log file to see the error


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