My Oracle Support Banner

Spares Management Error: 'PL/SQL: ORA-00904: "TTYPE"."SPARES_ALLOWED_FLAG": invalid identifier' During Application Of Patch (Doc ID 1983483.1)

Last updated on DECEMBER 17, 2017

Applies to:

Oracle Spares Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
***checked currency on 17-DEC-2017

Symptoms

On : 12.1.3 version, Spares Logistics

When attempting to compile CSPPTAPA.fmb the following error occurs.

ERROR
-----------------------
PL/SQL: ORA-00904: "TTYPE"."SPARES_ALLOWED_FLAG": invalid identifier
PL/SQL: SQL Statement ignored

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 18843706
2. Compile form CSPPTAPA.fmb in the patching or manually
3. Check the compilation errors


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
References


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