The port entry with 400G ZR optics was added to TRANSCEIVER_PM table:

root@localhost:/home/cisco# sonic-db-cli -n asic0 STATE_DB keys \* | grep PM
TRANSCEIVER_PM|Ethernet2

Ethernet2: SFP EEPROM detected
        Application Advertisement: {1: {'host_electrical_interface_id': '400GAUI-8 C2M (Annex 120E)', 'module_media_interface_id': '400ZR, DWDM, amplified', 'media_lane_count': 1, 'host_lane_count': 8, 'host_lane_assignment_options': 1}, 2: {'host_electri
cal_interface_id': '400GAUI-8 C2M (Annex 120E)', 'module_media_interface_id': '400ZR, Single Wavelength, Unamplified', 'media_lane_count': 1, 'host_lane_count': 8, 'host_lane_assignment_options': 1}, 3: {'host_electrical_interface_id': '100GAUI-2 C2M (Ann
ex 135G)', 'module_media_interface_id': '400ZR, DWDM, amplified', 'media_lane_count': 1, 'host_lane_count': 2, 'host_lane_assignment_options': 85}}
        Connector: LC
        Encoding: N/A
        Extended Identifier: Power Class 8 (20.0W Max)
        Extended RateSelect Compliance: N/A
        Identifier: QSFP-DD Double Density 8X Pluggable Transceiver
        Length Cable Assembly(m): 0.0
        Nominal Bit Rate(100Mbs): 0
        Specification compliance: sm_media_interface
        Vendor Date Code(YYYY-MM-DD Lot): 2021-11-25
        Vendor Name: CISCO-ACACIA
        Vendor OUI: 7c-b2-5c
        Vendor PN: DP04QSDD-E20-190
        Vendor Rev: A
        Vendor SN: ACA254700EE


root@localhost:/home/cisco# sonic-db-cli -n asic0 STATE_DB hgetall "TRANSCEIVER_PM|Ethernet2"
{'prefec_ber_avg': '0.0003407240007014899', 'prefec_ber_min': '0.0006814479342250317', 'prefec_ber_max': '0.0006833674050752236', 'uncorr_frames_avg': '0.0', 'uncorr_frames_min': '0.0', 'uncorr_frames_max': '0.0', 'cd_avg': '1', 'cd_min': '1', 'cd_max': '1', 'dgd_avg': '2.0', 'dgd_min': '2.0', 'dgd_max': '2.0', 'sopmd_avg': '32.0', 'sopmd_min': '21.0', 'sopmd_max': '44.0', 'pdl_avg': '0.3', 'pdl_min': '0.3', 'pdl_max': '0.3', 'osnr_avg': '36.3', 'osnr_min': '36.3', 'osnr_max': '36.3', 'esnr_avg': '18.0', 'esnr_min': '18.0', 'esnr_max': '18.0', 'cfo_avg': '-6', 'cfo_min': '-78', 'cfo_max': '49', 'soproc_avg': '0', 'soproc_min': '0', 'soproc_max': '0', 'tx_power_avg': '-8.01', 'tx_power_min': '-8.01', 'tx_power_max': '-8.0', 'rx_tot_power_avg': '-10.16', 'rx_tot_power_min': '-10.16', 'rx_tot_power_max': '-10.15', 'rx_sig_power_avg': '-10.49', 'rx_sig_power_min': '-10.5', 'rx_sig_power_max': '-10.48'}