If you make a query with the word TODAY in it, Team Approach will substitute in the actual date in the format MM/DD/YY. This yields an unexpected query name and introduces invalid characters "/" into the query name. The intended behavior is that the word TODAY does not get translated when it appears in the query name.
Query and Output Processing may end In Error and does not complete if the query name is over 17 characters long and has the word TODAY in it. The error message if you run to save to query retrieved is "ORA-12899: value too large for column "PBDS"."QUERY_RETRIEVED"."QUERY_NAME" (actual: 21, maximum: 20)". If you are not saving to query retrieved you will get this error with "QO_TEMP_OUTPUT_1"