After Supplier Is Updated, Alert On AP_SUPPLIERS Table Is Triggered Twice
(Doc ID 1969553.1)
Last updated on MARCH 08, 2017
Applies to:Oracle Payables - Version 12.0.0 to 12.2.4 [Release 12.0 to 12.2]
Information in this document applies to any platform.
As part of enabling Oracle Alert functionality, the following trigger is created on the AP_SUPPLIERS table:
create trigger TEST_SUPP_UPD_ALERT_AU AFTER UPDATE on AP.AP_SUPPLIERS for each row
insert into XXTEST_SUPP_ALERT_UPD values (:new.VENDOR_ID, :new.LAST_UPDATE_DATE);
When supplier data is updated through the Supplier Master pages, multiple rows are inserted into the table XXTEST_SUPP_ALERT_UPD. The expectation is that only one row would be inserted.
Please explain / provide fix.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!