select MAX(CASE WHEN seq =1 THEN parent_lot_number END) parentlot1, MAX(CASE WHEN seq =2 THEN parent_lot_number END) parentlot2, MAX(CASE WHEN seq =3 THEN parent_lot_number END) parentlot3, MAX(CASE WHEN seq =4 THEN…
Read MoreSELECT ppf.person_id, ppf.person_number, paam.assignment_number, to_char(ptp.start_date,’YYYY/MM/DD’) startdate, to_char(ptp.end_date,’YYYY/MM/DD’) enddate, ptp.period_name, to_char(trunc(sysdate),’YYYY/MM/DD’) executiondatetime FROM pay_payroll_actions ppa, pay_payroll_rel_actions pra, pay_assigned_payrolls_dn apd, per_all_assignments_m paam, pay_time_periods ptp, pay_rel_groups_dn prg, per_all_people_f ppf, pay_all_payrolls_f py, pay_consolidation_sets pcs,…
Read MoreStep1: Navigate to Set Up And Maintenance à Search Task à Manage Applications Core Descriptive Flexfields. Search with Flexfield Code: FND_LOOKUP_VALUES_B Step 2: Click on the Edit…
Read MorePlease click on the below link for the attachment. setting-up-language-profile-for-hdl-import-and-load-in-fusion-hcm
Read MoreSELECT papf.payroll_name, papf.period_type, pcs.consolidation_set_name, ptp.period_name, to_char(ptp.start_date, ‘YYYY/MM/DD’) start_date, to_char(ptp.end_date, ‘YYYY/MM/DD’) end_date, to_char(ptp.cut_off_date, ‘YYYY/MM/DD’) cut_off_date, to_char(ptp.regular_earn_date, ‘YYYY/MM/DD’) date_earned, to_char(ptp.regular_process_date, ‘YYYY/MM/DD’) payroll_run_date, to_char(ptp.default_paydate, ‘YYYY/MM/DD’) date_paid FROM pay_all_payrolls_f papf, pay_time_periods ptp, pay_consolidation_sets pcs…
Read MoreSELECT papf.person_number, ppnf.full_name employee_full_name, ppnf.first_name, ppnf.last_name, to_char(ppos.date_start, ‘MM/DD/YYYY’) date_start, paam.assignment_number, paam.primary_flag, paam.assignment_status_type active_status, paam.bargaining_unit_code, aapf.payroll_name, PAAM.ASS_ATTRIBUTE6 attribute_value FROM per_all_people_f papf, per_all_assignments_m paam, per_person_names_f ppnf, per_periods_of_service ppos, pay_payroll_assignments ppa, pay_pay_relationships_dn pprd,…
Read MoreSELECT hddsb.data_file_name, hdds.ucm_content_id, hdds.creation_date, hdds.data_set_name, hdds.imported_status, hdds.loaded_status, hdds.import_lines_success_count, hdds.import_lines_error_count, hdds.import_lines_total_count, hdds.import_success_count, hdds.import_error_count, hdds.loaded_count, hdds.error_count, hdpl.pval018 assignment_number, hdpl.pval008 element_name, hdpl.pval010 ldg, hdpl.imported_status import_status, hdll.validated_loaded_status validation_status, CASE WHEN hdll.validated_loaded_status = ‘UNPROCESSED’ THEN…
Read More// JavaScript program to illustrate // calculation of no. of days between two date <script type = “text/javascript” > // To set two dates to two variables var date1 =…
Read Moreroll-back-the-import-load-program-submitted-in-hcm
Read More