4 Replies Latest reply on Apr 30, 2016 4:45 AM by User562648-Oracle

    Oracle Alert Truncating Column

    3042782

      Using EBS R12 and setting up an alert that includes the address. Column Overflow is set to Wrap with a Max Width of 80. However, the City column keeps getting truncated after 5 characters. Here is the format:

       

      Order:&order

      Customer:&cust

      Address:&addr1

      &addr2

      &city &state &zip

      Ship Method:&shipmethod

      Last Updated By:&user

       

      The results I am receiving:

       

       

      Order: 3008177                                                         

      Customer:CUSTOMER

      Address:123 MAIN STREET                                          

      SUITE 200

      BERL- NJ 99999

      IN

      Ship Method:TRUCK-LTL-Ground

      Last Updated By:JDOE

       

      The city should be "BERLIN". I've tried setting the Alert Details Max Characters to 10 but it didn't help. The only way I am able to get the entire city to display on one line is for it to be the only column on the line. None of the city names in the alert are more than 8 characters long. City is always 2 characters and zip is always 5. Any idea why this column is behaving this way?