BIP – Query to check if employee bank account is active or not
select ext_bank_account_id
,case when nvl(end_date,trunc(sysdate)) >= trunc(sysdate)
then 'Active'
else 'Inactive'
end active_inactive
from IBY_EXT_BANK_ACCOUNTSSimilar Posts
HDL – Sample HDL files load Content Items
To bulk upload items catalogs in HCM profiles, you can use ContentItem.dat. Each of the template have certain mandatory attributes like Context Name, Value Set Name or Value Set Id: S0, before you start preparing the file, you need to have below information handy: The values 3000122xxxxx aren’t valid for ContentItemValueSetId. You can get the…
BIP – Query to get Active Users for terminated employees
Once a worker is terminated in Oracle HCM Cloud, one would expect that associated User account to be inactive as well. For this to happen automatically, autoprovisioning rules should be setup which will remove the associated roles to the terminated worker’s user. In case, there is even a single role attached to the user, the…
HDL – Sample HDL file to create Role Provisioning Rules
The rules can be verified from UI, once the HDL load is successful:
BIP – Query to Extract Position FTE values
When position hierarchy is enabled in Cloud HCM, Manage Positions UI shows some dynamically populated fields along with Parent position. For example: Use the below query to extract above details: