My Oracle Support Banner

OBIA 11g:FA Rel13:10.1 Introduce step to delete soft deleted records from SDS schemas in Gen LP (Doc ID 2508911.1)

Last updated on FEBRUARY 25, 2020

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.10.1 to 11.1.1.10.1 [Release 11g]
Information in this document applies to any platform.

Goal

Applies to all FA Rel13 OBIA 10.1 Customers

1) Introduced New Data store: Should be available under BI Application model
-> Platform Sub model. W_SDS_PURGE_DELETES_STATUS

2) Modified Procedure/Package: Should be available under, BI Apps Project->Components->SDS-> Generate SDS DDL

Purge Soft Deletes SDS Table/Purge Soft Deletes SDS Table

3) Modified existing procedure "TABLE_MAINT_PROC" and added new step called
"Log List of SDS to the track table - Reset_DW" to the procedure.

4) Modified bLoad plan Dev components to add/make a call to the new procedure scenario "PURGE_SOFT_DELETES_SDS_TABLE"

 

Solution

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
Goal
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.