Error Msg 166100 And ORA-00904 When Attempting To Perform A Data Extract
(Doc ID 351349.1)
Last updated on DECEMBER 04, 2019
Applies to:Oracle Clinical - Version 4.5.1 and later
Information in this document applies to any platform.
***Checked for relevance on 07-May-2010***
Oracle Clinical 4.5 in production, users are encountering errors when attempting to perform a data extract
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
ORA-00904: “NULLC33”: invalid identifier
Steps to reproduce:
- Data Extract View Builder
- View Definitions
- F8 to Select View
- View Data button
- Errors messages occur
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document