• Article Type: General
• Product: Aleph
• Product Version: 18.01

Description:
When we run p_file_20, even though util a/17/11/2 for ABC50 shows that the z305 *does* exist, we get the error message:

Oracle error: update_cursor z305
ORA-00942: table or view does not exist

Resolution:
Even when you have USER-SHARING=N (explicitly or by default, in the xxx50/tab//tab100) and, therefore, all the z305 records will be in the ADM library, with none in the $usr_library, the system wants the z305 table to be defined in the $usr_library.

Using util a/17/1 to define the z305 in the $usr_library eliminated the error message.

• Article last edited: 10/8/2013