Wednesday, July 17, 2024

Patch

 Pre Patch Analysis:


SELECT   a.bug_no,
          app.application_name,
           a.DIRECTORY,
           a.filename,
           a.old_version,
           a.new_version,
           DECODE (a.typeid,
                   'not applied',
                   'Unchanged File',
                   'upgrade',
                   'Changed File',
                   'new',
                   'New')
              change_type
    FROM   apps.fnd_imp_psmaster_vl a, apps.fnd_application_vl app
   WHERE   a.bug_no in ('35865350','36033961','36178678','36211820','36247239','36328493','36349505','36370240','36397384','36548655','36564407','36592636','36606890','36214033','36591466')
           AND app.application_short_name = a.app_short_name
ORDER BY   DECODE (a.typeid,
                   'not applied',
                   'Unchanged File',
                   'upgrade',
                   'Changed File',
                   'new',
                   'New') ASC;

No comments:

Post a Comment

Local VCN Peering (Using LPGs) vs Remote Peering

   Technical Architecture 1. Local VCN Peering (LPGs): Uses Local Peering Gateways to connect two VCNs within the same region -  Think of...