Packages POS_LINES_V and POS_ASN_NOTIF Are Invalid (Doc ID 1225004.1)

Last updated on APRIL 27, 2015

Applies to:

Oracle iSupplier Portal - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms


On : 12.1.1 version,
POS_LINES_V and POS_ASN_NOTIF are invalid after application of <Patch 10038286>:R12.INV.B, <Patch 8647857>.B, <Patch 8659762>.B.

ERROR
-----------------------
SQL> sho err
Errors for PACKAGE BODY POS_ASN_NOTIF:

LINE/COL ERROR
-------- -----------------------------------------------------------------
637/17 PL/SQL: Item ignored
637/17 PLS-00905: object APPS.POS_LINES_V is invalid
735/1 PL/SQL: Statement ignored
735/1 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

746/2 PL/SQL: SQL Statement ignored
761/30 PL/SQL: ORA-00904: "X_SHIPMENT_NUM": invalid identifier
761/30 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

931/1 PL/SQL: SQL Statement ignored
932/20 PL/SQL: ORA-00904: "X_SHIPMENT_NUM": invalid identifier
932/20 PLS-00320: the declaration of the type of this expression is
incomplete or malformed

943/1 PL/SQL: SQL Statement ignored
943/16 PLS-00320: the declaration of the type of this expression is
incomplete or malformed


SQL> select * from POS_LINES_V;
select * from POS_LINES_V
*
ERROR at line 1:
ORA-04063: view "APPS.POS_LINES_V" has errors

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