My Oracle Support Banner

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

Last updated on DECEMBER 10, 2019

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

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.