File Integration Framework Process Fails For Language Different Than Base Language

(Doc ID 2394547.1)

Last updated on MAY 03, 2018

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

File integration framework process is failing if the language of the user is different from base language.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a PS Query using PERSONAL_DATA record
2. Restrict the result for one emplid using criteria
3. SQL & Result Should be as shown in the below screenshot:
4. Create User access setup & file definition (Setup HCM -> Common Definitions -> File Integration Framework). 
5.Change the Language of User PS to French in user profile
6.Navigate to File definition (Setup HCM -> Common Definitions -> File Integration Framework) and use Generate option (Provide some output file name) to trigger FF_GENFILE Process.
Process will fail with above mentioned error.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms