My Oracle Support Banner

Post Install Enterprise Command Center (ECC9) When Compiling the Invalid PAY_US_ECC_UTIL_PVT Package body Getting Error ORA-00918: Column Ambiguously (Doc ID 2932117.1)

Last updated on MARCH 12, 2023

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

Problem Statement

After the installation of EBS Enterprise Command Center V9, the Package body PAY_US_ECC_UTIL_PVT is in an invalid status when checking the patching logs.
When compiling PAY_US_ECC_UTIL_PVT Package body, the following error messages occur:

 

Post EBS Command Center V9 install. Package body PAY_US_ECC_UTIL_PVT is in an invalid state:
show errors package body PAY_US_ECC_UTIL_PVT
Errors for PACKAGE BODY PAY_US_ECC_UTIL_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
1326/1 PL/SQL: SQL Statement ignored
1419/86 PL/SQL: ORA-00918: column ambiguously defined
1723/1 PL/SQL: SQL Statement ignored
1825/108 PL/SQL: ORA-00918: column ambiguously defined
2077/1 PL/SQL: SQL Statement ignored
2171/108 PL/SQL: ORA-00918: column ambiguously defined
2427/1 PL/SQL: SQL Statement ignored
2522/108 PL/SQL: ORA-00918: column ambiguously defined

 

Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Install Enterprise Command Center (ECC9) > Package body PAY_US_ECC_UTIL_PVT is in Invalid status
2. Compile PAY_US_ECC_UTIL_PVT Package body > getting error

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


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