The current study aims to integrate the geochemical characteristics of the Oligocene shale source rock system, oil, condensate, and natural gas samples in the Oligocene sandstone reservoirs from three exploration wells located in the offshore Nile Delta, East Mediterranean Sea, using organic geochemistry and a 1D basin modeling scheme. The Tineh shales exhibit total organic carbon values ranging between 0.90 and 1.89 wt %, along with hydrogen index values in the range of 54−240 mg hydrocarbon/g rock. The geochemical characterization suggests that the shale intervals of the Oligocene Tineh Formation contain type II−III and type III kerogens and, thereby, could be regarded as promising oil-and gas-prone source rocks with high contributions of gas generation potential. The study also reconstructs the 1D thermal and burial history models, showing that the Oligocene Tineh source rock system is in the main oil and wet gas generation phases from the late Miocene to the present time. The simulated basin models reveal the transformation (TR) of 10−50% kerogen to oil during the late Miocene−early Pliocene period and that the Oligocene Tineh source rock system has larger oil generation and expulsion competency, with a TR value of up to 65% during the early Pliocene−Pleistocene time period. The thermogenic gas was also formed during this time and continued to the present day. This study also investigated the presence of oil and condensate in the Oligocene sandstone reservoir samples and revealed that they were generated from mature source rock, ranging from moderately to highly mature stages. This source rock unit was deposited in fluvial to fluvial-deltaic environments under oxic mixed organic conditions and accumulated during the Tertiary time, as evidenced by the presence of the oleanane biomarker dating indicator. The molecular and isotope compositions of natural gases revealed that most of the natural gases in the Oligocene sandstone reservoir are mainly thermogenic methane gases that were generated from mainly mixed organic matter. The thermogenic methane gases were formed mainly from secondary cracking of oil and gas, with small contributions of primary kerogen cracking. The properties of natural gases together with oil and condensate in the Oligocene reservoir rocks suggest that most of the thermogenic methane gases and associated liquid hydrocarbons are derived primarily from the Oligocene shale source rock system and formed by primary kerogen cracking and secondary oil and oil/gas cracking in different thermal maturity stages. Therefore, the Oligocene Tineh Formation can be regarded as self-source generation and self-reservoir rock; hence, an intensive oil exploration and production program can be recommended whenever the Tineh source rock system is is well developed and deeply buried.