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, [...]

SELECT 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, [...]

Step1: 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 [...]

Please click on the below link for the attachment. setting-up-language-profile-for-hdl-import-and-load-in-fusion-hcm  

SELECT 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, [...]

SELECT 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, [...]

SELECT 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, [...]

// 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 = new [...]

roll-back-the-import-load-program-submitted-in-hcm

calling-java-script-in-integrations