I have create one user in EBS but now i want to check how many roles i have assign to my user.

Hi Ahmed You have explained it so nicely! Great! BTW do you have any videos for Oracle EBS 12.2 Versions?

hi Mr.Ahmed, i want to ask about installation step, is it possible to install on Oracle EBS R12.0.6 ? if yes, which version ? thanks

decrypt oracle pass

That’s my dad

After installing my EBS R12.2.6 Appliance I had issues with the passwords for sysadmin, operations etc and the below helped: Before you can logon you will need to enable SYSADMIN and the Demo accounts, Oracle have provided scripts to do this e.g. [oracle@apps scripts]$ ./enableSYSADMIN.sh This script will let you set a new password for the SYSADMIN EBS Applications User, the default password most likely was “sysadmin”, so pick a different one now. Enter new password for SYSADMIN: Re-enter password for SYSADMIN: Changing password for SYSADMIN Log filename : L7583909.log Report filename : O7583909.out [oracle@apps scripts]$ [oracle@apps scripts]$ ./enableDEMOusers.sh Enter a new password for the EBS Applications Users, the default password most likely was “welcome”, so pick a different one now… Enter new password for DEMO users: Re-enter password for DEMO users: Setting password for DEMO users… Log filename : L7583911.log … [oracle@apps scripts]$

Ahmed, what is the reason for changing the Linux version to Ubuntu? What happens if you dont change the Linux version to Ubuntu?

Thanks Ahmed , helpful article for setting up and intsalling Oracle EBS on a PC or Laptop or personal server

copy /y /b ova.00+ova.01+ova.02+ova.03+ova.04+ova.05+ova.06+ova.07+ova.08+ova.09+ova.10+ova.11+ova.12+ova.13+ova.14+ova.15+ova.16+ova.17+ova.18 EBS_1223.ova

Congrats Ahmed! Really Inspiring !

Ahmed Jassat Workflow tipes Workflow Tip 1 Workflow Log location ------------------- SELECT fcp.logfile_name FROM fnd_concurrent_queues fcq, fnd_concurrent_processes fcp, fnd_lookups flkup WHERE concurrent_queue_name in ('WFMLRSVC') AND fcq.concurrent_queue_id = fcp.concurrent_queue_id AND fcq.application_id = fcp.queue_application_id AND flkup.lookup_code=fcp.process_status_code AND lookup_type ='CP_PROCESS_STATUS_CODE' AND meaning='Active'; ----------------------------------------------- Workflow tip 2 How to check if workflow is running ---------------------- select fsc.COMPONENT_NAME,fsc.STARTUP_MODE,fsc.COMPONENT_STATUS from APPS.FND_CONCURRENT_QUEUES_VL fcq, fnd_svc_components fsc where fsc.concurrent_queue_id = fcq.concurrent_queue_id(+) and fcq.USER_CONCURRENT_QUEUE_NAME like '%Mail%'; ------------------------------------- Workflow tip 3 Workflows sent in the last hour --------------------- select * from apps.wf_notifications where mail_status = 'SENT' and begin_date > sysdate - (1/24) order by begin_date desc;----------------------------- Workflow Tip 4 Status of all Workflows ----------------------------select * from wf_notifications order by begin_date desc ------------------ Workflow tip 5 E-mail addresses with spaces --------------------- select name, '['||substr(email_address, 1, 25)||']', orig_system from wf_local_roles where email_address like '% %'; ------------------------- Workflow tip 6 Update e-mail addresses with spaces -------------------------------------- update wf_local_roles set email_address = 'CORRECT E-mail' where Name = 'USERNAME';-----------------------------------

What a legend :)