ZD_edition_name and seed data

[Laurel]

Hi Erman!
Is the seed data in seed tables will have "duplicate rows"   when selecting as system ?
or those will be cleanuped after finalize/cutover ?
 I dont see those cleanup at all - see its always there :)
as sysdba
select concurrent_program_id,zd_edition_name from applsys.fnd_concurrent_programs_tl where concurrent_program_id=54329 and language='US';
CONCURRENT_PROGRAM_ID ZD_EDITION_NAME
54329 SET1
54329 SET2

as apps/xxx
 select concurrent_program_id,zd_edition_name from fnd_concurrent_programs_tl where concurrent_program_id=54329 and language='US';
CONCURRENT_PROGRAM_ID ZD_EDITION_NAME
54329 SET1

That means we need to re-write monitoring scripts as those run by sysdba..
Thx! Laurel

[ErmanArslansOracleBlog]

How do you monitor the system?
Using Apps or Sys?

As we see in the outputs that you sent, there is only one row returned when you run the query using apps account..

[ErmanArslansOracleBlog]

Also, read this note: Why Are There Duplicates In Hr.per_assignment_status_types table on 12.2.x? (Doc ID 2346969.1)

It explains the situation..

Look what it says:

There will be 2 SETS SET1 and SET2 for seed data. This table holds seed data, so when the table is prepared the second set is created. Going forward these 2 sets will be flipped whenever a patch that prepares this seed table is applied.

"Yes, customer has to query the data from the APPS View as the view will set which set is active and display the data from that view."