OBIA 11g BIACM Load Plan Failed - ODI-1529: Refresh of variable "BIAPPS.TODAY_WID" failed (Doc ID 1964423.1)

Last updated on MAY 05, 2017

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.1 and later
Information in this document applies to any platform.
May 05, 2017

Symptoms

OBIA 11.1.1.7.1 

In BIACM, the load plan failed with ODI-1519.

ODI-1519: Serial step "Start Load Plan (InternalID:44016500)" failed because child step "Global Variable Refresh (InternalID:44017500)" is in error.
ODI-1519: Serial step "Global Variable Refresh (InternalID:44017500)" failed because child step "Warehouse Load Phase (InternalID:45512500)" is in error.
ODI-1519: Serial step "Warehouse Load Phase (InternalID:45512500)" failed because child step "1 PLP Load (InternalID:46467500)" is in error.
ODI-1519: Serial step "1 PLP Load (InternalID:46467500)" failed because child step "2 PLP Fact Group (InternalID:46510500)" is in error.
ODI-1519: Serial step "2 PLP Fact Group (InternalID:46510500)" failed because child step "Parallel (InternalID:46511500)" is in error.
ODI-1518: Parallel step "Parallel (InternalID:46511500)" failed; 1 child step(s) in error, which is more than the maximum number of allowed errors (0) defined for the parallel step. Failed child steps: OM PLP Serial (InternalID:46568500)
ODI-1519: Serial step "OM PLP Serial (InternalID:46568500)" failed because child step "3 PLP Fact OMCUSTSTATHIST_FG (InternalID:46569500)" is in error.
ODI-1519: Serial step "3 PLP Fact OMCUSTSTATHIST_FG (InternalID:46569500)" failed because child step "OMCUSTSTATHIST_FG (InternalID:46570500)" is in error.
ODI-1529: Refresh of variable "BIAPPS.TODAY_WID" failed :
SELECT ROW_WID FROM W_DAY_D WHERE W_CURRENT_CAL_DAY_CODE='Current'
ODI-1527: Error refreshing variable "BIAPPS.TODAY_WID": the associated SQL query returned no results.

 

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