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.


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