My Oracle Support Banner

Invalid objects like '%_SN' with OBJECT_TYPE = 'UNDEFINED' (Doc ID 131341.1)

Last updated on FEBRUARY 01, 2023

Applies to:

Oracle Application Object Library - Version 11.5.3 and later
Oracle Applications DBA - Version 11.5.3 and later
Information in this document applies to any platform.

Symptoms

Invalid objects of type 'UNDEFINED' on format '%_SN':

SQL> select object_name, object_type, status
2 from dba_objects
3 where object_type = 'UNDEFINED'
4 and status = 'INVALID';


OBJECT_NAME OBJECT_TYPE STATUS
----------- ----------- ------
MTL_DEMAND_SN UNDEFINED INVALID
MTL_MTRX_TMP_SN UNDEFINED INVALID
MTL_OH_QTYS_SN UNDEFINED INVALID
MTL_SUPPLY_SN UNDEFINED INVALID
MTL_SYS_ITEMS_SN UNDEFINED INVALID
BOM_INV_COMPS_SN UNDEFINED INVALID
BOM_OPR_RESS_SN UNDEFINED INVALID
BOM_OPR_SEQS_SN UNDEFINED INVALID
BOM_RES_CHNGS_SN UNDEFINED INVALID
MRP_SCHD_DATES_SN UNDEFINED INVALID
WIP_DSCR_JOBS_SN UNDEFINED INVALID
WIP_FLOW_SCHDS_SN UNDEFINED INVALID
WIP_WOPRS_SN UNDEFINED INVALID
WIP_WREQ_OPRS_SN UNDEFINED INVALID
MSC_ATP_PLAN_SN UNDEFINED INVALID
OE_ODR_LINES_SN UNDEFINED INVALID


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!

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