Objective:

Post doing the conversion in Fusion HCM, it is important to reconcile the match between the conversion records and loaded records. In order to match the records, you have to build a BIP report to get the details from the system.

Note: Source System Owner may differ with your conversion. Please align the correct source system owner in your query.

 

Query:

SELECT distinct source_system_owner
,source_system_id
,TO_CHAR(DATE_FROM,’YYYY/MM/DD’) EFFECTIVE_START_DATE
,TO_CHAR(DATE_TO,’YYYY/MM/DD’) EFFECTIVE_END_DATE
,NAME ORGANIZATION_NAME
, CLASSIFICATION_CODE
FROM PER_ORGANIZATION_UNITS POU
,HR_ORG_UNIT_CLASSIFICATIONS_F HOU
,per_location_details_f loc
— ,per_location_details_f_tl lot
,hrc_integration_key_map hrc
WHERE 1=1
AND POU.ORGANIZATION_ID=HOU.ORGANIZATION_ID
AND hrc.object_name like ‘Locat%’
AND hrc.source_system_owner =’VISION’
AND hrc.surrogate_id=pou.location_ID
AND trunc(sysdate) BETWEEN loc.effective_start_date and loc.effective_end_date

Recent Posts

Start typing and press Enter to search