Application Framework Database Changes

Application Framework Database Changes

This chapter provides lists of database changes in Oracle Utilities Application Framework included with the 23C release of Oracle Utilities cloud services. This includes:

• New Columns

• Updated Columns

New Tables

Table	Name	Description
F1_MST_CONFIG_CHAR	Master Configuration Characteristics	Future use only.
F1_BUS_OBJ_STATUS_VW	Business Object Status View	New view populates status description with the override description (if populated) otherwise with the description. SQLs that need the BO status description can use this view instead of doing the work to check the override description.
F1_BUS_OBJ_STATUS_RSN_VW	Status Reason View	New view populates status reason description with the override description (if populated) otherwise with the description. SQLs that need the BO status reason description can use this view instead of doing the work to check the override description.

New Views

Table	Description	Description
F1_BUS_OBJ_STATUS_VW	Business Object Status View	New view populates status description with the override description (if populated) otherwise with the description. SQLs that need the BO status description can use this view instead of doing the work to check the override description.
F1_BUS_OBJ_STATUS_RSN_VW	Status Reason View	New view populates status reason description with the override description (if populated) otherwise with the description. SQLs that need the BO status reason description can use this view instead of doing the work to check the override description.

New Columns

Table_Name	Column_Name	Data Type	Data Length
F1_BUS_OBJ_STATUS_L	DESCR_OVRD	VARCHAR2	60
F1_BUS_OBJ_STATUS_RSN_L	DESCR_OVRD	VARCHAR2	60
F1_BUS_OBJ_TR_RULE_L	BO_NEXT_STATUS_OVRD_LBL	VARCHAR2	60
F1_MST_CONFIG	CONFIG_PART_NAME	VARCHAR2	254
F1_MST_CONFIG	CONFIG_CLS_FLG	CHAR	4

Updated Columns

Table_Name	Column_Name	Old Configuration	New Configuration
F1_BUS_OBJ_STATUS_L	DESCR	Null	Space as default
F1_BUS_OBJ_STATUS_L	OWNER_FLG	Null	Space as default
F1_BUS_OBJ_STATUS_L	DESCRLONG	Null	Space as default
F1_BUS_OBJ_STATUS_L	DESCR_OVRD	Null	Space as default
F1_BUS_OBJ_STATUS_RSN_L	DESCR	Null	Space as default
F1_BUS_OBJ_STATUS_RSN_L	OWNER_FLG	Null	Space as default
F1_BUS_OBJ_STATUS_RSN_L	DESCRLONG	Null	Space as default
F1_BUS_OBJ_STATUS_RSN_L	DESCR_OVRD	Null	Space as default
F1_BUS_OBJ_TR_RULE_L	BO_NEXT_STATUS_LBL	Null	Space as default
F1_BUS_OBJ_TR_RULE_L	OWNER_FLG	Null	Space as default
F1_BUS_OBJ_TR_RULE_L	BO_NEXT_STATUS_OVRD_LBL	Null	Space as default