The page for the APC Smart-UPS 5G cable pinout, AP940-0625A and AP940-1525A apc_0625_cable_pinout (https://pinoutguide.com/UPS/apc_0625_cable_pinout.shtml) shows a picture of a male 9-pin D-SUB connector at the PC cable. I think this should instead be a picture of a female 9-pin D-SUB connector.
The table correctly lists a DB9F. The only problem is the picture of a male connector that should be female.
Note: I bought one of these cables from Amazon, and it does come with a female connector. Also, if you go to the APC site APC AP940-0625A (https://www.apc.com/shop/us/en/products/UPS-Communications-Cable-Smart-Signalling-6-2m-DB9-to-RJ45/P-AP940-0625A) you can clearly see that the connector should be female.