-
-
-
BIP – Query to get position profile details
Query to extract only the profile data:
-
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.
-
Reports (BIP) – Query to find module type and key
While defining Common Lookups or value sets, you need to provide module value. Each module has an associated module type, module key and product code associated with it. For example: These details are stored in backed in a table – FND_APPL_TAXONOMY. Use the below query to find module type, module key etc for a module:
-
Data Masking – Mask Salary Data in lower environment
There is a common requirement to mask salary data post P2T refreshes. This should be done in order to hide the actual salaries information as salary is a very sensitive information. Use the below query to generate data in HDL format in a test environment immediately after P2T refresh. The below query generate a random…
-
-
-
-
-
-
Reports (BIP) – Query to extract default Access Group data for a Course/Offering
In Oracle Learning cloud, Learning Admin can define the Default access at Course or offering level. Course.dat can be used to load this information. In order to extract this information from DB in HDL format, please use below query: Also, learners can be assigned using Access Groups. To extract this information below SQL can be…
-
Reports (BIP) – Query to get correct time zone
When an activity in learning is created with a start time and end time, the time is stored in UTC format in the data base. When any reporting is done on this data, the output is incorrect as time is shown in UTC format which is different from user time format. This is applicable for…
-
-
Reports (BIP) – Query to extract Manage Person Name Styles
Manage Person Name Styles is a task that can be used to configure additional Name attributes for a country if required. Also, a name component can be made required as per requirement. In multi country implementations, it is required to know the setup for technical developers as it is hard to check the setup for…
-
-
-
Reports (BIP) – Query to get Adjustments in Absences
select papf.person_number,ppnf.full_name,absence_plan.name ,apaed1.value,apaed1.type,to_char(apaed1.procd_date,’DD-MON-YYYY’) processed_date,apaed1.created_byfrom anc_per_acrl_entry_dtls apaed1,ANC_PER_PLAN_ENROLLMENT apaed,per_all_people_f papf,per_person_names_f ppnf,(SELECT aapf.absence_plan_id, aapft.NAMEFROM anc_absence_plans_f_tl aapft,anc_absence_plans_f aapfWHERE aapft.absence_plan_id = aapf.absence_plan_idAND aapf.plan_status = ‘A’ — added to pick only Active Absence PlansAND trunc(SYSDATE) BETWEEN aapf.effective_start_date AND aapf.effective_end_dateAND trunc(SYSDATE) BETWEEN aapft.effective_start_date AND aapft.effective_end_dateAND aapft.language = ‘US’) absence_planwhere apaed.plan_id = absence_plan.absence_plan_idand apaed.plan_id = apaed1.pl_idAND ppnf.name_type = ‘GLOBAL’AND ppnf.person_id = apaed.person_idAND ppnf.person_id…
-
Reports (BIP) – Function to get weekly schedule details
Use below query to get weekly schedule details of a worker:
-
Reports (BIP) – Query to extract Worker disability details
Below query can be used to extract disability details of a worker: