ORBO Employee Search does Not Work when Employee ID is in Lower Case

(Doc ID 2111441.1)

Last updated on AUGUST 17, 2016

Applies to:

Oracle Retail Back Office - Version 13.4.8 and later
Information in this document applies to any platform.


Search functionality of  Oracle Retail BackOffice (ORBO) employee module does not display any results or error message when employee is searched with lower case employee ID.

Instructions to Re-create:

  1. Create new user from the back end with Employee id as Alpha numeric i.e "posen1234". Here the posen is in small case.
  2. Use the below insert query to  create the user.
  3. Insert into PA_EM (ID_EM,ID_PRTY,ID_LOGIN,ID_ALT,PW_SLT_EM,PW_ACS_EM,NM_EM,LN_EM,FN_EM,MD_EM,SC_ EM,ID_GP_WRK,LCL,NUMB_DYS_VLD,DC_EXP_TMP,TYPE_EMP,ID_STR_RT,FL_PW_NW_REQ,TS_CR T_PW,NUMB_FLD_PW,VL_ACS_EM_BMC,TS_LOGIN_LST) values ('posen1234',1,'posen1234','posen1234','d357919d-8bae-41a9-b779-aecf5e27c63e', 'BuapEm75vvCOJEbur6s5A5x/ujs1KexakzYCdcqxVvU=','Application Administrator','Administrator','Application',null,'1',3,null,-1,null,0,'04241' ,'0', sysdate,0, EMPTY_BLOB(),sysdate);
  4. Go to BackOffice ->Employee->Search.
  5. Enter employee id as "posen1234" of newly created  employee.
  6. Click Search. Application does not search the employee.
  7. Update the Employee id  from the back end to "POSEN123".Use  update query,  update pa_em set id_em='POSEN1234' where id_login='posen1234'.
  8. Go to BackOffice ->Employee->Search.
  9. Enter employee id as  "POSEN1234".
  10. Click Search. Application is able to search the Employee and Employee details is displayed.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms