EGL: Can EOUFANALYSIS/ PTIAANALYSIS Data Conversion Report Errors be Ignored?

(Doc ID 1263820.1)

Last updated on OCTOBER 27, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.
*** Checked for currency on 26-May-2016 ***
*** Checked for currency on 27-Oct-2017 ***

Goal

Upgrade to Financial Release 9.1.


The AE_EOUFANALYSIS Data Conversion report show the following errors and the question is can these be ignored?

WARNING: (Check SQL) SQL 'RECORD." | UPG_GL_KK_AET.RECNAME_HEADER)' Cannot be Parsed by EOUFAnalysis Process - Modify SQL syntax or add Override (REM SQLANALYSIS:) before sql statement. (158,2183)

Can not determine EOUF_DMLACTION. (158,2183)

WARNING: (Check SQL) SQL 'insert select FROM PS_KK_SOURCE_HDR KKSH WHERE KK_SOURCE_TRAN = %Bind(UPG_GL_KK_AET.KK_SOURCE_TRAN) AND NOT EXISTS ( SELECT 'X' FROM PS_UPG_KK_DUP_SHDR SHDR WHERE SHDR.KK_TRAN_ID = KKSH.KK_TRAN_ID AND SHDR.KK_TRAN_DT = KKSH.KK_TRAN_DT) AND KKSH.KK_ROLLED <> 'Y'' Cannot be Parsed by EOUFAnalysis Process - Modify SQL syntax or add Override (REM SQLANALYSIS:) before sql statement. (158,2183)

Check Select Sql. Could not determine the select clause. 'select FROM PS_KK_SOURCE_HDR KKSH WHERE KK_SOURCE_TRAN = %Bind(UPG_GL_KK_AET.KK_SOURCE_TRAN) AND NOT EXISTS ( SELECT 'X' FROM PS_UPG_KK_DUP_SHDR SHDR WHERE SHDR.KK_TRAN_ID = KKSH.KK_TRAN_ID AND SHDR.KK_TRAN_DT = KKSH.KK_TRAN_DT) AND KKSH.KK_ROLLED <> 'Y''. (158,2183)

Check Insert Sql 'insert select FROM PS_KK_SOURCE_HDR KKSH WHERE KK_SOURCE_TRAN = %Bind(UPG_GL_KK_AET.KK_SOURCE_TRAN) AND NOT EXISTS ( SELECT 'X' FROM PS_UPG_KK_DUP_SHDR SHDR WHERE SHDR.KK_TRAN_ID = KKSH.KK_TRAN_ID AND SHDR.KK_TRAN_DT = KKSH.KK_TRAN_DT) AND KKSH.KK_ROLLED <> 'Y''. (158,2183)

WARNING: (Check SQL) SQL 'insert select FROM PS_KK_SOURCE_HDR KKSH WHERE KK_SOURCE_TRAN = %Bind(UPG_GL_KK_AET.KK_SOURCE_TRAN) AND EXISTS ( SELECT 'X' FROM PS_UPG_KK_DUP_SHDR SHDR WHERE SHDR.KK_TRAN_ID = KKSH.KK_TRAN_ID AND SHDR.KK_TRAN_DT = KKSH.KK_TRAN_DT AND SHDR.INSERT_FLAG = 'Y') AND KKSH.KK_ROLLED <> 'Y'' Cannot be Parsed by EOUFAnalysis Process - Modify SQL syntax or add Override (REM SQLANALYSIS:) before sql statement. (158,2183)

Check Select Sql. Could not determine the select clause. 'select FROM PS_KK_SOURCE_HDR KKSH WHERE KK_SOURCE_TRAN = %Bind(UPG_GL_KK_AET.KK_SOURCE_TRAN) AND EXISTS ( SELECT 'X' FROM PS_UPG_KK_DUP_SHDR SHDR WHERE SHDR.KK_TRAN_ID = KKSH.KK_TRAN_ID AND SHDR.KK_TRAN_DT = KKSH.KK_TRAN_DT AND SHDR.INSERT_FLAG = 'Y') AND KKSH.KK_ROLLED <> 'Y''. (158,2183)

Check Insert Sql 'insert select FROM PS_KK_SOURCE_HDR KKSH WHERE KK_SOURCE_TRAN = %Bind(UPG_GL_KK_AET.KK_SOURCE_TRAN) AND EXISTS ( SELECT 'X' FROM PS_UPG_KK_DUP_SHDR SHDR WHERE SHDR.KK_TRAN_ID = KKSH.KK_TRAN_ID AND SHDR.KK_TRAN_DT = KKSH.KK_TRAN_DT AND SHDR.INSERT_FLAG = 'Y') AND KKSH.KK_ROLLED <> 'Y''. (158,2183)

WARNING: (Check SQL) SQL 'insert select FROM PS_KK_SOURCE_HDR KKSH WHERE KKSH.KK_TRAN_ID = %Bind(KK_SRC_FLDS_AET.KK_TRAN_ID) AND KKSH.KK_TRAN_DT = %Bind(KK_SRC_FLDS_AET.KK_TRAN_DT)' Cannot be Parsed by EOUFAnalysis Process - Modify SQL syntax or add Override (REM SQLANALYSIS:) before sql statement. (158,2183)

Check Select Sql. Could not determine the select clause. 'select FROM PS_KK_SOURCE_HDR KKSH WHERE KKSH.KK_TRAN_ID = %Bind(KK_SRC_FLDS_AET.KK_TRAN_ID) AND KKSH.KK_TRAN_DT = %Bind(KK_SRC_FLDS_AET.KK_TRAN_DT)'. (158,2183)

Check Insert Sql 'insert select FROM PS_KK_SOURCE_HDR KKSH WHERE KKSH.KK_TRAN_ID = %Bind(KK_SRC_FLDS_AET.KK_TRAN_ID) AND KKSH.KK_TRAN_DT = %Bind(KK_SRC_FLDS_AET.KK_TRAN_DT)'. (158,2183)





Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms