My Oracle Support Banner

NET_ITEM Is Not Available in the V_SA_TRAN_ITEM_NET View (Doc ID 2736095.1)

Last updated on DECEMBER 28, 2020

Applies to:

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


The V_SA_TRAN_ITEM_NET view does not show NET_ITEM.

Steps to Recreate:
1. Go to Sales Audit.
2. Click on Tasks.
3. Click on Foundation Data.
4. Click on Create Total Definition.
5. Insert the values: total value, Description, Start Date, Total Category.
6. Click Next.
7. Enter the value: Display Group (1) and click Next.
8. In Realms and Joins, inform Realm Type (View (INT / EXT), Realm Name (V_SA_TRAN_ITEM_NET) and click OK and Add Another.
9. Go to Realm Type (Table (INT)), Realm Name (SA_TRAN_HEAD), and click OK.
10. Click Next.
11. In Parameters, click on the (+).
12. Inform in Realm Alias (V_SA_TRAN_ITEM_NET), Parameter Name (NET_ITEM).
13. Validate that parameter NET_ITEM is not available (No results found).


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.