PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

PTIADATACONV seems to be looping on the same SQL statement

edited Mar 30, 2017 5:00AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 7 commentsAnswered
We are running the initial pass for a FSCM 8.9 to 9.2 upgrade.

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center