My Oracle Support Banner

Full Dataload Contract Lifecycle Management For ECC Fails (Doc ID 2675875.1)

Last updated on JULY 08, 2020

Applies to:

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

Symptoms

Problem Summary
---------------------------------------------------
Full dataload Contract lifecycle management for ECC fails

Problem Description
---------------------------------------------------
The full dataload for ECC fail. In more detail the datasets PO-CLM-REQUISITIONS, PO-CLM-AWARD and PO-CLM-IDV are running into an error.


ERROR
-------------------
Following error per dataset occurs:
-PO CLM REQUISTIONS:
There is SQLException while applying load rule for dataset po-clm-requisitions for job 27,699. Exception details ORA-00942: table or view does not exist oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)

PO_CLM_AWARD:
There is SQLException while applying load rule for dataset po-clm-award for job 27,699. Exception details ORA-01403: no data found ORA-06512: at "APPS.PO_CLM_ECC_UTIL_PVT", line 32 ORA-06512: at "APPS.PO_CLM_ECC_UTIL_PVT", line 158 ORA-06512: at "APPS.PO_CLM_ECC_UTIL_PVT", line 2573 ORA-06512: at line 1 oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)

PO _CLM_IDV:
There is SQLException while applying load rule for dataset po-clm-idv for job 27,699. Exception details ORA-01403: no data found ORA-06512: at "APPS.PO_CLM_ECC_UTIL_PVT", line 32 ORA-06512: at "APPS.PO_CLM_ECC_UTIL_PVT", line 158 ORA-06512: at "APPS.PO_CLM_ECC_UTIL_PVT", line 2580 ORA-06512: at line 1 oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446) oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054) oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)

PO_CLM_SOLICITATIONS:
There is SQLException while applying load rule for dataset po-clm-solicitations for job 27,699. Exception details ORA-00942: table or view does not exist oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494) oracle.jdbc.driver.T


STEPS
-------------------
1. Login to the E-Business Suite and choose the CLM ECC Module.
2. Run full dataload for ECC
3. Fails with various errors

BUSINESS IMPACT
-----------------------
Due to this issue, users cannot complete full dataload

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.