My Oracle Support Banner

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 FEBRUARY 27, 2019

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

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

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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.