My Oracle Support Banner

All the Fields of SA_TRAN_ITEM are not Included In V_SA_TRAN_ITEM_NET_ROLLED (Doc ID 2720979.1)

Last updated on NOVEMBER 09, 2020

Applies to:

Oracle Retail Sales Audit - Version 16.0.2 and later
Information in this document applies to any platform.


All of the fields from SA_TRAN_ITEM that are required in total's definition are not included in the V_SA_TRAN_ITEM_NET_ROLLED view/realm. As a result both SA_TRAN_ITEM, V_SA_TRAN_ITEM_NET_ROLLED should be added at the time of total's creation. This can be avoided by adding the missing fields in the view definition.


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

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