Database Security Products (MOSC)

MOSC Banner

Error during data masking script execution for R12 DATABASE

edited Feb 10, 2014 12:00PM in Database Security Products (MOSC) 3 commentsAnswered


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                                                      

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center