My Oracle Support Banner

Error ORA-00918 column ambiguously defined When Running CLM Dataload For Dataset po-clm-requisitions (Doc ID 2729060.1)

Last updated on MAY 01, 2023

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Enterprise Command Center

CLM data load errror in po-clm-requisitions for ECC version 5

 

Error

-----------------------

There is SQLException while applying load rule for dataset po-clm-requisitions for job 10,960.

Exception details ORA-00918: column ambiguously defined oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:509) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:461) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1104) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:550)

ALLOWD_RANGE_H column is in the select part of SQL twice for two different table/view.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run CLM ECC data load
2. See error



Changes

 

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
Changes
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.