OBIA 11g Why is W_RCRTMNT_RQSTN_A not getting truncated when resetting before a full load?
Last updated on NOVEMBER 20, 2016
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
On : 188.8.131.52.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?
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