why my active piezo buzzer doesn't give any signal as an input?
I expected that that it is because the oscillator associated with the
piezo element in the active buzzers

If it has an internal oscillator then, the actual piezo element is so far-removed from the electrical terminals of the device that it cannot be used (in reverse) as an input device.