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;
Oracle EBS
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;
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>');
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;
/
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;
select segment_name,sum(bytes)/1024/1024/1024 GB
from dba_segments
where segment_type='TABLE'
and segment_name like 'XX%'
and segment_name=upper('XX_INV_ITEMS_STG')
group by segment_name
SELECT poh.segment1
po_number,
asp.segment1
vendor_number,
asp.vendor_name,
TRUNC (rt.transaction_date)
receipt_date,
(SELECT ood.organization_name
FROM apps.org_organization_definitions ood
WHERE organization_id = mmt.organization_id)
"Receipt Org",
TO_CHAR (TRUNC (rt.transaction_date), 'MON-YY')
"Month",
rsh.receipt_num,
msi.segment1
sku,
rsl.item_revision,
msi.description,
rt.quantity
line_quantity,
mtln.lot_number,
mtln.transaction_quantity
lot_qty,
msi.lot_control_code
FROM apps.rcv_transactions rt,
apps.rcv_shipment_headers rsh,
apps.rcv_shipment_lines rsl,
apps.mtl_system_items_b msi,
apps.po_headers_all poh,
apps.ap_suppliers asp,
apps.mtl_transaction_lot_numbers mtln,
apps.mtl_material_transactions mmt
WHERE 1 = 1
AND rsh.shipment_header_id = rt.shipment_header_id
AND rsl.shipment_header_id = rsh.shipment_header_id
AND rsl.po_header_id = rt.po_header_id
AND rsl.po_line_id = rt.po_line_id
AND rsl.po_line_location_id = rt.po_line_location_id
AND poh.vendor_id = asp.vendor_id
AND rt.po_header_id = poh.po_header_id
AND rsl.item_id = msi.inventory_item_id
AND rsl.to_organization_id = msi.organization_id
AND rt.transaction_date > '01-JAN-21'
AND rt.source_document_code = 'PO'
AND rt.transaction_type = 'DELIVER'
AND mmt.transaction_id = mtln.transaction_id(+)
AND mmt.rcv_transaction_id = rt.transaction_id
AND mmt.organization_id = rt.organization_id
AND mmt.inventory_item_id = rsl.item_id
--and mmt.transaction_type_id=18
AND poh.org_id = &P_ORG_ID
AND poh.attribute15 IS NULL
ORDER BY rt.transaction_date,
receipt_num,
sku,
lot_number