PSpice AC Circuit Simulation Showing 0 V for Output Voltage?
First, the answers to this question will help you understand what's going on:

How do Circuit Simulators actually work?

Short version, as applied to your problem: SPICE supports several types of analysis. Two of these are transient and AC analysis. The AC analysis linearizes the circuit and tells you how it will respond to small AC signals around a fixed bias point. The transient analysis will also include nonlinear and start-up effects. The AC analysis might fit your problem better because it will allow you to sweep the frequency of the stimulus, and also it usually runs faster than a transient analysis.

Most importantly to your question, an AC source won't produce any signal in a transient simulation and a time-domain source won't produce any signal in an AC simulation. You were using an AC source in a transient simulation, so you didn't see any signal.