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 – Assignment Working Hour Pattern
Oracle has provided a new feature where working hours for each day can be stored against assignment working hours. The data is stored in PER_WORKING_HOUR_PATTERNS_F table. Use below query to extract the data: Query to extract data in HDL format:
BIP – Extract UDT data
Use below query to extract data related to User Defined Tables in Oracle HCM
BIP – Query to extract File details loaded through File Import and Export
Use below query to extract files loaded through Tools -> File Import and Export along with UCM Content ID and the account used:
HDL – Sample file to close benefit certifications
Starting 23C, a new HDL object has been added to close any pending actions for benefits. The certification type is validated against a lookup called – BEN_ENRT_CTFN_TYP Below is a sample file to close any pending certification actions against “POC”: