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


On : 12.1.3 version, Spares Logistics

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

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

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


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