My Oracle Support Banner

When Running Active Users and Responsibilities Report It Fails With APP-FND-00798: Invalid Reference Allownulls In Value Set Attached To Segment Error (Doc ID 2660937.1)

Last updated on APRIL 20, 2020

Applies to:

Oracle Concurrent Processing - Version 12.2.9 to 12.2.9 [Release 12.2]
Information in this document applies to any platform.


On : 12.2.9 version, Request Processing

APP-FND-00798: Invalid reference Allownulls in value set attached to segment.

Running the concurrent request, Active Users and Responsibilities and it is generating the error.

Found the MOS note:2148006.1 which talks about the similar error and the patch mentioned in the note is already applied in system.

APP-FND-00798: Invalid reference ALLOWNULLS in Value Set Attached to Segment. Please check the WHERE clauses of your table validated value sets.

The issue can be reproduced at will with the following steps:
1. Submit Active Users and Responsibilities Report

2.  Report Errors.




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.