Effdt Logic in Query Manager not working on outer joins for ex_types_tbl and ex_purpose_tbl tables?
I am trying to build expense related queries in query manager, specifically focusing on travel authorizations, For some reason the effdt logic that peopletools automatically adds is not being inserted into the SQL generated by peopletools unless I use a standard join the ex_types_tbl and ex_purpose_tbl. The effdt logic cannot be inserted into an outer join clause for this example.
PT release 8.61.12
App release: Financials/SCM 9.10.00.000
We have other expense queries that have effdt logic in outer joins, however, it is no longer not working correctly it seems. Does anyone know why this might not be working as expected now? We recently applied PUM 54 and I'm curious if that did something to query manager or if there is something wrong with the underlying tables and/or query manager tool. Does anyone have any expertise here? I don't ever remember running into a problem like this as I've always seemed to be able to insert effdt logic outer joins when developing queries, however, for these two tables