OBIA 11g Why is W_RCRTMNT_RQSTN_A not getting truncated when resetting before a full load? (Doc ID 1968771.1)

Last updated on NOVEMBER 20, 2016

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.8.1 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.8.1 version, DataWarehouse

Applies to datasources:
  PeopleSoft Enterprise 9.0.x
  PeopleSoft Enterprise 9.1
  PeopleSoft Enterprise 9.2
  Oracle E-Business Suite 11.5.10.x
  Oracle E-Business Suite R12.0.x
  Oracle E-Business Suite R12.1.1.x
  Oracle E-Business Suite R12.1.2.x
  Oracle E-Business Suite R12.1.3.x
  Universal Adapter for BI Applications

You are resetting the warehouse in the BIACM.  For that it should truncate then load all the warehouse tables fresh. But W_RCRTMNT_RQSTN_A table is not getting truncated. It is inserting the data into the table but its also retaining the old data. You can see that it is not added in the EXEC Maintenance Procedure before it started.

Why is W_RCRTMNT_RQSTN_A not getting truncated when resetting before a full load?

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