question on cross edition triggers

[Sri]

Hi Erman,

Need your help

[applscp@remsdev ~]$ adop -status


Enter the APPS password:
Connected.

==============================================================
ADOP (C.Delta.7)
Session Id: 20
Command: status
Output: /u05/APPS/fs_ne/EBSapps/log/status_20171020_095527/adzdshowstatus.out
===============================================================

Node Name       Node Type  Phase           Status          Started              Finished             Elapsed
--------------- ---------- --------------- --------------- -------------------- -------------------- ------------
remsdev      master     PREPARE         COMPLETED       2017/10/20 09:46:50  2017/10/20 09:48:57  0:02:07
                           APPLY           NOT STARTED
                           FINALIZE        NOT STARTED
                           CUTOVER         NOT STARTED
                           CLEANUP         NOT STARTED



File System Synchronization Type: None





adop exiting with status = 0 (Success)


Prepare phase was completed,but when i checked for Table Manager Status/Seed Manager Status from patch edition,i am not able to see any cross editoin triggers/tables that are prepared

SQL> Connected.
SQL> =  Seed Manager Status :


=========================================================================
=       Seed Data Tables that were prepared in the current edition
=========================================================================


=========================================================================
=      Seed Data Syncnronization Triggers
=========================================================================

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

No Actual objects  from patch edition

SQL> Connected.
SQL> =========================================================================
=                       Actual Objects for Current Edition
=========================================================================

Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

Generally after prepare phase,these cross edition triggers should be prepared right?but why i am not able to see them from patch edition?is this normal?

Please advice erman

Thank you

[ErmanArslansOracleBlog]

From where did you get this info? -> "Generally after prepare phase,these cross edition triggers should be prepared right"

did I write someting like that?  Any documents for reference?

[Sri]

No erman,you didnt write that.i was in a confusion with that.can you please correct that if i am wrong

[ErmanArslansOracleBlog]

I need to check that.

Cross Edition trigger should be there during the apply phase.
But they are created in prepare? I guess not.

I will check that and update you.

[Sri]

Thanks for the update erman.

I think below seed tables and cross edition triggers are created during prepare phase,not sure about other cross edition triggers.i will wait for yout next update.

ADOP_VALID_NODES>
WF_RESOURCES>
FND_PROFILE_OPTION_VALUES>

Thanks,
sri

[ErmanArslansOracleBlog]

REad this note ->

It says "When a Seed Data Table is prepared during the apply phase of adop" -- so it says seed data tables are prepared during the apply phase..

Architectural changes in Seed Data Tables with AD/TXK Delta 8 (Doc ID 2283796.1)..

[ErmanArslansOracleBlog]

There is still a confusion..

good question, but very spesific and internal.

Let's do like this.

Choose one table  (a seeded one)
Get the trigger list on it.
run adop prepare
Get the trigger list on it once again.
run adop apply
Get the trigger list on it once again.

Send me the outcome.

[Sri]

Sure erman,i will let you know the outcome

Thank you