Unable To Create Data Masking Format In Combination Of Random Number And Random Date (Doc ID 1628878.1)

Last updated on JUNE 26, 2015

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

Using Data Masking pack on EM 12c Grid Control and trying to develop a masking format for a varchar2 datatype column having values 99.999 % MM-DD-YYYY. Using format Random Number, Fixed String, Random Dates, but it showing following warning message:

"Unable to generate Sample Masked Data. The User Defined Function, Post Processing Function, or the Table Column that this format relies on may not exist in the repository."

Executing the masking script results in error "Invalid Number".

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