My Oracle Support Banner

ORA-00904: "PREGNACY_OUTCOME_COMMENT" Invalid Identifier Error Generated While Trying To Open A Case After Applying Patch (Doc ID 729672.1)

Last updated on SEPTEMBER 06, 2008

Applies to:

Adverse Event Reporting System - Version: 4.6
This problem can occur on any platform.


-- Problem Statement:
On 4.6 in Production:
When attempting to open existing case from the AERS application after applying
AERS patch, the following error occurs:

"FROM-40505: ORACLE error: unable to perform query.
ORA-00904: "PREGNACY_OUTCOME_COMMENT": invalid identifier"

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Apply AERS patch;
2. Start the AERS application;
3. Try to open an exiting case.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.