[On behalf of Alan] - PeopleSoft Error running Data Conversion for Finance 9.0 to 9.2 Initial Pass U
Hi All
We are receiving the following error when running data conversion:
SQL error. Stmt #: 1623 Error Position: 59 Return: 904 - ORA-00904: "RT_RATE_ADM_MAXVAR": invalid identifier
Failed SQL stmt: UPDATE PS_RT_RATE_DEF_TBL SET RT_RATE_ADM_MAXVAR=5.0 WHERE RT_RATE_ADM_MAXVAR=0
Process 3760787 ABENDED at Step UPG_EOEC.MRTO01.Step01 (SQL) -- RC = 904 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
We have applied upd893452, which updated the SQL in the app engine program. It looks like the table PS_RT_RATE_DEF_TBL needs to be altered to include the new field in the app engine SQL, RT_RATE_ADM_MAXVAR. Please verify that this is the case and provide workaround or fix.
We are receiving the following error when running data conversion:
SQL error. Stmt #: 1623 Error Position: 59 Return: 904 - ORA-00904: "RT_RATE_ADM_MAXVAR": invalid identifier
Failed SQL stmt: UPDATE PS_RT_RATE_DEF_TBL SET RT_RATE_ADM_MAXVAR=5.0 WHERE RT_RATE_ADM_MAXVAR=0
Process 3760787 ABENDED at Step UPG_EOEC.MRTO01.Step01 (SQL) -- RC = 904 (108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s
We have applied upd893452, which updated the SQL in the app engine program. It looks like the table PS_RT_RATE_DEF_TBL needs to be altered to include the new field in the app engine SQL, RT_RATE_ADM_MAXVAR. Please verify that this is the case and provide workaround or fix.
0