What layer of the ground is oil found in?

The crust. Often oceanic crust.
Know that man has not yet managed to drill a hole past the crust. The deepest hole ever drilled is the Kola Superdeep Boerhole in Russia, which drilled about 1/3 of the way through the Earth's crust.