I am migrating data to On Premise and I notice that many of the sequence entities in my Oracle db are named with a number in the prefix, for example OSSEQ_26_OSUSR_a7l_APPLICAT
When I use DMM to run the data migration DMM cannot find these sequences, it is searching for OSSEQ_OSUSR_a7l_APPLICAT in this example.
Can anyone tell me where OS stores the sequence associated with a entity trigger and an entity?
When I append a record the sequence appears to be correct, but can anyone say if having a number in the sequence entity prefix is likely storing problems for the future? Does OS robustly track sequence names?
Just to add some further context, I can see the Entity has a trigger set in the db where the sequence is specifically named:
TRIGGER "OSADMIN_LX"."OSTRG_26_OSUSR_A7L_APPLICAT" BEFORE INSERT ON "OSUSR_A7L_APPLICAT" FOR EACH ROW BEGIN IF :new."ID" IS NULL THEN SELECT oshe_globals.setidentity("OSSEQ_26_OSUSR_A7L_APPLICAT".nextval) INTO :NEW."ID" FROM dual; END IF; END;
Am I right in thinking the sequence name is isolated and contained within the db, only being called when triggered within the db and OS does not get concerned about it?