Alert Is Not Working After Uploading By FNDLOAD
(Doc ID 1087572.1)
Last updated on DECEMBER 05, 2019
Applies to:Oracle Alert - Version 12.1.2 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
***Checked for relevance on 10-Jan-2013***
Alert is not working after uploaded by FNDLOAD
1) The requirement is to create an event alert which will call a pl/sql procedure and that pl/sql procedure will call an workflow.
2) The Objects are working fine in the Instance. Whenever a Row is inserted in RCV_TRANSACTIONS for Transaction_type = 'RETURN TO VENDOR' the alert is firing.
3) An Install pack was created and Installing all the objects.
Using for the DOWNLOAD:
FNDLOAD apps/password=<PASSWORD> 0 Y DOWNLOAD $ALR_TOP/patch/115/import/alr.lct name=<NAME>.ldt ALR_ALERTS APPLICATION_SHORT_NAME='PO' ALERT_NAME='name=<NAME>'
for Upload we are using :
FNDLOAD apps/password=<PASSWORD> 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct name=<NAME>.ldt
4) As we have only one instance so for Installing the Alert we are manulally deleting it from the front end.
5) Now we have installed all the objects and created a Receipt Return which is inserting a row in the RCV_TRANSACTIONS table but the alert is not firing.
6) Checked the alert in alert manager and it is available. Now after doing some modification and reverting it (Suppose Clicking in UPDATE checkbox and Uncheck it ) Saving the alert.
7) Now if we try once again to create a Receipt Return then the alert is firing and the workflow notification is working.
So, it seems if we manually explicitly save the alert in Alert manager then only the alert is working.
Using also FNDLOAD UPLOAD we got the same issue:
FNDLOAD apps/password=<PASSWORD> 0 Y UPLOAD $ALR_TOP/patch/115/import/alr.lct $dir=<DIR>_TOP/admin/import/name=<NAME>.ldt UPLOAD_MODE=’REPLACE’
When we are using FNDLOAD then no trigger is getting created for that Table but the trigger is getting created only after the Alert is manually saved in the Alert Manager Form.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document