Quoting Error: "ORA-06508: PL/SQL: Could Not Find Program Unit Being Called" - Create Shopping Cart Or Create Quote (Doc ID 1527545.1)

Last updated on APRIL 03, 2016

Applies to:

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

Symptoms

When attempting to add items to cart the following error occurs.

Error

Error returned in ASO_QUOTE_PUB.CREATE_QUOTE.
oracle.apps.jtf.base.resources.FrameworkException: ORA-06508: PL/SQL: could not find program unit being called


Steps to Reproduce

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

  1. Register individual user
  2. Add item to cart > Error

 

The Apps Check report obtained for "Order Capture" shows several INVALID packages:

 

ASO_OPP_QTE_PUB                asopopqb.pls              120.16.12000000.3              BODY INVALID
ASO_QUOTE_HEADERS_PVT     asovqhdb.pls               120.45.12010000.8              BODY INVALID
ASO_QUOTE_PUB_W              asovqw1b.pls               120.9                                  BODY INVALID
ASO_SECURITY_INT               asoisecb.pls                 120.4                                 BODY INVALID


Errors for PACKAGE BODY ASO_OPP_QTE_PUB

PLS-00382: expression is of wrong type
PL/SQL: Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: Statement ignored

 

Cause

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