Finding the running node of a concurrent request

SELECT outfile_node_name,          

       a.actual_start_date,

      a.actual_completion_date ,

      a.*

   FROM fnd_concurrent_requests a

WHERE concurrent_program_id =

        (select concurrent_program_id from fnd_concurrent_programs_tl where       user_concurrent_program_name like 'Programme Name' )

 --and argument1 = 'CONCUR' and argument2 = 'GET'

order by REQUESTED_START_DATE desc;

 EBS monitoring script

• Run Away Process
• Frmweb process

Printer Setup.

Lpd is printer queue name for windows and windows side they configure wintel queue to printer IP address.Thereafter  unix team setup it on server side to point the unix queue to Wintel LPD.

And lastly We setup in EBS/ERP Instance .From EBS side we can give test print to cross verify it .

Steps to configure printer in Oracle R12

a.      Login to R12 PROD with “System Administrator” responsibility

b.     Navigate InstallàPrinteràRegister

c.      Printer Name ß Same as Unix and Windows print queue (Case Sensitive)

d.     Printer Type = “--PASTA Universal Printer Type”

e.      Description = “Department, Location, Printer Model, Contact”

f.       Save

.    Verify printer Setup

 login frontend go to system administrator responsibility >concurrent>request>single request>

submit the Active Users XML request and in options assign the printer name then submit it.

It should completed successfully as below.

Once request completed click on view log it should show completed successfully with Printer name like below

**
Sometimes printer does not reflect in that case while submitting concurrent request we have to change stype to other format say, landscape 

To check the printer staus

lpstat -p | grep -i <Printer Name>

*enabled stats changes if any request comes to the printer on cm node.

To check the lpd of printer/Unix print queue

lpstat -v <Printer name>

Check print queue

lpq -a

stuck jobs 

lpstat -R |wc -l

check priner status and pending jobs

lpc status printer_name

By default CUPS will queue a maximum of 500 print jobs before rejecting further print requests. To quote directly from the CUPS manual :

The MaxJobs directive controls the maximum number of jobs that are kept in memory. Once the number of jobs reaches the limit, the oldest completed job is automatically purged from the system to make room for the new one. If all of the known jobs are still pending or active then the new job will be rejected.

Setting the maximum to 0 disables this functionality. The default setting is 500.

Enabling/Disabling print CPUS

cpusenable  printer_name

cpusdisable printer_name

Mobile Web Application 
Can login to EBS apps ok.

Can login to to MWA as sysadmin
found note: 1276621.1

Telnet to the host name and port and get the error MWA_PM_HANDLE_LOGIN_FAIL: Authentication failed
This occurs for all ports on all middle tiers



Check mwa services on webnode

ps -aef | grep Doracle.apps.mwa | grep -v grep |wc -l

 show any ports active 

running netstat - a | grep port #

      grep the port number
        $INST_TOP/admin/install

          grep "Port" mwa.cfg
         # MSCA Server Port Number, The port number on which
              mwa.TelnetPortNumber=10566,10568,10570
         # mwa.WapPort is the port number on which the MSSA server is listening
         #   mwa.WapPort = 8080
          mwa.WapPort = 8061
