Skip to Main Content

E-Business Suite

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to stop the outgoing notifications that are already in wf_notification_out - do not want to send

Salazkin AnnJun 18 2019 — edited Feb 9 2021

We had the WF Notification Mailer deactivated for some time and have about 1500 messages in queue 'READY' to be emailed  but we do not want to send those old notifications when we restart the components. How to stop them??

Checked Note 828812.1 - does not seem completely our case (we already have WF Mailer deactivated...

Comments

User_AMB14

/**
* Load a set of loot items into loot table from a Comma Separated Value (CSV) file
* @param fileName expected CSV format: | String name | int tries |
* @throws NumberFormatException if 2nd column isn't an integer (extra space?)
* @throws FileNotFoundException if can't find the CSV file (path & extension?)
* @throws IOException other I/O & storage problems
*/
public void load(String fileName){
try {
BufferedReader fileReader = new BufferedReader(new FileReader(fileName));
String lineItem;

  while ((lineItem = fileReader.readLine()) != null) {  
    String\[\] lootDetails = lineItem.split(",");  

    lootRecord record = new lootRecord();  
    record.name       = lootDetails\[0\];  
    record.tries      = Integer.valueOf(lootDetails\[1\]);  
    record.dropChance = calcDropChance(record.tries);  

    table.add(record);  
  }  
  fileReader.close();  
}  
catch (NumberFormatException e) {  
  System.out.println("Invalid String: Integer count of tries expected");  
  e.printStackTrace();  
}  
catch (FileNotFoundException e) {  
  e.printStackTrace();  
}  
catch (IOException e) {  
  e.printStackTrace();  
}  

} // load

1 - 1

Post Details

Added on Jun 18 2019
1 comment
82 views