Tuesday 17 October 2023
SQL Developer displaying Junk characters (??????)
Change the Encoding in SQL Developer Preferences as below
Tools --> Preferences --> Environment --> Encoding --> UTF-8 --> Restart the SQL Developer
After Restart we get the output as below
Monday 16 October 2023
EBS : SQL to find SID from Concurrent Request ID
SELECT a.request_id, d.sid, d.serial# ,d.osuser,d.process , c.SPID ,d.inst_id
FROM apps.fnd_concurrent_requests a
left outer join apps.FND_CONCURRENT_PROCESSES b on a.controlling_manager = b.concurrent_process_id
left outer join GV$PROCESS c on c.pid = b.oracle_process_id
left outer join GV$SESSION d on b.session_id=d.audsid
WHERE a.request_id =&ccr_req_id
Subscribe to:
Posts (Atom)
SQL Developer displaying Junk characters (??????)
Change the Encoding in SQL Developer Preferences as below Tools --> Preferences --> Environment --> Encoding --> UTF...
-
Solution: SELECT s.inst_id,a.request_id,s.sid,s.serial#,c.spid FROM apps.fnd_concurrent_requests a, gv$process c, gv$session s WHE...
-
$FND_TOP/sql/afsvcpup.sql Example: SQL> @$FND_TOP/sql/afsvcpup.sql Component Id Component Name Component Status Typ...
-
Error: [AutoConfig Error Report] The following report lists errors AutoConfig encountered during each phase of its execution. Errors a...