Understanding the mechanism of excess pore water pressure generation in subgrades is essential for not only designing but also further maintenance purposes. The primary goal of this research was to investigate excess pore water pressure generation in fine granular materials under cyclic loading. A series of undrained cyclic triaxial tests were performed to study the excess pore water pressure generation in two selected fine granular materials: (1) railway sand and (2) tailings. The excess pore water pressure response of these materials was evaluated in terms of density conditions, number of cycles, and applied cyclic stress ratios (CSR). As a result, excess pore water pressure accumulated over time due to cyclic loading. However, its accumulation was significantly dependent on the governing factors, i.e., densities, CSR values, and material types. The excess pore water pressure exhibited a slight increase at low CSR values, but a sharp increase was observed at higher CSR values, which ultimately led to a failure state after a certain number of cycles. In addition, under the same loading conditions, the samples that had higher relative compaction showed better resistance to cyclic loads as compared to those with lower relative compaction. Finally, a relationship between excess pore water pressure and cyclic axial strain of the fine granular materials was discovered.