My Oracle Support Banner

B1_PKG_CF_ORDER Failing In Daily Jobs (Doc ID 2378468.1)

Last updated on MARCH 27, 2018

Applies to:

Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.6.0.0.0 and later
Information in this document applies to any platform.

Goal

On : 2.6.0.0.0 version, Install / Upgrade

B1_PKG_CF_ORDER failing in daily jobs

In OUA daily jobs, B1_PKG_CF_ORDER is failing with the below error:

ODI-1217: Session B1_PKG_CF_ORDER (88768) fails with return code ODI-1298.
ODI-1226: Step B1_F_ORDER fails after 1 attempt(s).
ODI-1240: Flow B1_F_ORDER fails while performing a Merge rows in Staging-IKM BI Fact Key Lookup- operation. This flow loads target table CF_ORDER.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-Target_UNIT (20)" is in error.
ODI-1298: Serial task "SERIAL-EU-Target_UNIT (20)" failed because child task "Merge rows in Staging-IKM BI Fact Key Lookup- (230)" is in error.
ODI-1228: Task Merge rows in Staging-IKM BI Fact Key Lookup- fails on the target connection B1.
Caused By: java.sql.SQLException: ORA-30926: unable to get a stable set of rows in the source tables

CF_Order fact was failing because of data issue in the CCB replication schema.

GoldenGate was unable to histories replication data properly. Hence, duplicates were coming during fact processing and fact job was failing wit error “Unable to get stable set of rows”.

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.