Find Current temp tablespace usage

 select a.tablespace_name tablespace,

d.TEMP_TOTAL_MB,

sum (a.used_blocks * d.block_size) / 1024 / 1024 TEMP_USED_MB,

d.TEMP_TOTAL_MB - sum (a.used_blocks * d.block_size) / 1024 / 1024 TEMP_FREE_MB

from v$sort_segment a,

(

select b.name, c.block_size, sum (c.bytes) / 1024 / 1024 TEMP_TOTAL_MB

from v$tablespace b, v$tempfile c

where b.ts#= c.ts#

group by b.name, c.block_size

) d

where a.tablespace_name = d.name

group by a.tablespace_name, d.TEMP_TOTAL_MB;

There are no Active Responsibilities available for this User in Oracle EBS R12

We have created new Oracle user in EBS application and assigned the responsibilities. After user logged in, not able to see any responsibilities in home page.

Error:

In the Home Page, Reponsibility Navigator (Left Side), shown "There are no Active Responsibilities available for this User".

Action Taken:

We have tried below. But no luck.

1. Run the request "Synchronize WF LOCAL tables".
2. Run the request "Workflow Directory Services User/Role Validation" Parameters : 100000, Yes, No, No---User level
3. Run the request "Workflow Directory Services User/Role Validation" Parameters : 100000, No, Yes, No---User level

Solution:

1. In Home Page, Navigator (Left Side), Click on "Personalize" button. It will open another page called "Personalize Navigator".
2. In Personalize "Search", by default 'Display' will be with "All Responsiblities". Click on "Go" button.
3. After click on "Go", all responsibilities will be listed that assigned to the user and "Status" column will be in 'Hidden'.
4. Now, click on "Show All" button and "Status" will become 'Shown' and click on "Apply".

Now we can able to see all responsibilities in the Home Page Navigator.

Find concurrent Request Performance History Per Day

SELECT TO_CHAR(TRUNC(ACTUAL_START_DATE),'DD-MON-YY DY') STARTDATE,
COUNT(*) COUNT, ROUND(SUM(ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE) * 24, 2) RUNNING_HOURS,
ROUND(AVG(ACTUAL_COMPLETION_DATE - ACTUAL_START_DATE) * 24, 2) AVG_RUNNING_HOURS,
ROUND(SUM(ACTUAL_START_DATE - REQUESTED_START_DATE) * 24, 2) PENDING_HOURS,
ROUND(AVG(ACTUAL_START_DATE - REQUESTED_START_DATE) * 24, 2) AVG_PENDING_HOURS
FROM APPLSYS.FND_CONCURRENT_PROGRAMS P,APPLSYS.FND_CONCURRENT_REQUESTS R
WHERE R.PROGRAM_APPLICATION_ID = P.APPLICATION_ID
AND R.CONCURRENT_PROGRAM_ID = P.CONCURRENT_PROGRAM_ID
AND R.STATUS_CODE IN ('C','G')
AND TRUNC(ACTUAL_COMPLETION_DATE) > TRUNC(SYSDATE-6)
AND TO_CHAR(TRUNC(ACTUAL_START_DATE),'DD-MON-YY DY') IS NOT NULL
GROUP BY TRUNC(ACTUAL_START_DATE)
ORDER BY TRUNC(ACTUAL_START_DATE) ASC;

Find TLS Version in Linux

openssl s_client -connect google.com:443 -tls1_2

If you get the certificate chain and the handshake ok. It supports TLS 1.2. If you don’t see the certificate chain, and something similar to “handshake error” you know it does not support TLS 1.2. You can also test for TLS 1 or TLS 1.1 with -tls1 or tls1_1 respectively.