My Oracle Support Banner

Invalid Fa Objects As APPS.FA_STD_TYPES Fails To Compile On ASSET_NUMBER (Doc ID 601585.1)

Last updated on JUNE 17, 2022

Applies to:

Oracle Assets - Version 11.5.10.0 and later
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
Hundreds of invalid objects, and when attempting to compile the errors seem to be centered on
APPS.FA_RET_TYPES

LINE/COL ERROR
-------- -----------------------------------------------------------------
3/1 PL/SQL: Declaration ignored
3/36 PLS-00905: object APPS.FA_STD_TYPES is invalid
12/1 PL/SQL: Declaration ignored
13/36 PLS-00905: object APPS.FA_RET_TYPES is invalid


SQL> alter PACKAGE APPS.FA_STD_TYPES compile;
Warning: Package altered with compilation errors.
SQL> show errors
Errors for PACKAGE APPS.FA_STD_TYPES:
LINE/COL ERROR
-------- -----------------------------------------------------------------
67/3 PL/SQL: Declaration ignored
78/36 PLS-00302: component 'ASSET_NUMBER' must be declared

-- Business Impact:
Cannot compile most or all of FA objects.


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!

In this Document
Symptoms
Cause
Solution


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