AD_PATCH_ANALYSIS_ENGINE package body invalid after 12.2 driver

Symptoms

SQL> select object_name,object_type, status from all_objects where object_name like ‘AD%’ and status like ‘INVALID’;

OBJECT_NAME

——————————————————————————–

OBJECT_TYPE                            STATUS

———————– ——-

AD_PATCH_ANALYSIS_ENGINE

PACKAGE BODY                         INVALID

SQL>

SQL> alter package AD_PATCH_ANALYSIS_ENGINE compile body;

Warning: Package Body altered with compilation errors.

SQL> sho errors

Errors for PACKAGE BODY AD_PATCH_ANALYSIS_ENGINE:

LINE/COL ERROR

——– —————————————————————–

54/12          PLS-00323: subprogram or cursor ‘GETGLOBALVIEWSNAPSHOTID’ is

    declared in a package specification and must be defined in the

    package body

SQL>

Solution:

1. Ignore the invalid PACKAGE BODY AD_PATCH_ANALYSIS_ENGINE at this time.
2. Apply the latest RUP 12.2.10 (30399999), RUP 12.2.11 (31856789) or above. The FUNCTION getGlobalViewSnapshotID is declared in both the Package Specification and the Package Body (adpaengb.pls) with below file versions, and will become VALID.
   
   <Patch30399999> R12.2.10 RUP
     adpaengs.pls 120.2.12020000.5
     adpaengb.pls 120.13.12020000.10

<Patch31856789> R12.2.11 RUP
  adpaengs.pls 120.2.12020000.5
  adpaengb.pls 120.13.12020000.10

Note: The AD_PATCH_ANALYSIS_ENGINE package is only used by Patch Wizard.

Metalink Reference:

AD_PATCH_ANALYSIS_ENGINE PACKAGE BODY Becomes Invalid with Error PLS-00323 When Upgrading to R12.2.0. (Doc ID 2876753.1)