R12.2

[satish]

Hi erman,

Cross edition triggers will be created during cutover phase?can you correct me if i m wrong

[ErmanArslansOracleBlog]

cross-edition triggers(cet) are triggered when the changes are made.
So, ask this question to yourself- > when are the changes made?

in apply phase right?
We need them to be there, while we are patching(changing/modifying/upgrading things). So they are created before the cutover phase.

[satish]

Thank you

But i hope there is some ddl executed in cutover phase to pull the old data?pls correct if this is wrong.i already bought your ebook.but it is still nt clear

[satish]

Wanted to know what ddl executed in cutover phase?

[ErmanArslansOracleBlog]

In finalize phase, adop determines the DDL Statements to execute at cutover phase.
Later on, In cutover phase, adop executes the DDL statements prepared during the finalize phase.

Check this tool, it comes by default with EBS.. (the Online Patching Diagnostic Reports utility, $AD_TOP/bin/adopreports)

Also check -> ADZDSHOWDDLS.sql which is located under $AD_TOP.
ADZDSHOWDDLS.sql |  This script is used to show count & status of DDL execution by phase.
 
It gets that info from  ad_zd_ddl_handler table. So you can get that info from ad_zd_ddl_handler table as well.

You will see the DDLs in SQL_LOB column of ad_zd_ddl_handler table.