Hello,
I was able to fix the issue with the help of below comment
you need to place the character in the world and then try to get the ceiling light BP, for reference
please first try, 3rd person scene example from unreal and then try to recreate with your own character.
closing ticket