Extra Condition Added To Value Set 'GB_PENSION_LETTERS' Causing Failure Of GB PAE - Employee Communications Generation (PDF) (Doc ID 2069433.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On Applications 12.1.3 :
When attempting to run the seeded GB PAE - Employee Communications Generation (PDF), the following error occurs.

-- Error
"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."

followed by

"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.



 -- Steps
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)
4. Return
5. Get error


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