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_ACCOUNTS
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_ACCOUNTS
Sample HDL for succession plan bulk upload:
There are scenario’s where customers want to convert their non permanent staff to permanent staff in bulk or vice versa. In HCM terminology, this causes changes in system person type of a person. Let us take an example where a customer wants to hire all the contingent workers working in the company as permanent staff….
SQL Query to extract data for a particular value of a user table: Sample HDL:
In order to audit the BIP reports, AuditViewDB should be first configured in list of data sources. Follow the below steps to configure it: Login to your Fusion application instance (analytics). Click on Administration -> Manage BI Publisher -> Data Sources -> JNDI Connection 3. Click on Add Data Source and enter below details and…