PTIADATACONV seems to be looping on the same SQL statement
The PTIADATACONV program is stuck on the UPG_GL_KK.GLC01.Step01step.
SELECT A.KK_TRAN_ID,
TO_CHAR (A.KK_TRAN_DT, 'YYYY-MM-DD'),
A.BUSINESS_UNIT,
A.PO_ID
FROM PS_KK_SOURCE_HDR A, PS_PO_RC_SEL_T21 B
WHERE A.PO_ID = B.PO_ID
AND A.BUSINESS_UNIT = B.BUSINESS_UNIT
AND A.KK_ROLLED = 'N'
This is also one of the tables with can not parse warnings listed in the PTIAANALYSIS log.
Any insights on this would be appreciated.
Thanks,
Marshall