Hi,
I work at a university, and we have four environments (DEVL/TEST/PPRD/PROD). I develop in DEVL, and my packages work fine there. But when I promote to TEST, I get ‘ORA-01799: a column may not be outer-joined to a subquery’. If I promote the same packages to PPRD/PROD, they work fine. I know how to fix the issue in TEST by restructuring my query. If I change my left joins to inner joins, it works fine. But I'd really like to find out what setting/configuration makes our TEST environment “stricter” so that I can have DEVL set the same way. If I can get DEVL set the same way as TEST, it will save me from having to go back to DEVL and fix my packages to work in TEST even though they work fine in DEVL. Not getting the same errors in DEVL versus TEST is a waste of development time.
Thanks,
Kyle