Adcfgclone error Oracle error -25153: ORA-25153: Temporary Tablespace is Empty has been detected in

  |     50% completed       ERROR: InDbCtxFile.uploadCtx() : Exception : Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -25153: ORA-25153: Temporary Tablespace is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
oracle.apps.ad.autoconfig.oam.InDbCtxFileException: Error executng BEGIN fnd_gsm_util.append_ctx_fragment(:1,:2,:3); END;: 1; Oracle error -25153: ORA-25153: Temporary Tablespace is Empty has been detected in FND_GSM_UTIL.APPEND_CTX_FRAGMENT.
        at oracle.apps.ad.autoconfig.oam.InDbCtxFile.uploadCtx(InDbCtxFile.java:220)
        at oracle.apps.ad.autoconfig.oam.CtxSynchronizer.uploadToDb(CtxSynchronizer.java:328)
        at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBCtx(FileSysDBCtxMerge.java:678)
        at oracle.apps.ad.tools.configuration.FileSysDBCtxMerge.updateDBFiles(FileSysDBCtxMerge.java:222)
        at oracle.apps.ad.context.CtxValueMgt.processCtxFile(CtxValueMgt.java:1680)
        at oracle.apps.ad.clone.ApplyApplTop.runCVM(ApplyApplTop.java:510)
        at oracle.apps.ad.clone.ApplyApplTop.runAutoConfig(ApplyApplTop.java:552)
        at oracle.apps.ad.clone.ApplyApplTop.doConf(ApplyApplTop.java:339)
        at oracle.apps.ad.clone.ApplyApplTop.doApply(ApplyApplTop.java:382)
        at oracle.apps.ad.clone.ApplyApplTop.(ApplyApplTop.java:267)
        at oracle.apps.ad.clone.ApplyAppsTier.(ApplyAppsTier.java:105)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
        at oracle.apps.ad.clone.util.CloneProcessor.run(CloneProcessor.java:67)
        at java.lang.Thread.run(Thread.java:595)

Solution:
Add Tempfile to the temporary tablespace. It will resolve the issue.

Locked object details of a spcefic database sessions

select substr(c.object_name,1,30),c.object_type,
   b.sid,
   b.serial#,
substr(b.module,1,25),
substr(b.action,1,30)
from
   v$locked_object a ,
   v$session b,
   dba_objects c
where  b.sid = a.session_id
and a.object_id = c.object_id and b.sid=1383;

Query to find out Sid details of form sessions of specific front end user

Query to find out Sid details of form sessions of specific front end user

select /*+ CHOOSE*/
s.sid,
s.serial#,
substr(s.username, 1, 6),
s.status,
substr(s.module, 1, 25),
substr(s.action, 1, 30),
s.last_call_et
from v$session s, v$process p
where p.addr = s.paddr and s.sid = nvl('&sid', s.sid) and
p.spid = nvl('&spid', p.spid) and
nvl(s.process, -1) = nvl('&ClientPid', nvl(s.process, -1)) and
s.action like '%&USER_NAME%';

Use the below query to find the sid and other details of specifice database module running(programs)

Use the below query to find the sid and other details of specifice database module running(programs)

select /*+ CHOOSE*/
s.sid,
s.serial#,
substr(s.username, 1, 6),
s.status,
substr(s.module, 1, 25),
substr(s.action, 1, 30),
s.last_call_et
from v$session s, v$process p
where p.addr = s.paddr and s.sid = nvl('&sid', s.sid) and
p.spid = nvl('&spid', p.spid) and
nvl(s.process, -1) = nvl('&ClientPid', nvl(s.process, -1)) and
s.module = '%&Module_name%';