ORA-06508: PL/SQL: Could Not Find Program Unit Being Called In Package OE_Order_GRP Proce (Doc ID 1590415.1)

Last updated on JULY 13, 2016

Applies to:

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

Symptoms

Unable to Import Orders.

This error is found in the request type "Order Import Child Req1 (Order Import)":

L_MSG_DATA=ORA-06508: PL/SQL: could not find program unit being called in Package OE_Order_GRP Procedure Process_Order

latest apps_check output still shows 4 invalid objects

- OE_LINE_UTIL
- OE_INVOICE_PUB
- OE_DELAYED_REQUESTS_UTIL
- OE_DELAYED_REQUESTS_PVT


SQL> alter package OE_LINE_UTIL compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY OE_LINE_UTIL:

844/7 PL/SQL: Statement ignored
853/36 PLS-00302: component 'G_INCOMING_FROM_DOO' must be declared
1836/7 PL/SQL: Statement ignored
1844/32 PLS-00302: component 'G_INCOMING_FROM_DOO' must be declared
16282/5 PL/SQL: Statement ignored
16282/5 PLS-00306: wrong number or types of arguments in call to
  'CI_ATTRIBUTE_VALUE'

16299/8 PL/SQL: Statement ignored
16299/8 PLS-00306: wrong number or types of arguments in call to
  'CI_ATTRIBUTE_VALUE'

17614/9 PL/SQL: Statement ignored

17614/32 PLS-00302: component 'G_INCOMING_FROM_DOO' must be declared
18476/9 PL/SQL: Statement ignored
18476/31 PLS-00302: component 'G_INCOMING_FROM_DOO' must be declared
SQL> alter package OE_INVOICE_PUB compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY OE_INVOICE_PUB:

358/8 PL/SQL: Statement ignored
358/22 PLS-00302: component 'RAISE_BUSINESS_EVENT' must be declared
SQL> alter package OE_DELAYED_REQUESTS_UTIL compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY OE_DELAYED_REQUESTS_UTIL:

6784/3 PL/SQL: Statement ignored
6784/18 PLS-00302: component 'PROCESS_PRE_EXPLODED_KITS' must be declared
SQL> alter package OE_DELAYED_REQUESTS_PVT compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors
Errors for PACKAGE BODY OE_DELAYED_REQUESTS_PVT:

1717/18 PL/SQL: Statement ignored
1717/32 PLS-00302: component 'RAISE_BUSINESS_EVENT' must be declared

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