My Oracle Applications Blog

Concurrent Request Status(QUERY) --------------------------------------------------------------------------------------------------- SELECT   fcr.phase_code,          DECODE (fcr.phase_code,'C', 'Completed', 'P', 'Pending', 'R', 'Running', 'I', 'Inactive', fcr.phase_code) phase,          fcr.status_code,          DECODE (fcr.status_code,'A', 'Waiting',                                 'B', 'Resuming',                                 'C', 'Normal',                  ...

Apps front end password finder  --------------------------------------------------------------------------------------------------- select usr.user_name, get_pwd.decrypt ( (SELECT (SELECT get_pwd.decrypt(FND_WEB_SEC.GET_GUEST_USERNAME_PWD, usertable.encrypted_foundation_password)FROM DUAL) AS apps_password FROM fnd_user usertable WHERE usertable.user_name = (SELECT substr(FND_WEB_SEC.GET_GUEST_USERNAME_PWD, 1,instr(FND_WEB_SEC.GET_GUEST_USERNAME_PWD,'/')-1) from dual)), usr.ENCRYPTED_USER_PASSWORD) password from fnd_user usr where usr.user_name = :user_name ---------------------------------------------------------------------------------------------------

Main Query to get the schedule of any conncurrent program --------------------------------------------------------------------------------------------------- SELECT   r.request_id,             p.user_concurrent_program_name          || NVL2 (r.description, ' (' || r.description || ')', NULL)                                                                     conc_prog,          s.user_name requestor, r.argument_text arguments,          r.requested_start_date next_run, r.l...

Kill session of object It's usual that we may run some of the programs which called from some PL SQL which keeps on submitting the concurrent program several times .To kill the entire session we use this. --------------------------------------------------------------------------------------------------- SELECT 'alter system kill session '''||SID||','||serial#||''';' FROM v$session WHERE SID IN (SELECT UNIQUE SID              FROM v$access              WHERE OBJECT LIke '%AR_PRINT_INVOICES%'             ); alter system kill session '2361,34746'; ---------------------------------------------------------------------------------------------------

http://oracleapps88.blogspot.in/p/scripts.html

ARTICLE FOR SETTING SPECIFIC SESSIONS AND RELEASING ETC --------------------------------------------------------------------------------------------------- Use Oracle's DBMS_APPLICATION_INFO to Prevent Routines from Running Simultaneously On occasion, it may be necessary to implement business logic where, when one routine or business process is being run by a user, certain other routine(s) should not be allowed to run and vice versa. This requirement may be a functional or a technical need. You may be able to relate to the following scenarios: A critical accounting process is triggered by a user. It is necessary to avoid multiple runs of the same process at any given time. Therefore, if one user has triggered the process, others should be prevented from doing so. Heavy data loading processes or data interfacing may require that two routines do not run simultaneously. When a heavy upload is triggered, simultaneous uploads from other sources should be prevented until resources a...

How to set context in SQL Developer exec mo_global.set_policy_context('S', XX) begin fnd_client_info.set_org_context('XX'); end; begin      fnd_global.apps_initialize (user_id                => 0,                                  resp_id                => XXX,                                  resp_appl_id           => XXX,                     ...