Login Errors for PACKAGE BODY APPS.FND_SIGNON of PLS-00323 and PLS-00307: subprogram AUDIT_USER and NEW_ICX_SESSION (Doc ID 2444842.1)

Last updated on SEPTEMBER 23, 2023

Applies to:

Goal

Identified that the package body FND_SIGNON was invalid. So tried to compile it.

SQL> alter PACKAGE APPS.FND_SIGNON compile body;

Warning: Package Body altered with compilation errors.

SQL>

The reason for package body invalid is:

Errors for PACKAGE BODY APPS.FND_SIGNON:

LINE/COL ERROR
-------- -----------------------------------------------------------------
47/11 PLS-00323: subprogram or cursor 'AUDIT_USER' is declared in a
  package specification and must be defined in the package body

199/11 PLS-00323: subprogram or cursor 'NEW_ICX_SESSION' is declared in
  a package specification and must be defined in the package body

601/6 PL/SQL: Statement ignored
601/6 PLS-00307: too many declarations of 'AUDIT_USER' match this call
SQL>

Compared the version of the package spec and body from another environment and found that the problematic environment had lower version of the body.

/* $Header: AFSCSGNS.pls 120.6.12020000.2 2014/12/09 21:24:07 jwsmith ship $ */ -- Effected

/* $Header: AFSCSGNS.pls 120.6.12020000.4 2015/06/18 09:58:15 absandhw ship $ */ -- Working


 

Solution

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