My Oracle Support Banner

RN number in any Snapshot after RCS (Doc ID 2457931.1)

Last updated on JANUARY 03, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.

Goal

 Customer had a doubt that WSM_LJ_OPR_NWK_SN add lots new records after refresh but not clean up old ones.

 

the issue was on the basis that 

 

BEFORE RCS:
select RN,count(1) cnt from WSM_LJ_OPR_NWK_SN group by RN;

RN CNT
---------- ----------
2265416 1232774
2266031 616799
2266075 616799
2266405 608619
2265623 616753
2265263 615746
2265579 616753
2265942 616799
2265487 616767
2266308 618321
2266450 608619

AFTER RCS:
RN CNT
---------- ----------
2265416 1232774
2266031 616799
2266075 616799
2266405 608619
2265623 616753
2265263 615746
2265579 616753
2265942 616799
2266627 608626 <=NEW ADDITIONAL DATA
2265487 616767
2266308 618321
2266450 608619

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.