5 Replies Latest reply on Nov 17, 2016 3:46 PM by RameshPatel

    Oracle EBS R12 low performance while searching for  AR transaction

    Krystian

      Hi There.

       

      I've got problem when i try to search for transaction .

       

      select * from ra_customer_trx t where upper(t.trx_number) like upper('048543/KAT 1/11/F')||'%' <- never ending

       

      select * from ra_customer_trx t where t.trx_number like upper('048543/KAT 1/11/F')||'%' <-- this is fine.

       

      why upper(t.trx_number) works so bad ?

       

      Regards

      Krystian