Mask Execution Script Fails ORA-00942: Table or View Does not Exist

(Doc ID 1595128.1)

Last updated on MARCH 28, 2017

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Data Masking Pack

Trying to follow steps from note 1481916.1 Using Oracle E-Business Suite Release 12.1.3 Template for the Data Masking Pack with Oracle Enterprise Manager 12.1.0.2 Data Masking Tool

Mask execution script failed.
Get following error in log file:

ERROR
----------------------------------
SQL> create table ni_mask as
 2  select person_id,effective_start_date,business_group_id,(select
legislation_code from apps.per_business_groups where
business_group_id=paaf.business_group_id) leg_code,
 3  national_identifier,
...
41  from per_all_people_f PAAF
42  where business_group_id in (select business_group_id from
apps.per_business_groups where legislation_code in ('AU'    ,'AE'    ,'BE'  
,'CA'    ,'DE'    ,'DK' ,'ES' ,'FI'  ,'GB'    ,'HK'    ,'HU'    ,'IE'  
,'IN'    ,'KR' ,'KW' ,'MX'  ,'NL'    ,'NO'    ,'NZ'    ,'PL'    ,'RU'  
,'US' ,'SA' ,'SE'  ) );
from per_all_people_f PAAF
    *
ERROR at line 41:
ORA-00942: table or view does not exist



ERROR executing steps                                                        

ORA-06575: Package or function CAL_DOB is in an invalid state                

errorExitOraError!                                                          

Completed Data Masking. Starting cleanup phase.                              

...
End program - successful                                                    

declare
*
ERROR at line 1:
ORA-29874: warning in the execution of ODCIINDEXALTER routine
ORA-29960: line 1,  
DRG-10595: ALTER INDEX PER_EMPDIR_PEOPLE_N1 failed
DRG-10561: index PER_EMPDIR_PEOPLE_N1 is not valid for requested operation
ORA-06512: at "APPS.PER_EMPDIR_SS", line 3694
ORA-06512: at line 5



STEPS TO REPRODUCE
----------------------------------
-- to be clarified
follow steps from note 1481916.1 Using Oracle E-Business Suite Release 12.1.3 Template for the Data Masking Pack with Oracle Enterprise Manager 12.1.0.2 Data Masking Tool


ADDITIONAL INFORMATION
----------------------------------
masking script is run by SYSTEM user (as per note-the script however is using per_all_people_f table which is without prefixed by any user(like HR or APPS) and also there is no public synonym for this table.

 

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