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
BIP – Extract Grade Ladder, Grade and Step details
Below query can be used to extract grade ladder, grades in ladder and step details of a grade.
HDL – Send notifications when loading participants in performance document
Whenever doing mass upload of participants in a performance document, there may be a need to send a notification message to the participants. To load participants, you need to use PerfDocComplete -> Participant business object. However, if the data is loaded without using “Message” attribute in Participant business object, no message will be sent to…
Reports (BIP) – Query to get Content Item Details
Use below sample queries to get details of loaded/created content items like – Languages, Degrees etc. Query to get language details: Query to get Degree Details:
BIP – Query to get Default Assignment Rules of the Course
Default Assignment Rules like Validity Period, Expiration, Renewal Options, Renewal Period etc are maintained at the course level in Oracle Learning Cloud. These details are stored in the backend table ‘WLF_ASSIGNMENT_RULES’. The query from below post can be joined with WLF_ASSIGNMENT_RULES using ASSIGNMENT_RULE_ID column: https://fusionhcmconsulting.com/2021/03/reports-bip-query-to-get-assignee-details-for-a-course/?amp and warf.ASSIGNMENT_RULE_ID = war.ASSIGNMENT_RULE_ID And you will get the required output.
BIP – Query to find list of same person having same position multiple times
On the responsive Position UI, the position screens shows the Pending Worker and Worker record as an incumbent and the FTE goes in negative. Below SQL can be used to identify such persons: