Product(s):	Exor Maintenance Manager
	Version(s):	4.8.0.0
	Environment:	N/A
	Area:	Inventory Loader
	Subarea:	N/A

Problem

Stage 2 of the inventory loader fails with error ORA-00904: "ITY"."ITY_HHPOS120": invalid identifier even though it's worked successfully before.  Often happens after an upgrade has been applied.

Solution

Run the latest version of the script exor\mai\admin\views\mai_transviews.sql.  The right version for 4.8.0.0 is 2.7.

Original Author:

Sarah Willis-Culpitt