Friday, June 23, 2006

FNDLOAD part II

I found out that when you delete a record and upload the new Alert to another database, FNDLOAD does not automatically delete that record. So, to accomplish that i had to build in an extra funtion in the config file and add an extra parameter to the FNDLOAD command.

The extra parameter is UPLOAD_MODE='REPLACE'
and the additional function is

if :UPLOAD_MODE = 'REPLACE'
then
delete from alr_actions
where alert_id = (select alert_id from alr_alerts
where alert_name like :alert_name);
end if;


With this extra code, the records are first deleted and inserted by FNDLOAD....

1 comment:

Sridevi Koduru said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, Oracle Manufacturing, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.