Error Msg 166100 And ORA-00904 When Attempting To Perform A Data Extract
Last updated on NOVEMBER 17, 2011
Applies to:Oracle Clinical - Version: 4.5.1
Information in this document applies to any platform.
***Checked for relevance on 07-May-2010***
They have created a user defined procedure, and called it with an Extract Macro.
When try to view data from Clinical, the following errors occur:
They have deleted extract macros and created again but getting same error
166100: Query is malformed or invalid study access account selected.
Click on OK
Attempt to create view GENERIC_DATA returned error:
ORA-00904: “NULLC33”: invalid identifier
Steps to reproduce:
- Data Extract View Builder
- View Definitions
- F8 to Select View
- View Data button
- Errors messages occur
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