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 laterInformation 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 |