Problem

The user created a new extract, selected the “All of the Above” under <Select an Action> drop down and clicked “OK” button. The warning message box appeared

In “Activity Log” from <Select an Action> dropdown there are following errors:

1. “Error on line: 46: PLS-00566: type name “DATE” cannot be constrained”
2. “Error on line: 70: PLS/SQL: ORA-00942:table or view does not exist”
3. “Error on line: 70: PLS/SQL: Statement ignored”
4. “Error on line: 111: PLS/SQL: ORA-00942:table or view does not exist”
5. “Error on line: 111: PLS/SQL: Statement ignored”

Solution

These errors appear because the Date type field should be converted to character. Go to Step 1

and change Date type to Character.