Knowledgebase: Planning
ORA-01747 Seen When Loading to Hyperion Planning Using an Oracle Source Table [ID 850052.1]
Posted by Priya Doyle on 26 October 2012 02:39 PM

Click to add to Favorites To BottomTo Bottom




Applies to:

Hyperion Planning - Version: and later   [Release: 9.2 and later ]
Information in this document applies to any platform.


When deleting a member from Planning via ODI using Oracle source tables an error was signalled from the Oracle database but the columns in the ODI Model matched those of the table:

ORA-01747 invalid user.table.column, table.column, or column specification


One of the column names in the Oracle source table used an Oracle reserved word. In this case there was a column named 'UPDATE' when the column name was changed to 'UPDT' it worked fine.


Check the Oracle Database SQL Reference for the version of Oracle that is being used to see if any of the column names are on the list of Reserved Words. If any of the column names are on this list then rename the column.

(0 vote(s))
Not helpful

Comments (0)
Post a new comment
Full Name: