Did anyone faced the same issue, I bought an apple 3000$ Mac Pro 2023 and its charging cable became non funtional in three months

Refer to the applicable Apple product warranty here: Product Service and Repair Information - Official Apple Support. It includes the accessories that came with your MacBook Pro.

In that case you will need to research the applicable Apple product warranty on your own. Links are likely to be location-specific.

In any event the power adapter will have the same warranty as the Mac you purchased. Contact Apple to get it replaced in accordance with that warranty.

All accessories in the box are subject to the same warranty and the Mac itself. I’ve had accessories like cables replaced under warranty.

Clicking on a specific link isn't how one gets warranty service. I typically get an appointment at an Apple Store, and I've also walked in a few times for something minor like a cable. If you don't have an Apple Store available, Apple Authorized Service Providers can do the same thing.

You might want to have your electrical connections tested in your house - two chargers not working in less than a week is more than unusual.

I just bought a brand new macbook air last week. Yesterday I had to bring it in because it was flashing light and not charging. They ended up switching out the cable and today having exact same problem with brand new charger cable. This is very worrisome when it is only a week new to me.