My Oracle Support Banner

EBS Data Masking script generation failing with Make sure condition clauses are valid and all objects used in the condition are qualified with schema names. (Doc ID 2995550.1)

Last updated on DECEMBER 29, 2023

Applies to:

Oracle Applications Manager - Version 12.2.3 to 12.2.13 [Release 12.2Cloud to 12.2]
Information in this document applies to any platform.

Symptoms

When trying to generate EBS Data Masking script following Doc ID 2670270.1 - Section 2.1.8, the following error is reported in the masking script

ERROR COLUMN APPLSYS.FND_USER#.CUSTOMER_ID Invalid condition clause user_id not in (select user_id from FND_USER_MASKING_EXEMPTIONS) is found. Make sure condition clauses are valid and all objects used in the condition are qualified with schema names.
...........................................................................................................................
ERROR COLUMN APPLSYS.FND_USER#.DESCRIPTION Invalid condition clause user_id in (select user_id from FND_USER_MASKING_EXEMPTIONS) is found. Make sure condition clauses are valid and all objects used in the condition are qualified with schema names.
...........................................................................................................................
ERROR COLUMN APPLSYS.FND_USER#.EMPLOYEE_ID Invalid condition clause user_id not in (select user_id from FND_USER_MASKING_EXEMPTIONS) is found. Make sure condition clauses are valid and all objects used in the condition are qualified with schema names.

Changes

 No Known Changes

Cause

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
Symptoms
Changes
Cause
Solution


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