Error during data masking script execution for R12 DATABASE
Hi Experts,
I am facing an error
While executing step(6) of "Step 2. Execute the Mask" in note:1481916.1,
facing the following error:
CREATE TABLE "JTF"."JTF_RS_RESOURCE_EXTNS_TL". . . .AS SELECT . . . c0m7748.NEW_VAL "RESOURCE_NAME", s."SOURCE_LANG", s."SECURITY_GROUP_ID" FROM "JTF"."JTF_RS_RESOURCE_EXTNS_TL$DMASK" s , MGMT_DM_TT_7748 c0m7748, (select rowid rid , case when CATEGORY IN ('EMPLOYEE','OTHER','TBH') then 1 end c 0m7748_cond FROM "JTF"."JTF_RS_RESOURCE_EXTNS_TL$DMASK" ) c WHERE s."RESOURCE_NAME" = c0m7748.ORIG_VAL AND c0m7748.delete_val = 0 AND c.c0m7748_cond = c0m7748.cond_num AND c.rid = s.rowid ERROR executing steps ORA-904: "C0M7748"."COND_NUM": invalid identifier errorExitOraError! Completed Data Masking. Starting cleanup phaseStarting cleanup of generated procedures Completed cleanup of generated procedures Script execution complete Program: fndusmaexpr Process FND_USER_MASKING_EXEMPTIONS ====================================== ... setup context. ... process records. ====================================== End program - successful