My Oracle Support Banner

OE_Holds_PUB Invalid And Cannot Be Compiled (Doc ID 2422311.1)

Last updated on JULY 16, 2018

Applies to:

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

Symptoms

Package oe_holds_pub is invalid.
When attempting to manually compile, the following error occurs.

ERROR

SQL> alter package oe_holds_pub compile body;

Warning: Package Body altered with compilation errors.

SQL> show error
Errors for PACKAGE BODY OE_HOLDS_PUB:

LINE/COL ERROR
-------- -----------------------------------------------------------------
3199/7 PL/SQL: SQL Statement ignored
3200/7 PL/SQL: ORA-00913: too many values
4673/7 PL/SQL: SQL Statement ignored
4674/7 PL/SQL: ORA-00913: too many values



NOTES
Within the package body of oe_holds_pub , go to the problem line , ie 3199.
Here are the coding lines.

  SELECT * INTO l_line_rec
  FROM oe_order_lines
  WHERE line_id = l_line_id;

  From the program , l_line_rec is :-
  l_line_rec OE_ORDER_LINES_ALL%rowtype;

Comparing the returned fields for oe_order_lines and OE_ORDER_LINES_ALL
shows that OE_ORDER_LINES_ALL returned additional 2 field , ie "IB_INSTALLED_AT_LOCATION#1" and "IB_CURRENT_LOCATION#1".




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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.