OEM 13c – AMP EBS Discovery Error Due To Lack Of Privileges

We recently had to enable monitoring for an EBS 11i system using the Application Management Pack. Even though the EM_MONITOR user was already provisioned by the EBS patch, the discovery was failing due to lack of privileges on several FND tables.My Oracle Support shows several bugs related to missing privileges like the one below, but… Continue reading OEM 13c – AMP EBS Discovery Error Due To Lack Of Privileges

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… Continue reading EBS ADOP Phase Failing Due to ORA-600 Error

ORA-04045 When Running ADOP PHASE=ACTUALIZE_ALL

Oracle’s documentation recommends to execute actualize_all inorder to purge old editions in the DB accumulated during previous patchingcycles.There’s a problem with EBS version 12.2.4 that when running adopphase=actualize_all you get an ORA-04045 errors duringrecompilation/revalidation of .You can try to manually recompile objects but all of them failwith the same error. This is documented under bug… Continue reading ORA-04045 When Running ADOP PHASE=ACTUALIZE_ALL

TXK patch failing with ORA-600

I got an error during an TXK patch in a 12.2 EBS instance. This happened while executing file xdotmgen.ldt.Error: FAILED: file xdotmgen.ldt on worker 1 for product fnd username APPS.Uploading from the data file....Uploading from staging tables Error during uploading. ORA-00600: internal error code, arguments: [17273], [0x13C88677A0], [0], [7], [], [], [], [], [], [], [],… Continue reading TXK patch failing with ORA-600