How to kill a session which is locked in Oracle apps

-
 How to kill a session which is locked in Oracle apps
This Article is used to explain how to kill a session which is locked
a.            Check if the Package or table are locked using the below query
SELECT b.object_name,
              a.session_id,
                              a.oracle_username,
                              a.os_user_name,
                              a.process,
                              a.locked_mode
  FROM v$locked_object a,
              all_objects b
 WHERE a.object_id = b.object_id
If the Package or table is available in the above query then we need to kill the session
      b.    Get the serial number for the session based on the session id got from above Query.
SELECT SID,              serial#,
                             ownerid,
                             status,
                             server,
                             username,
                             osuser,
                             process,
                            machine
FROM v$session
              WHERE SID = ‘Session id from above query’
          c.    Command to kill the session
ALTER SYSTEM KILL SESSION 'Sid from query, Serial# from Query 2'

Comments

  1. UnknownJanuary 27, 2015 at 4:50 AM

    Its impressive to know something about your note on Oracle apps Course. Please do share your articles like this your articles for our awareness. Mostly we do also provide Online Training on Cub training oracle apps course.

    ReplyDelete
  2. Sekhar BynaMarch 16, 2015 at 10:14 AM

    Very intersting notes on ebusiness Suite
    Please do share your articles like this.THis link also useful to Find info On Oracle apps-jobs,interview tips,Resume preparation,functional issuesOracle eBusiness Suite

    ReplyDelete

Post a Comment

Popular posts from this blog

Oracle Shipping Network SQL Query

-
Useful Script for Oracle Shipping Network , I wrote custom function for GL Code , you may find below SELECT a.from_organization_code, a.from_organization_name,        a.to_organization_code, a.to_organization_name,  DECODE (a.intransit_type,                  2, 'Intransit',                  1, 'Direct'                 ) "Transfer Type",        (SELECT meaning           FROM apps.mfg_lookups          WHERE lookup_type = 'MTL_FOB_POINT'            AND lookup_code = a.fob_point) fob_point,        a.elemental_visibility_enabled, DECODE (a.routing_header_id,                  1, 'Standard',                  2, 'Insp...
Click for more

Oracle Ar Invoice Numbering Sequence alter to avoid missing in between by cache

-
1) Query up your invoice source , which user have reported Jump in number. Navigate>Setup>Invoice>Source 2) Execute the following script using your source as in step 1.   SELECT batch_source_id, org_id, name FROM ra_batch_sources_all WHERE name LIKE '<source>' ;   or use this query if you have access from database.   SELECT 'alter sequence AR.' ||seq.sequence_name|| ' nocache;' FROM ( SELECT name bsname, org_id org, 'RA_TRX_NUMBER_' ||BATCH_SOURCE_ID|| '_' ||org_id|| '_S' seqname FROM RA_batch_sources_all ) src, dba_sequences seq WHERE src.seqname=seq.sequence_name AND seq.cache_size; ORDER BY org /     3) Using the batch_source_id from the above query , execute the followingscript:   SELECT sequence_owner, sequence_name, cache_size FROM all_sequences WHERE sequence_name LIKE 'RA_TRX_NUMBER%1146%' ;     4) Execute the following:   ALTER sequence SEQ...
Click for more

How to call Auto invoice Import Program from Back end

-
Autoinvoice Import Program takes following parameters : argv[0]  program name argv[1]  parallel module name  [MAIN|PU?] argv[2]  running mode  [V|T|P] argv[3]  batch source id argv[4]  batch source name argv[5]  default date argv[6]  concatenated transaction flexfield attribute value argv[7]  transaction type id argv[8]  low bill to customer number argv[9]  high bill to customer number argv[10]  low bill to customer name argv[11] high bill to customer name argv[12] low gl date argv[13] high gl date argv[14] low ship date argv[15] high ship date argv[16] low transaction number argv[17] high transaction number argv[18] low sales order argv[19] high sales order argv[20] low invoice date argv[21] high invoice date argv[22] low ship to customer number argv[23] high ship to customer number argv[24] low ship to customer name argv[25] high ship to customer name argv[26] Call RAXTRX from RAXMTR flag ar...
Click for more