Collaboration ODS Load Failing When Using Legacy Collections (Doc ID 2213126.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Collaborative Planning - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

MSCXPUBO: Collaboration ODS Load fails with:

Error while fetching records for New Open Deliveries in Unconsigned
ORA-00942: table or view does not exist
Total records fetched for ASN Deliveries :0
Total records for insertion for ASN Deliveries :0
updating pegging info for int reqs using ASN.
Total Records for update of Reqs from ASN : 1
Exception Deletion started
==========================
No. of deleted exceptions where first transaction does not present in CP transactions - 0
No. of deleted exceptions where second transaction does not present in CP transactions - 0

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms