CA Upgrade Of EPM9.0 To EPM 9.1 Fails On Step 5-12-3, Performing Data Conversion (Doc ID 1451156.1)

Last updated on MARCH 16, 2016

Applies to:

PeopleSoft Enterprise EPM Campus Solutions Warehouse - Version 9.1 and later
PeopleSoft Enterprise EPM Performance Management Warehouse - Version 9.1 and later
Information in this document applies to any platform.

Goal

Customer is upgrading from EPM9.0 to 9.1 and this step fails with Stmt #: 1620 Error Position: 43 Return: 904 - ORA-00904: "TRANSACTION_LINE": invalid identifier. The statement is this one: Failed SQL stmt:UPDATE PS_GC_ACCT_ENTRY SET TRANSACTION_LN=TRANSACTION_LINE Process 989 ABENDED at Step UPG_GC88.GCX000.Step01 (SQL) -- RC = 904 (108,524)

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