My Oracle Support Banner

HCM 9.2 : Query Data Masking - Application Engine EODP_QRY_REF Abended With Error: "Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_EODP_QRY_STG) violated " (Doc ID 2815819.1)

Last updated on OCTOBER 20, 2021

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


On : 9.2 version, PUM 37

When attempting to set up Query Masking by adding some fields containing sensitive data, the Application Engine EODP_QRY_REF abended with the following error captured in the Error Log:

Steps to replicate the issue:

  1.Navigate to Enterprise Components > Data Privacy Framework > Maintain Data Privacy Settings: Add a record and field

Create composite query NIU_CMS_PART_TIME_AUDIT_COMP with UNION Code with delivered tables

  2.Click on Manage References button and select Update References. Change Refresh References to On. Click Yes to reload references.




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.