Errors ORA-39083 ORA-25001 While Creating Trigger During Apps Import

(Doc ID 1170463.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 06-Aug-2014***

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

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