OTBI Receipt Amount attribute value. (Doc ID 2670204.1)

Last updated on SEPTEMBER 03, 2021

Applies to:

Goal

Customer is using one subject area, in this report we could see all the attributes data expect 'Receipt Amount' attribute value.

No value for the column : Receiving - Transactions Real Time > Receipt Amount

Roles have been verified. .

set variable LOGLEVEL = 2,PREFERRED_CURRENCY='User Preferred Currency 1';SELECT
0 s_0,
"Receiving - Transactions Real Time"."- Inventory"."Inventory Item" s_1,
"Receiving - Transactions Real Time"."- Receiving Transaction Details"."Po Header" s_2,
"Receiving - Transactions Real Time"."- Receiving Transaction Details"."Receipt Number" s_3,
"Receiving - Transactions Real Time"."- Receiving Transaction Details"."Transaction Date" s_4,
"Receiving - Transactions Real Time"."Category"."Category Name" s_5,
"Receiving - Transactions Real Time"."Receiving Inventory Organization"."Receiving Inventory Organization Business Unit Name" s_6,
"Receiving - Transactions Real Time"."Supplier Profile"."Supplier Name" s_7,
"Receiving - Transactions Real Time"."Supplier Profile"."Supplier Number" s_8,
"Receiving - Transactions Real Time"."- Receiving Transactions Line"."Actual Received Quantity" s_9,
"Receiving - Transactions Real Time"."- Receiving Transactions Line"."Item Quantity" s_10,
"Receiving - Transactions Real Time"."- Receiving Transactions Line"."Receipt Amount" s_11,
"Receiving - Transactions Real Time"."- Receiving Transactions Line"."Received Quantity" s_12,
"Receiving - Transactions Real Time"."- Receiving Transactions Line"."Transaction Quantity" s_13
FROM "Receiving - Transactions Real Time"

Solution

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