Recently we have use case where customer would like to
- Extract Time Card data from HCM
- Addition data from some other HCM tables
- Load data in ADW
- Validate and Merge data from HCM extract as well data from other HCM tables
- Generate a new extract ( combination of Step#1 and 2)
- FTP file to customer .
And to implement this , I have designed a simple OIC flow . This OIC flow is scheduled flow and on execution
- Validate if HCM extract files is available in UCM or not , if available then Read HCM files , process the data from HCM extract file and load into a database table (table1) in ADW, if no HCM extract file available in UCM server not then stop any further processing
- Trigger a BIP report
- Read data from BIP report and load into Table ( Table2) in ADW
- Call DB api over DB adapter connection, validate data from Table1 , table2. Combined data from these 2 tables
- Call SFTP adapter and load data into SFTP server,
- Archive HCM extract file
Below is very High level Process flow
for additional details feel free to reach me at email@example.com.