API to assign a Workflow role to user

 

begin

Wf_local_synch.PropagateUserRole(

p_user_name => p_user_name,

p_role_name => p_role_name,

p_start_date=>'01-SEP-21',

p_expiration_date=>'31-DEC-30');

commit;

excePtion

when others then

null;

end;

Query to find locked sessions of a particular Table

 select a.sid||'|'|| a.serial#||'|'|| a.process

 from gv$session a, gv$locked_object b, dba_objects c

 where b.object_id = c.object_id

 and a.sid = b.session_id

 and OBJECT_NAME=upper('<Table Name>');

OAF List personalizations

 

   begin  

  jdr_utils.listCustomizations('/oracle/apps/icx/por/req/webui/EditSubmitPG');  

  jdr_utils.listCustomizations('/oracle/apps/icx/por/req/webui/ShoppingCartPopupRN');  

 end;  

 

To Delete Customizations

 

begin  

   jdr_utils.deleteDocument('/oracle/apps/icx/por/req/webui/customizations/site/0/EditSubmitPG');  

   jdr_utils.deleteDocument('/oracle/apps/icx/por/req/webui/customizations/site/0/ShoppingCartPopupRN');

end;

/

XLA to AP link

select xdl.* from apps.XLA_DISTRIBUTION_LINKS xdl, apps.ap_invoices_all aia, apps. ap_invoice_distributions_all aida
where APPLIED_TO_ENTITY_CODE = 'AP_INVOICES'
and applied_to_source_id_num_1 = aia.invoice_id
AND xdl.source_distribution_type = 'AP_INV_DIST'
and SOURCE_DISTRIBUTION_ID_NUM_1 = aida.invoice_distribution_id
and aida.invoice_id=aia.invoice_id
and aia.invoice_num = &Inv_num
and aia.org_id = &org_id

Long running SQL Query

   SELECT CLIENT_IDENTIFIER

             USER_NAME,

         SYSDATE,

         ROUND (((S.LAST_CALL_ET / 86400)) * 24 * 60, 2)

             WAIT_TIME,

         S.SID,

         S.SERIAL#,

         S.Sql_id,

         s.inst_id,

         DECODE (s.sql_hash_value, 743038952, 'SAME', 'DIFFERENT')

             Hash_value,

         s.sql_hash_value,                                         --743038952

         S.STATUS,

         S.plsql_entry_object_id,

         S.MODULE,

         S.ACTION,

         SYSDATE - (S.LAST_CALL_ET / 86400)

             LAST_CALL,

         S.TYPE,

         S.USERNAME

             DB_USERNAME,

         S.OSUSER

             CLIENT_USERNAME,

         S.MACHINE,

         S.CLIENT_INFO,

         S.TERMINAL,

         S.LOGON_TIME,

         S.PROCESS,

         P.SPID,

         P.PID,

         s.*

    FROM GV$SESSION S, GV$PROCESS P

   WHERE     S.PADDR = P.ADDR(+)

         AND s.inst_id = p.inst_id

         AND S.MODULE IS NOT NULL

         AND S.STATUS = 'ACTIVE'

         AND NVL (S.TYPE, 'XXXXX') <> 'BACKGROUND'

         AND S.MODULE LIKE '%007%'                            -- CP Short name

--and sql_id = 'd1u4rr2gkcq33'

--  S.ACTION LIKE :ACTIONTYPE  AND

--S.OSUSER LIKE  :USR

--AND ROUND(((S.LAST_CALL_ET / 86400))*24*60,2) > :WAIT_TIME

ORDER BY ((S.LAST_CALL_ET / 86400)) * 24 * 60 DESC;