ECM: data conversion PTIADATACONV abends at Step UPG_TR.TRC01.RuleFlds (SQL) - RC = 904 (108,524) (Doc ID 2168169.1)

Last updated on AUGUST 02, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

9.1.to 9.2 data conversion PTIADATACONV failed.

ERROR:
File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1708 Error Position: 169 Return: 904 - ORA-00904: "R"."SET_CF": invalid identifier
Failed SQL stmt: INSERT INTO PS_SUB_RULE_FIELDS(SETID , SUB_RULE_ID , TEST_ATTRIBUTE , SET_CF) SELECT D.SETID , D.ACCTG_TMPL_ID || '_' || TO_CHAR(D.ACCTG_TMPL_LINE) , R.TEST_ATTRIBUTE , R.SET_CF FROM PS_TRA_TMPL_HDR H , PS_TRA_TMPL_DETL D , PS_TRA_SUB_RULE R WHERE H.SETID = D.SETID AND H.ACCTG_TMPL_ID = D.ACCTG_TMPL_ID AND H.SOURCE_TYPE IN ('D', 'F') AND D.SUBSTITUTE_CF = 'Y' AND D.SETID = R.SETID AND D.ACCTG_TMPL_ID = R.ACCTG_TMPL_ID AND D.ACCTG_TMPL_LINE = R.ACCTG_TMPL_LINE

Process 3013279 ABENDED at Step UPG_TR.TRC01.RuleFlds (SQL) -- RC = 904 (108,524)

STEPS:
1. Upgrade from 9.1 to 9.2
2. Run Data Conversion PTIADATACONV

Cause

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