| My triggers fails what could be the reason [message #123264] |
Fri, 10 June 2005 23:58 |
rsury
Messages: 26
Registered: May 2005
|
Junior Member |
|
|
This is my trigger. It compiled succesfully
CREATE OR REPLACE TRIGGER rwjf_supplier_site_to_pims
AFTER
INSERT OR UPDATE
ON po_vendor_sites_all
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
Declare
ReturnCode BOOLEAN;
ConcReqID NUMBER := 0;
Begin
if inserting then
insert into orasupplier@pconfig_zeus
select ora_supplier_id.NEXTVAL@pconfig_zeus,
:new.vendor_id,
:new.vendor_site_code,
vendor_name,
:new.address_line1,
:new.address_line2,
:new.city,
:new.state,
:new.zip,
sysdate,
99 create_by_prsn_id
FROM po_vendors pov
WHERE pov.vendor_id = :new.vendor_id;
end if;
End;
/
When I try to save a new site in Oracle Apps the following message comes up.
APP-SQLAP-10000: ORA-04098:trigger
'ABM.RWJF_ORA_SUPPLIER_TO_PIMS' is invalid and failed re-validation occured in
AP_VENDOR_SITES_PKG.INSERT_ROW<-APXVDMVD with parametres (VENDOR_SITE_ID = 28344) while perfoming the following operation: Insert values into PO_VENDOR_SITES
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
