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 laterInformation in this document applies to any platform.
Symptoms
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).
Cause
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
Symptoms |
Cause |
Solution |
References |