My Oracle Support Banner

ORMBA Bill Fact 'NOR' Load Fails With Task Insert Not Null Errors ORA-00942: Table Or View <> Exist (Doc ID 2398209.1)

Last updated on MAY 14, 2018

Applies to:

Oracle Financial Services Revenue Management and Billing Analytics - Version 2.6.0.1.0 and later
Information in this document applies to any platform.

Goal

1. In Oracle Financial Services Revenue Management and Billing Analytics (ORMBA) the Bill Fact 'NOR' load fails with Task insrt Not Null errors ORA-00942: table or view <> exist
ODI-1226: Step BF_IF_BILL_NEW fails after 1 attempt(s).
ODI-1240: Flow BF_IF_BILL_NEW fails while performing a insert Not Null errors-CKM BI Fact- operation. This flow loads target table BF_BILL.
ODI-1228: Task insert Not Null errors-CKM BI Fact- fails on the target connection BI.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist
ODI-1226: Step BF_IF_BILL_NEW fails after 1 attempt(s).
ODI-1240: Flow BF_IF_BILL_NEW fails while performing a insert Not Null errors-CKM BI Fact- operation. This flow loads target table BF_BILL.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-Target_UNIT_1 (20)" is in error.
ODI-1298: Serial task "SERIAL-EU-Target_UNIT_1 (20)" failed because child task "insert Not Null errors-CKM BI Fact- (190)" is in error.
ODI-1228: Task insert Not Null errors-CKM BI Fact- fails on the target connection BI.
Caused By: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

Could you please assist ?
 

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.