-
Useful scripts are delivered with the OOTB SDB database in the folder <SDB Installation Folder >\sdbutilitytool\tool_usefulscript\Useful_Scripts.
-
Customers may already have some duplicate idents or commodity geometric data from previous releases. These existing duplicate idents or geometrics may be in use in SP3D/BOM/REQ. To determine the duplicate idents and geometric data after migration, customers can use the database integrity scripts duplicate_geometrics.sql, duplicate_idents.sql. Based on usage, customers may either delete or keep the data.
-
To determine duplicate TD codes based on NLS_ID = English and table group US, use the script get_dup_tdlst.sql.
-
To determine commodity codes associated with duplicate table detail codes, use the script get_ccs_for_dup_tdcodes.sql.
-
To determine geometric rules associated with duplicate table detail codes, use the script get_gmrule_dup_tdcode.sql.
-
To determine item mappings associated with duplicate table detail codes, use the script get_itmp_for_dup_tdcode.sql.
-
To delete item mappings associated with duplicate table detail codes, use the script del_itmp_for_dup_tdcode.sql.
-
Object parameters for OSOC, MFKN, FLJ, and GSW are modified from 2NPS_1SCH to 2NPS, 1NPS_1SCH to 1NPS, 1NPS_1SCH to 1NPS, and P_BI_GSK_4.0_MM to P_GSW_DSTD_B16_20_ESTD_B16.5_CL600, respectively. New geometric tables will also be linked to these commodity codes. To modify the migrated databases for this behavior, perform the following steps:
-
Run the script cc_inv_idnt_geom_rpt.sql to find the commodity codes defined with invalid geometrics.
-
Remove references for invalid geometrics on S.30.01 Commodity Codes by clearing the Ident check box.
-
Delete the invalid idents for the commodity codes on S.80.01 Ident Management.
-
-
To verify commodity geometric relations, use the script get_geom_com_rel_for_cc.sql.
-
To determine Smart Reference Data and S3D short code mapping in SDB, use the script sp3d_sdb_sht_codes_map.sql.
-
To copy service limits to rating geometrics, use the script Copy_service_limits_to_rating_geometrics.sql provided in <SDB Installation Folder>\ scripts\Copy_service_limits_to_rating_geometrics\ folder after migration.
-
The script mig_sc_dup_vlv_Idnts.sql provided in the <SDB Installation Folder>\ scripts\Update_SC_to_remove_duplicateidents\ folder. The script takes a sheet configuration and project as input. Upon execution, the script changes the Extended Customization option to Y for all part class sheets containing the Valve keyword in their name and attaches the procedure DELETE_DUP_VALVE_RECORD to those sheets. This script is optional for customers.
-
New integrity checks have been added to identify the missing NLS descriptions for attributes, table details, and so on.