I am running HR Analytic full load against People HCM 9.1 but DAC load is failing. When I looked Informatica log files, I saw $$HR_WRKFC_EXTRACT_DATE values getting dropped. Like TO_DATE is showing O_DATE in the log file and due to that Informatica workflow is failing.
Anyone face this kind of issue?
This is a known issue with 9.0.1 Informatica (CR 256495). Ref: ID 1325631.1
Workaround to this issue, is to override INFA_CODEPAGENAME variable in the Integration Services to Latin1 and change the Integration Service code page to ISO 8859-1 Western European.
1. In Informatica admin console, go to Integration Service -> Processes tab
2. Edit the Codepage and change it to 'ISO 8859-1 Western European'
3. Edit Environment variables and add:
LANG = C
INFA_CODEPAGENAME = Latin1
4. Restart integration service.
Let me know if this helped.