New Column needed on V_SA_TRAN_ITEM_NET_ROLLED for Difference in Original and Actual Retail Price (Doc ID 3064944.1)

Last updated on DECEMBER 24, 2024

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 24.1 and later
Information in this document applies to any platform.

Goal

V_SA_TRAN_ITEM_NET_ROLLED can be used for NET_ITEM (Unit_Retail (Actual Price that sold)* QTY), however, there is no field/column for Original_Unit_Retail * QTY.
When trying to define a parameter when creating a total with this view (Original_Unit_Retail) is not displayed. Need to add a new field to to know the TOTAL difference between the Original Retail Price and Actual Retail price (sold) when the store overrides a price.

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.

New Column needed on V_SA_TRAN_ITEM_NET_ROLLED for Difference in Original and Actual Retail Price (Doc ID 3064944.1)

Applies to:

Goal

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!