ORA-39083 ORA-25001

Errors ORA-39083 ORA-25001 While Creating Trigger During Apps Import [ID 1170463.1]

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 19-DEC-2012***

Symptoms

Migrating Oracle applications 11.5.10.2 from AIX 5.3 to RHEL 5.5 Using Apps Import received the following errors:

ORA-39083: Object type TRIGGER failed to create with error:
ORA-25001: cannot create this trigger type on views
Failing sql is:
CREATE TRIGGER "APPS"."RA_ADDRESSES_T1_VEH"
/* $Header: arpltvea.sql 115.1 99/10/14 14:54:20 porting sh $ */
/*======================== ra_addresses_t1_veh ===========================*/
/*============================================================================

TRIGGER NAME: ra_addresses_t1_veh

DESCRIPTION: Creates database triggers on ra_address
ORA-39083: Object type TRIGGER failed to create with error:
ORA-25001: cannot create this trigger type on views
Failing sql is:
CREATE TRIGGER "APPS"."RA_ADDRESSES_BRIU"
/* $Header: arpltadr.sql 115.5 99/07/17 01:03:07 porting s $ */
before insert or update on ra_addresses_all
referencing new as new
old as old
for each row
begin
/* Check if OSM has disabled address validation on a disconnected Application */
-- IF as_disco_addr_validation.ra_addresses_all(:new.address_id,

Cause

The below triggers are obsolete in 11.5.1 or higher:
APPS.RA_ADDRESSES_T1_VEH
APPS.AR_CUSTOMER_PROFILES_BRU
APPS.AR_CUST_PROFILE_AMOUNTS_BRU
APPS.RA_ADDRESSES_BRIU

Solution

You can ignore this error since these triggers (apps.ar_customer_profiles_bru, apps.ar_cust_profile_amounts_bru, apps.ra_addresses_briu) are are not used in 11.5.1 or higher. The base tables still exist, but are not used. They have been replaced with the TCA architecture (HZ_ tables).