Financial Management - PSFT (MOSC)

MOSC Banner

[On behalf of Alan] - PeopleSoft Error running Data Conversion for Finance 9.0 to 9.2 Initial Pass U

edited Jun 14, 2013 9:17PM in Financial Management - PSFT (MOSC) 6 commentsAnswered ✓
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.

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