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 220.127.116.11.1 and later
Information in this document applies to any platform.
On : 18.104.22.168.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?
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