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

Last updated on JUNE 23, 2016

Applies to:

Oracle Spares Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

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

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