EBS ADOP Phase Failing Due to ORA-600 Error

There’s an issue in EBS 12.2 and database 12.1.0.2 versions related to Materialized Views. While executing ADOP (prepare, apply, finalize or cutover) phases, the cycle could fail due to an ORA-600 : internal error code, arguments: [kqllod:no stub for dependency parent] error.
After working with Oracle, they provided information about BUG 27883586 related to MView Refresh or Create while they are editioned.
The solution is to apply patch 27883586 to the database which is currently available for August 2017 release and then recreate the MViews. Oracle also released a merge patch on top if this (28820125).
If you need it for a different release, please contact Oracle to provide it.
Happy patching,
Alfredo

1 thought on “EBS ADOP Phase Failing Due to ORA-600 Error”

  1. great note, today I had a similar issue on cutover adop phase, I was checking on the net and I found this note from a good fried, as an additional comment I have applied the following patch on DB side, this patch is for have more details about the DB objects in conflict Patch: 19953905 Before Patch application:Fri Mar 15 13:38:12 2019Errors in file /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/trace/EBSSUPT_ora_19120.trc (incident=296022):ORA-00600: internal error code, arguments: [kqllod:no stub for dependency parent], [], [], [], [], [], [], [], [], [], [], []After patch application Fri Mar 15 13:54:21 2019Errors in file /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/trace/EBSSUPT_ora_30970.trc (incident=327856):ORA-00600: internal error code, arguments: [kqllod:no stub for dependency parent], [XXBLA_DMRT_UTILS_PKG], [], [173], [9], [APPS], [1035232], [1075], [], [], [], []Incident details in: /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/incident/incdir_327856/EBSSUPT_ora_30970_i327856.trcUse ADRCI or Support Workbench to package the incident.See Note 411.1 at My Oracle Support for error and packaging details.Fri Mar 15 13:54:24 2019Dumping diagnostic data in directory=[cdmp_20190315135424], requested by (instance=1, osid=30970), summary=[incident=327856].Fri Mar 15 13:54:24 2019Errors in file /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/trace/EBSSUPT_ora_30976.trc (incident=327857):ORA-00600: internal error code, arguments: [kqllod:no stub for dependency parent], [XXBLA_INV_ORG_V], [], [173], [4], [APPS], [1669770], [710], [], [], [], []Incident details in: /u01/ebs/dev/12.1.0/admin/EBSSUPT_piaddevebsdb1/diag/rdbms/ebssupt/EBSSUPT/incident/incdir_327857/EBSSUPT_ora_30976_i327857.trcIn mi case two objects, one view and one package were the objects in conflict, (XXBLA_DMRT_UTILS_PKG and XXBLA_INV_ORG_V) after that I had to drop, execute cutover and then recreate the objects) now I am checking with Oracle support for check if there is a patch for does not have this kind of errors when the objects are views and packagesGood Job AlfredRegardsCarlos Romero

Leave a Reply

Your email address will not be published. Required fields are marked *