My Oracle Support Banner

RDE: SDE_RETAILSTOCKLEDGERWEEKFACT Failing With Interlock (Doc ID 2554057.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Retail Integration Bus - Version 16.0.1 and later
Information in this document applies to any platform.

Symptoms

Getting below error while running SDE_RETAILSTOCKLEDGERWEEKFACT.

ERROR
-----------------------
ODI-1226: Step SDE_RetailStockLedgerWeekFactLoad fails after 1 attempt(s).
ODI-1240: Flow SDE_RetailStockLedgerWeekFactLoad fails while performing a Insert new rows-IKM RA Oracle Generic Insert with Control- operation. This flow loads target table W_RTL_STCKLDGR_SC_LC_WK_FS.
ODI-1298: Serial task "SERIAL-MAP_MAIN- (10)" failed because child task "SERIAL-EU-BIAPPS_11g_RA_UNIT (90)" is in error.
ODI-1298: Serial task "SERIAL-EU-BIAPPS_11g_RA_UNIT (90)" failed because child task "Insert new rows-IKM RA Oracle Generic Insert with Control- (140)" is in error.
ODI-1228: Task Insert new rows-IKM RA Oracle Generic Insert with Control- fails on the target connection ORACLE_BI_APPLICATIONS.
Caused By: java.sql.SQLSyntaxErrorException: ORA-02049: timeout: distributed transaction waiting for lock

Steps To Recreate:
1. Execute SDE_RETAILSTOCKLEDGERWEEKFACT and note the above error.

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.