Best Of
Re: ORDS 25.1 ORDS_SECURITY vs OAUTH
Answering my own question, here is one way to regenerate client secrets that will work same way as using the OAUTH package and preserve the secret in ORDS_METADATA.USER_ORDS_CLIENTS.
DECLARE
CURSOR get_clients IS
SELECT uoc.name,
uoc.description,
uoc.client_id,
uoc.client_secret,
USER oracle_user
FROM user_ords_clients uoc
ORDER BY NAME;
l_client_cred ords_types.t_client_credentials;
l_client_cred_null ords_types.t_client_credentials;
BEGIN
FOR a IN get_clients LOOP
l_client_cred := l_client_cred_null;
l_client_cred.client_key.name := a.name;
-- l_client_cred.client_secret.secret := 'XaFhM690PA6cN1ffpkNx3Q..'; /* You can set the secret to specific value, NULL generates new value */
l_client_cred.client_secret.secret := NULL;
l_client_cred.client_secret.stored := TRUE;
l_client_cred := ords_security.register_client_secret (
p_client_key => l_client_cred.client_key,
p_client_secret => l_client_cred.client_secret,
p_revoke_existing => TRUE,
p_revoke_sessions => TRUE );
/*
No Commit Required, only SLOT 1 is saved to DB
*/
SYS.DBMS_OUTPUT.PUT_LINE(a.oracle_user||
' Slot:' || l_client_cred.client_secret.slot||
' Issued On:' || l_client_cred.client_secret.issued_on||
' Name: '||a.name||
' Old Secret: '||a.client_secret||
' New Secret: '||l_client_cred.client_secret.secret);
END LOOP;
END;
/
Re: how to get access to RFC in Managed cloud in MOS
Hello Sunderrajan,
Does the customer have a Managed Cloud SI? Are you on it? First thing is that you must have an Managed Cloud Services Support Identifier in your user profile; however, please do not post either personally identifiable information or customer information in this community thread. If you need me to investigate a privilege for you please reach out to me directly.
Once you have that sorted, there's a lot of good information about RFCs available here: My Oracle Support - Managed Cloud Services: Chapter 3 - Requests (RFC) (Doc ID 1567933.1).
I also encourage you to enhance your community profile by updating your community username.
Thank you,
Chad Pryor, Product Manager
My Oracle Support Customer Portal
Re: Unable to Terminate Service Contract – Clicking 'Terminate' Does Nothing
Hi Ashish,
So glad you figured it out. Thank you for updating here so we all know the solution! Mark your answer as the correct one / best answer to change the status on your question to answered. On discussions when there are more responses, it also puts the best answer at the top to make it easy for future readers to find.
Regards,
J
Re: Why is Project Team missing from Project Update Wizard?
The Project Team Update Type is not available if you have both Program Management and Resource Management installed on the Installation Options page. We noted this in one section of the PeopleBooks Online Help for the End Date Updates and it needs to be added to the Project Team Update text too.
Re: Unable to Terminate Service Contract – Clicking 'Terminate' Does Nothing
Just for reference: This is fixed after regenerate and recompile of OKC|OKS forms and Libraries
Thanks/Ashish
Re: 2025 Overtime Deduction Reporting
Hello Albina,
Please take a look at this KM Solution.
EPY: Is PeopleSoft Going to Deliver Patch Related to OBBBA(One Big Beautiful Bill Act)/No Federal Tax On Overtime & Tips As Per New Act? (Doc ID 3097587.1)
Regards,
Asif M -Oracle
Re: sql_id exists only at v$session and not at v$sql
Some handy statements, if you not already know them.
select SQL_ID,SQL_FULLTEXT from v$sql where sql_id='&&sql_id'; sELECT s.sid, s.sql_id, t.sql_text FROM v$session s JOIN v$sql t ON s.sql_id = t.sql_id WHERE s.sql_id = '&&sql_id'; SELECT sql_id, sql_text FROM v$sqltext WHERE sql_id = '&&sql_id'; SELECT sql_id, sql_text FROM dba_hist_sqltext WHERE sql_id = '&&sql_id'; select kglnaobj from x$kglob where kglobt03='&&sql_id';




