Why does sca_entity table having entries for composite revisions which were undeployed in the past? (Doc ID 3028042.1)

Last updated on JUNE 17, 2024

Applies to:

Goal

On : 12.2.1.3.0 version, Deployment

While executing the query below

SELECT sp.name folder
  ,se.composite
  ,se.revision
  ,se.*
  FROM xxxxx_soainfra.sca_entity se
  ,xxxxx_soainfra.sca_partition sp
 WHERE sp.id = se.sca_partition_id
  AND se.state = 'active'
  AND se.type = 'composite'
  AND se.composite = 'xxxxxxxxxxx'
 ORDER BY se.composite
  ,se.revision;


For example the query returns revisions 1.02 and 1.05 for a particular composite.

However when searching for this composite in EM console, only the latest revision 1.05 exists. The older revision (1.02) doesn’t exist and was undeployed in the past.

Why does the above query still return the older (undeployed) revision 1.02?
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.