[       
        grep mwa $CONTEXT_FILE

Tried to bounce one of the nodes but MWA is not coming up.

Command to restart listeners


$INST_TOP/admin/scripts/mwactl.sh start

mwa lib initialization failed.

This was working until yesterday.
No Changes have been made that she is aware of.

Command to stop_force 


mwactl.sh -login apps/*** stop_force 10650
MWA Telnet Server Release: 1.0.8.4 [December 12th 2002]
I/O error.
Error: ServerManagerListener returned ''
mwactl: Error shutting down Telnet server


clear out log
cleared out the system.log
cat /dev/null > system.log

One of her co-workers found that a profile option had been changed.
Changed Profile option 'Sign-On:Notification (SIGNONAUDIT:NOTIFY)' on site level from Null to NO

---------------------------------------------------------------------

to enable to log

take the backup mwa.cfg and set mwa.LogLevel=trace

Edit $INST_TOP/admin/install/mwa.cfg set mwa.LogLevel=trace and restart the mwa servers.

mwa.logdir= /PROD/local/inst/apps/PROD_amxhwb05a/logs

Workflow agent listener

Web Path :
Path to the applications dashboard is 
 System Administrator >Oracle Applications Manager>Workflow Manager









EBS Path :

Here’s the steps to bounce the WF Agent Listener 

1.       Navigate

System Administrator-> Concurrent : Manager -> Administer

2.       Restart Workflow Agent Listener

<F11 Enter Query> -> Query “Workflow Agent Listener Service” -> Click on Restart

3.       Check Restart is completed successfully

Query “Workflow Agent Listener Service” until you both Actual and Target processes are back to “1


  System Administrator ->Concurrent -> Manager ->Adminster
  Query for  ' Workflow% '
Workflow Agent Listener Service
Workflow Mailer Service
Workflow Document Web Services Service

Restart -> To restart the services
Process -> To check the status ( terminated,active,deactivated)



Log file location 

ls -lrt $APPLCSF/$APPLLOG/FNDCPGSC*.txt

/ENV/shared/applcsf/log

Issues :
If see error in log file like below

GenCartCommException: ORA-01403: no data found
ORA-06512: at "APPS.FND_CP_GSM_IPC", line 539
ORA-06512: at line 1

Check the below values in EBS
   Actul and Target : Macth (1,1 or 0,0) - UP
  Actul and Target  :  Mismatch (1,0 ) - Terminate and Activate .

Concurrent Manager 

Manager status 

select decode(CONCURRENT_QUEUE_NAME,'FNDICM','Internal Manager','FNDCRM','Conflict Resolution Manager','AMSDMIN','Marketing Data Mining Manager','C_AQCT_SVC','C AQCART Service','FFTM','FastFormula Transaction Manager','FNDCPOPP','Output Post Processor','FNDSCH','Scheduler/Prereleaser Manager','FNDSM_AQHERP','Service Manager: AQHERP','FTE_TXN_MANAGER','Transportation Manager','IEU_SH_CS','Session History Cleanup','IEU_WL_CS','UWQ Worklist Items Release for Crashed session','INVMGR','Inventory Manager','INVTMRPM','INV Remote Procedure Manager','OAMCOLMGR','OAM Metrics Collection Manager','PASMGR','PA Streamline Manager','PODAMGR','PO Document Approval Manager','RCVOLTM','Receiving Transaction Manager','STANDARD','Standard Manager','WFALSNRSVC','Workflow Agent Listener Service','WFMLRSVC','Workflow Mailer Service','WFWSSVC','Workflow Document Web Services Service','WMSTAMGR','WMS Task Archiving Manager','XDP_APPL_SVC','SFM Application Monitoring Service','XDP_CTRL_SVC','SFM Controller Service','XDP_Q_EVENT_SVC','SFM Event Manager Queue Service','XDP_Q_FA_SVC','SFM Fulfillment Actions Queue Service','XDP_Q_FE_READY_SVC','SFM Fulfillment Element Ready Queue Service','XDP_Q_IN_MSG_SVC','SFM Inbound Messages Queue Service','XDP_Q_ORDER_SVC','SFM Order Queue Service','XDP_Q_TIMER_SVC','SFM Timer Queue Service','XDP_Q_WI_SVC','SFM Work Item Queue Service','XDP_SMIT_SVC','SFM SM Interface Test Service') as "Concurrent Manager's Name", max_processes as "TARGET Processes", running_processes as "ACTUAL Processes" from apps.fnd_concurrent_queues where CONCURRENT_QUEUE_NAME in ('FNDICM','FNDCRM','AMSDMIN','C_AQCT_SVC','FFTM','FNDCPOPP','FNDSCH','FNDSM_AQHERP','FTE_TXN_MANAGER','IEU_SH_CS','IEU_WL_CS','INVMGR','INVTMRPM','OAMCOLMGR','PASMGR','PODAMGR','RCVOLTM','STANDARD','WFALSNRSVC','WFMLRSVC','WFWSSVC','WMSTAMGR','XDP_APPL_SVC','XDP_CTRL_SVC','XDP_Q_EVENT_SVC','XDP_Q_FA_SVC','XDP_Q_FE_READY_SVC','XDP_Q_IN_MSG_SVC','XDP_Q_ORDER_SVC','XDP_Q_TIMER_SVC','XDP_Q_WI_SVC','XDP_SMIT_SVC');

Concurrent Queue 

SELECT a.concurrent_queue_name, SUBSTR(b.os_process_id,0,10) "OS Proc", b.oracle_process_id "Oracle ID",  b.process_status_code

FROM fnd_concurrent_queues a, fnd_concurrent_processes b

WHERE a.concurrent_queue_id=b.concurrent_queue_id

AND b.process_status_code='A'

ORDER BY b.process_status_code;

Concurrent Manager log location 

select fcp.node_name, 

TO_CHAR(fcp.last_update_date, 'DD-MON-RR HH24:MI:SS'), 

fcp.logfile_name 

FROM fnd_concurrent_processes fcp, fnd_concurrent_queues fcq 

WHERE fcp.concurrent_queue_id = fcq.concurrent_queue_id 

AND fcp.queue_application_id = fcq.application_id 

AND fcq.concurrent_queue_name = 'FNDCPOPP' 

order by 2 desc; 

User Management 

Respo assigned to a user

Connect to apps user

SELECT fu.user_name                "User Name",
       frt.responsibility_name     "Responsibility Name",
       furg.start_date             "Start Date",
       furg.end_date               "End Date",     
       fr.responsibility_key       "Responsibility Key",
       fa.application_short_name   "Application Short Name"
  FROM fnd_user_resp_groups_direct        furg,
       applsys.fnd_user                   fu,
       applsys.fnd_responsibility_tl      frt,
       applsys.fnd_responsibility         fr,
       applsys.fnd_application_tl         fat,
       applsys.fnd_application            fa
WHERE furg.user_id             =  fu.user_id
   AND furg.responsibility_id   =  frt.responsibility_id
   AND fr.responsibility_id     =  frt.responsibility_id
   AND fa.application_id        =  fat.application_id
   AND fr.application_id        =  fat.application_id
   AND frt.language             =  USERENV('LANG')
   AND UPPER(fu.user_name)      =  UPPER('username')  -- <change it>
   -- AND (furg.end_date IS NULL OR furg.end_date >= TRUNC(SYSDATE))
ORDER BY frt.responsibility_name;

End date all the users

use below script to end date all user’s in EBS – in Not in add users what you need it will take long time but this is the best way to end date user’s using fnd_user_pkg.updateuser.

DECLARE

   CURSOR user_cur

   IS

      SELECT user_name, end_date

        FROM fnd_user

       WHERE (end_date IS NULL OR end_date > TRUNC (SYSDATE))

         AND user_id > 1000

         AND user_name NOT IN

                ('MASTRACCIF', 'ANONYMOUS',

                 'CONCURRENT MANAGER', 'WFMAILEROWNER', 'ASADMIN',

                 'INITIAL SETUP', 'FEEDER SYSTEM', 'WIZARD', 'K32910',

                 'DBA_SUPPORT', 'IBE_ADMIN', 'HRMSADMIN',

                 'AME_ADMIN','CLAIMS','HOUSTONC','K116525','K19724','ROHRSSEKEV112908');

BEGIN

   FOR user_rec IN user_cur

   LOOP

      fnd_user_pkg.updateuser (x_user_name      => user_rec.user_name,

                               x_owner          => 'SEED',

                               x_end_date       => TRUNC (SYSDATE)

                              );

   END LOOP;

   COMMIT;

END;

/