APPSDBA Data Lake

  Log files for Autoconfig execution Oracle EBS R12.2.4 are below: On Applicaion Tier: $INST_TOP/admin/log/<MMDDhhmm> On Database Tier: $ORACLE_HOME/appsutil/log/<CONTEXT_NAME>/<MMDDhhmm> 3.Log files for start/stop of services from $ADMIN_SCRIPTS_HOME In below directory we will find log files related to start/stop process of oacore, forms, apache, opmn, weblogic admin server/node manager: $LOG_HOME/appl/admin/log 4.Log/Out files for Concurrent programs/managers in Oracle R12.2.4 are in below location: Log/Out files for Oracle Release 12.2 are stored in Non-Editioned filesystem(NE). Log files: $APPLCSF/$APPLLOG (or $NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/log) Out files: $APPLCSF/$APPLOUT (or $NE_BASE/inst/<CONTEXT_NAME>/logs/appl/conc/out) 5.Log files for OPMN and OHS processes in Oracle R12.2.4 are in below location: Below directory contains log files related OPMN process(opmn.log), OPMN Debug logs(debug.log), HTTP Transaction logs (access.log),sec...

 Sometimes even though post running. 1) SYNC workflow data into WF local tables 2) SYNC workflow local roles. 3)  Workflow directory user role validation select  role_name ,  EFFECTIVE_END_DATE   from  wf_local_user_roles  where  user_name = ' OHRID '   SELECT    DISTINCT  frt . RESPONSIBILITY_NAME ,  furg . end_date FROM          fnd_user_resp_groups furg ,          FND_RESPONSIBILITY fr ,          fnd_responsibility_tl frt ,          fnd_user fu WHERE  fu . user_name  =   ' OHRID ' AND    fu . user_id  =  furg . user_id AND    furg . responsibility_id  =  fr . RESPONSIBILITY_ID AND    frt . responsibility_id  =  fr . RESPONSIBILITY_ID AND  frt .LANGUAGE= 'US' ORDER   BY ...