Extra Condition Added To Value Set 'GB_PENSION_LETTERS' Causing Failure Of GB PAE - Employee Communications Generation (PDF)
Last updated on FEBRUARY 06, 2018
Applies to:Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.
On Applications 12.1.3 :
When attempting to run the seeded GB PAE - Employee Communications Generation (PDF), the following error occurs.
"APP-FND-00798: Invalid reference ORIG_DUMMY in value set attached to segment Letter
Please check the WHERE clauses of your table validated value sets."
"APP-FND-00730: This flexfield has an invalid value set. It may use a special value set that uses an Edit event user exit, and the user exit has failed. If you are using a form on a graphical user interface (GUI) you may have an invalid value set of a different type, possibly a table-validated value set where the table or view does not exist or where there is an invalid WHERE clause.
Contact your system administrator or support representative to check and correct the value sets this flexfield uses."
-- What is working
It was working before RUP 8
We have confirmed that Standard oracle concurrent program 'GB PAE - Employee Communications Generation (PDF)' is using the value set 'GB_PENSION_LETTERS' for Letters parameter which has been modified by RUP8 patches. Extra where condition :$FLEX$.ORIG_DUMMY = 'Y' has been added to this value set which generates the error message.
The issue can be reproduced at will with the following steps.
1. Apply RUP 8
2. (N)Processes and Reports > Submit Processes and Reports
3. Select GB PAE - Employee Communications Generation (PDF)
5. Get error
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