Technology Stack - EBS (MOSC)

MOSC Banner

APPL_TOP and APPS Schema Synchronization

edited Nov 29, 2018 1:00AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

I recently found a couple packages in APPS that were older than the version in the patch files in the APPL_TOP.  It appears that for some reason, the patch files were not compiled.  Possibly an error in patching a while back.  adadmin has many options to recompile, maintain snapshots, etc.  But nothing that will validate patch files with compiled code.  Is there an AD utility, or custom utility that would validate the APPS objects against the patch files?

Example: 

$grep Header ./ad/12.0.0/patch/115/sql/adddb.pls

/* $Header: adddb.pls 120.0 2005/05/25 12:10:05 appldev noship $ */

select text from dba_source where text like '%adddb.pls%' and line<5;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center