How To End-date A Resource In The Fastest Way
(Doc ID 2656876.1)
Last updated on JUNE 22, 2022
Applies to:
Oracle Fusion CX Sales Cloud Service - Version 11.13.19.10.0 and laterInformation in this document applies to any platform.
How to end-date a resource in the fastest way?
Goal
End-date a resource in the fastest way.
Get the ResourceProfileId by querying the database as follows:
SELECT * FROM HZ_PARTIES where lower(PARTY_UNIQUE_NAME) like ' %username%' --please replace the username with the user that should be end-dated
Get the party_id and use it in the following query to check the status of the resource:
SELECT * FROM JTF_RS_RESOURCE_PROFILES WHERE PARTY_ID IN (300000093888819) --replace by partyid obtained from previous query
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |