Where is the data stored for Setup IFS Connect Mail Sender parameters? Is there a specific database table object? I need to edit the host after we run our Replication to our DEV environment otherwise it starts emailing dupilcate statements to customers before I can get the DEV IEE apps configured properly.
When you replicate the target database from a source database, you need to store the basic data from the target database and apply them back into the target database after replicating. You need to identify all the basic data tables you need to keep data and then you can use "Oracle Database Utility - Oracle Data Pump" to export and import basic data.
The relevant Oracle database help documentation:
Database Utilities - https://docs.oracle.com/cd/E11882_01/server.112/e22490/part_dp.htm#i436481
In your issue regarding the basic data of the IFS Connect functionality, you can store data from the basic data table fndcn_config_param_tab and apply it back into the database after replicating.
hi
As Jagath has mentioned this record will be saved in fndcn_config_param_tab
and you can query this record using below query
select * from FNDCN_CONFIG_PARAM_TAB t
where t.instance_name = 'MAIL_SENDER1'
and t.area_name = 'Integration'
and t.group_name = 'ConnectorSenders'
and t.parameter_name = 'HOST'
Cheers,
Thilini
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.